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

After creating a PivotTable and adding the fields that you want to analyze, you may want to enhance the report layout and format to make the data easier to read and scan for details.

Here's how you build a new PivotTable or PivotChart using the Data Model in your workbook. Click Open, and then click OK to show a Field List containing all the tables in the Data Model.

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 PivotTable, but not everyone can look at numbers in a table and quickly …

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.

Create a PivotTable with Copilot Open Excel. Make sure to format your data in a table or supported range for Copilot. Select the Copilot button in the ribbon. Ask Copilot to create a PivotTable for you. …

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.

Instead of adjusting filters to show dates, you can use a PivotTable Timeline—a dynamic filter option that lets you easily filter by date/time, and zoom in on the period you want with a slider control.

Repeating item and field labels in a PivotTable visually groups rows or columns together to make the data easier to scan. For example, use repeating labels when subtotals are turned off or there are …

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 subtotals and …