课程: Excel 2016: Managing and Analyzing Data

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Using database functions including DSUM, DAVERAGE, DMAX

Using database functions including DSUM, DAVERAGE, DMAX

课程: Excel 2016: Managing and Analyzing Data

开始一个月试用 购买团队方案

Using database functions including DSUM, DAVERAGE, DMAX

“

- [Voiceover] Excel has a category of functions called Database functions. We're looking at a worksheet called DB functions. Now what if you heard that phrase, database function, said I wonder what these are all about. I'm gonna go to the Forumlas tab here, and see if we can track down these functions. Well, we've got financial, logical, text, I don't see database here, but we do have this category out here, called More Functions. Let's click this. And what do we see, we're not seeing database. That's a bit strange. Now, if we click on an empty cell somewhere, and then, just to the left of the Formula bar, click the fx button, under Select a Category, drop arrow, there's that category called database. And we see a bunch of functions here, notice how they all begin with the letter D and many of them are followed by functions that you probably recognize, like average and max and min and so on. Let's cancel here and use…

内容