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
Chapter 32
Importing and Cleaning Data
Chapter 33
Introducing Pivot Tables
Chapter 34
Analyzing Data with Pivot Tables
Chapter 35
Performing Spreadsheet What-If Analysis
Chapter 36
Analyzing Data Using Goal Seeking and Solver
Chapter 37
Analyzing Data with the Analysis ToolPak