Chapter    6

Using Excel’s Built-In Functions

As you saw in the previous chapter, a function is a predefined formula for performing a standard calculation. Excel includes several hundred built-in functions that you can simply insert in a cell and provide with the data they need to deliver the answer. Functions save you from having to create complex formulas from scratch and from getting such formulas wrong, so when you need to perform a standard calculation, check whether Excel has a function for it. There’s no point in reinventing the wheel.

In this chapter, you’ll learn how to insert functions into your worksheets using the various tools that Excel provides, how to find the functions you want, and how to point the functions to the data they ...

Get Learn Excel 2016 for OS X, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.