Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - How does the Dfunctions work

excel training onsite - How does the Dfunctions work

ResolvedVersion Standard

Wed 15 Aug 2007, 12:39 Delegate Felix said...

Felix has attended:
Excel Advanced course

How does the Dfunctions work

Please let me know

Felix

Wed 15 Aug 2007, 14:16 Trainer Amanda said...

RE: How does the Dfunctions work

Hi Felix

Thank you for your question.

Microsoft Excel includes Database functions that analyse data stored in lists or databases (e.g. DSUM, DAVERAGE, DMIN, DMAX). Each of these functions, referred to collectively as the Dfunctions, uses three arguments: database, field, and criteria. These arguments refer to the worksheet ranges that are used by the function.

I hope this helps.
Amanda

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel training onsite - How does the Dfunctions work

How does the Dfunctions work

RE: How does the Dfunctions work

Excel articles

Excel tip:

Showing all menu items