From the course: Excel 2016: Advanced Formulas and Functions
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Formulas tab for locating functions
From the course: Excel 2016: Advanced Formulas and Functions
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…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
Hierarchy of operations in formulas6m 28s
-
Formulas tab for locating functions5m 34s
-
Insert Function for learning about unfamiliar functions5m 20s
-
Extending the capabilities of AutoSum6m 10s
-
Absolute and relative references5m 4s
-
Using mixed references in formulas6m
-
Using autocalculate in the status bar5m 45s
-
-
-
-
-
-
-
-
-
-
-
-