How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms.

Each of these tables contain fields you can combine in a single PivotTable to slice your data in multiple ways. No manual formatting or data preparation is necessary.

To summarize and report results from separate worksheet ranges, you can consolidate data from each separate worksheet range into a PivotTable on a master worksheet.

To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed.

In Excel, you can pivot data in a PivotTable or PivotChart by changing the field layout of the data. By using the PivotTable Field List, you can add, rearrange, or remove fields to show data in a …

Learn about the calculation methods that are available, how calculations are affected by the type of source data, and how to use formulas in PivotTables and PivotCharts. To summarize values in a …

Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.

After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. However, if the source data has been changed …

If you want to see specific data from a large data set, you can ask Copilot to create a PivotTable. With Copilot, you don't have to do a lot of steps—just ask for what you want.

In a PivotTable or PivotChart, you can expand or collapse to any level of data detail, and even for all levels of detail in one operation. On Windows and the Mac, you can also expand or collapse to a …