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 …

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, you can add, rearrange, or remove fields to show data in a …

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.

Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.

The Data Model functionality is built into Excel. Just add data in multiple tables in Excel and then create relationships between them in a PivotTable or Power View sheet.

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 …

Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.

In the Excel window, click Power Pivot> Calculations> Measures> New Measure. In the Measure dialog box, for Table name, click the down arrow, and then select the table you want the …

Use different ways to calculate values in calculated fields in a PivotTable report in Excel.