E
xcel 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 and analyze data
in Excel. As you’ll see, many of the data-analysis capabili-
ties in Excel are both surprisingly powerful and easy to use.IN THIS PART
Chapter 33
Getting Data from External
Database Files
Chapter 34
Understanding Pivot Tables
Chapter 35
Analyzing Data with Pivot Tables
Chapter 36
Performing Spreadsheet What-If
Analysis
Chapter 37
Analyzing Data Using Goal
Seeking and Solver
Chapter 38
Analyzing Data with the Analysis
ToolPakPart V
Analyzing Data
with Excel
40_474877-pp05.indd 67540_474877-pp05.indd 675 3/29/10 11:39 PM3/29/10 11:39 PM