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.

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

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.

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 …

PivotTables are great for creating in-depth detail summaries from large datasets. You can insert one or more slicers for a quick and effective way to filter your data. Slicers have buttons you can click to …

Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.

Changing the default PivotTable settings will affect new PivotTables in any workbook. Existing PivotTables aren’t impacted by changes to the default layout. Note: This feature is available in Excel …

PivotTables have traditionally been constructed using OLAP cubes and other complex data sources that already have rich connections between tables. However, in Excel, you are free to import multiple …

Create a PivotTable to analyze worksheet data. In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.