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