Join Dennis Taylor for an in-depth discussion in this video Using database functions: DSUM, DAVERAGE, DMAX, and more, part of Excel 2011 for the Mac: Managing and Analyzing Data.
- We're looking at a worksheet called DB Functions…and in this movie we want to show you how to use…some of the various database functions.…Now it looks as if these functions…might not be around forever in Excel,…in the current Windows version of Excel…these actually are a bit difficult to find.…Part of the reason that they're not as popular…is that they also require the use of what's called…a criteria range.…Now you might not know what that means.…Possibly if you've seen earlier movies…in this course, you've seen the movies on Advanced Filter,…those require a criteria range.…
The different database functions…are listed over here in column J.…DSUM and DAVERAGE are probably the ones…you're more likely to use.…When you do use these functions these two…or any of the ones below…you do need to set up a criteria range.…Now without exactly defining it…we do have an example of one here…in cells J1 over to M2.…Let's first talk about what we might wanna do…and how this works.…Let's say that we're interested in this list here…
- Multiple-key sorting
- Sorting columns left-to-right
- Filtering columns
- Creating a top-ten list with values or percentages
- Using Advanced Filter for complex filters
- Setting up subtotals
- Using the Remove Duplicates command
- Using SUMIF, COUNTIF, and related functions
- Working with the database functions, such as DSUM and DMAX
Skill Level Intermediate
Excel for Mac 2011 Essential Trainingwith Curt Frye6h 32m Beginner
1. Sorting Data
2. Filtering Data
3. Advanced Filter
4. Creating Automatic Subtotals in Sorted Lists
5. Eliminating Duplicate Data
6. Data Analysis Tools
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.