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.

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

Filter data in a PivotTable with a slicer Select any cell within the PivotTable, then on the Pivot Table Analyze tab, choose Insert Slicer. Choose the fields you want to create slicers for, and select OK. Excel will place one slicer for each selection you made onto the worksheet, but it's up to you to arrange and size them however is best for you. Select the slicer buttons to choose the items ...

If you have an existing PivotTable laid out the way you like, you can import those settings, otherwise you can edit them individually. Changing the default PivotTable settings will affect new PivotTables in any workbook. Existing PivotTables aren’t impacted by changes to the default layout.

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

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

In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.

In Excel, you can change the layout and format of the PivotTable data to make it easier to read and scan.

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 PivotTable or PivotChart exactly the way that you want.