From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Database functions - Microsoft Excel for Mac Tutorial
From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Database functions
- [Instructor] We're looking at a worksheet called DBFunctions in our chapter 6 file. There's a number of functions that are referred to collectively as database functions, and we see them in column J. Notice they all begin with the letter D, and they're followed by function names you're probably familiar with like sum and average and count and so on, max and min. Now oddly enough, if you were looking for these by way of the formulas tab, where we can track down all functions, we will not find these functions listed. You might think they'd be under statistical, but they're not. Like, they're nowhere to be found anywhere in this list. So that maybe suggests that these are on their way out, and some of the ways that we're about to use these functions could be done by using count if, sum if, those kinds of functions. Let's show how this works. These functions also use a structure very similar to what you might be familiar with if you've used the advanced filter. So some knowledge of that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.