Part V
Analyzing Data with Excel

Excel is a superb data-analysis tool — if you know how to extract the information you really need. In this part, you'll learn how to obtain, clean up, and analyze data in Excel. As you'll see, many of the data-analysis capabilities in Excel are both surprisingly powerful and easy to use.

In This Part

1. Chapter 32
   Importing and Cleaning Data
2. Chapter 33
   Introducing Pivot Tables
3. Chapter 34
   Analyzing Data with Pivot Tables
4. Chapter 35
   Performing Spreadsheet What-If Analysis
5. Chapter 36
   Analyzing Data Using Goal Seeking and Solver
6. Chapter 37
   Analyzing Data with the Analysis ToolPak
7. Chapter 38
   Working with Get & Transform