Part V: Analyzing Data with Excel
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.
Get Excel® 2010 Bible 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.