Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Overview of PivotTables and PivotCharts - Microsoft Support
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 …
Design the layout and format of a PivotTable - Microsoft Support
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. To change the format of the …
Expand, collapse, or show details in a PivotTable or PivotChart
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 …
Use multiple tables to create a PivotTable in Excel
Use multiple tables to create a PivotTable in Excel. PivotTables are great for analyzing and reporting on your data. And when your data happens to be relational—meaning it's stored in …
Group or ungroup data in a PivotTable - Microsoft Support
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.
Consolidate multiple worksheets into one PivotTable in Excel
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. The separate …
Use PivotTables and other business intelligence tools to analyze …
Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.
Subtotal and total fields in a PivotTable - Microsoft Support
When working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the …
Create a PivotTable with an external data source
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.
Set PivotTable default layout options - Microsoft Support
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 …