O'Reilly logo

Learn Excel 2016 for OS X, Second Edition by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required