Analyzing Data with 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.
A PivotTable is a powerful data-analysis tool in ...