From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Formulas tab for locating functions

Formulas tab for locating functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Formulas tab for locating functions

“

- Built into Excel are over 450 functions. Everybody seems to know SUM. A lot of people use AVERAGE. And of course, there are many, many more. How do we track them down? How do we get some sort of a handle on which functions are available? In the ribbon menu system we've got a Formulas tab, and we see some categories. This is often a decent place to start. You don't necessarily get enough information here, but imagine you were in a situation where you might want to use, for example, a standard deviation, using a set of numbers like this maybe. Where do we begin? What kind of a function is that? Is it financial? And how do we know where to look? Many times the name of a function begins with a letter that you would think it begins with. Standard deviation probably should begin with an S. We don't see it here under Financial. Is that a Financial application? I think we're more likely to categorize that as a Statistical kind of function. But what do we see here? Logical, Text, others…

Contents