IN THIS PART
Getting Data from External Database Files
Understanding Pivot Tables
Analyzing Data with Pivot Tables
Performing Spreadsheet What-If Analysis
Analyzing Data Using Goal Seeking and Solver
Analyzing Data with the Analysis ToolPak
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 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.