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

Get Microsoft Office 2008 for Macintosh: Visual QuickStart Guide 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.