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

Excel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows.

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

PivotTables are great for analyzing and reporting on your data. And when your data happens to be relational—meaning it's stored in separate tables you can bring together on common values—you can build a PivotTable.

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.

Excel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows.

On the PivotTable Analyze tab, in the PivotTable group, click Options. In the PivotTable Options dialog box, on the Totals & Filters tab, do one of the following: To display grand totals, select either Show grand totals for columns or Show grand totals for rows , or both.

You can choose a different summary function, such as, Average, Max, or Min, to further analyze and customize your data. You can also create your own formulas that use elements of the report or other worksheet data by creating a calculated field or a calculated item within a field.

Click PivotTable Analyze (on the ribbon) > Options > Show Report Filter Pages. In the Show Report Filter Pages dialog box, select a report filter field, and then click OK . Filter by selection to display or hide selected items only

Select on the PivotTable Table and PivotChard wizard icon on the Quick Access Toolbar. On Step 1 page of the wizard, select Multiple consolidation ranges, and then select Next. On Step 2a page of the wizard, select I will create the page fields, and then select Next.