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

Get Excel 2013 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.