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, especially if the result isn't round.
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 ...
Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
