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 …

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

Sometimes it's hard to see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a …

Use the Data Model to create a new PivotTable Note Data Models are not supported on Excel for Mac. Relational databases are not …

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, …

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

Use the PivotTable Options dialog box to control various settings for a PivotTable in Excel for Windows and Excel for Mac (desktop). …

Show or hide subtotals and grand totals in a PivotTable to add or remove them, and calculate them with or without filtered items.

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

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, …