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:
PivotTables. Examine relationships between variables using an interactive table.
Goal seeking. Use goal seeking to force a particular result in a calculation by changing one of its elements.
What-if analyses. Calculate 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.
