O'Reilly logo

Microsoft Office 2008 for Macintosh: Visual QuickStart Guide by Steve Schwartz

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 15. Data Analysis

Excel provides several excellent tools to help you analyze worksheet data. In this chapter, you’ll be introduced to the following data analysis tools:

  • PivotTablesExamine relationships between variables using an interactive table.

  • Goal seekingUse goal seeking to force a particular result in a calculation by changing one of its elements.

  • What-if analysesCalculate equations with one or two unknown variables by substituting user-provided test values called scenarios.

✓ Note

  • Much of the functionality of the add-ins provided with previous versions of Excel is now built into Excel 2008.

Working with PivotTables

A PivotTable is an interactive table that helps you summarize and analyze data from existing lists and tables. PivotTables ...

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