Chapter 5. USING FUNCTIONS

Understanding the Function Wizard

Excel's Function Wizard simplifies the use of functions. You can use the wizard with every one of Excel's functions, from the SUM function to complex statistical, mathematical, financial, or engineering functions.

There are two ways to access the Function Wizard. You can select the cell where the result is to appear, click the Insert Function button (fx), and then use the Insert Function dialog box to find the function you want. The Insert Function dialog box provides you with two ways to find a function. You can type a description of the function in the Search for a Function field and then click Go. Excel will retrieve all the relevant functions and list them in the Select a Function ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition 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.