Using database functions like DSUM, DAVERAGE, and DMAX


show more Using database functions like DSUM, DAVERAGE, and DMAX provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Using database functions like DSUM, DAVERAGE, and DMAX

In Excel there is a category of functions called database functions, and although less frequently used in the past because of the SUMIF family of functions has been expanded greatly, these database functions rely on the kinds of criteria ranges used with the Advanced Filter. If you haven't used the Advanced Filter these might seem a little strange to you. But there are some advantages here and there. And these functions do mesh well with those Advanced Filter applications, particularly when you've got unusual calculations SUMIF and COUNTIF can't handle.

Now for reference in Column J I've simply listed here the various database functions. If you remove the letter D from each of these of course you probably recognize most of those anyway. Now here is a strange thing. In Excel 2007 and in Excel 2010 if you're a little bit curious about these database functions, you heard a little bit about them, if you go to the Formulas tab you say, "Well, I don't see them here, ...

Using database functions like DSUM, DAVERAGE, and DMAX
Video duration: 3m 43s 1h 32m Appropriate for all

Viewers:

Using database functions like DSUM, DAVERAGE, and DMAX provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...