Querying large amounts of data in many user-friendly ways.
Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.
Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want.
Presenting concise, attractive, and annotated online or printed reports.
In this example the source data contains information about food sales, in two regions.
Select any cell in the source data table.
In the Tables group, click PivotTables.
Create Pivot table dialog appear.