O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12

Analyzing Data with PivotTables

Understanding PivotTables

Tables and external databases can contain thousands of records. Analyzing that much data can be a nightmare without the right kinds of tools. To help, Excel offers a powerful data analysis tool called a PivotTable, which enables you to summarize hundreds of records in a concise tabular format. You can then manipulate the layout of — or pivot — the table to see different views of your data.

PivotTables help you analyze large amounts of data by performing three operations: grouping the data into categories, summarizing the data using calculations, and filtering the data to show just the records you want to work with.

Grouping

A PivotTable is a powerful data-analysis tool in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required