O'Reilly logo

Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables by Denise Etheridge

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 3. CREATING AND USING FUNCTIONS

Understanding the Function Wizard

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

You can access the Function Wizard two ways. One way involves selecting the cell where the result is to appear, clicking the Insert Function button (fx), and using the Insert Function dialog box to find a function. The Insert Function dialog box provides you with two methods you can use to find the function you want. You can type a description of the function in the Search for a Function field and then click Go. Excel retrieves all of the relevant ...

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