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

Build PivotTables by using related tables in the Field List. You can import related tables from databases, or set relationships in Power Pivot after you import.

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.

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

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 …

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.

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Create a PivotTable to analyze worksheet data Create a PivotTable to analyze …

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 …

First create a PivotTable that is based on the same data source as the PivotTable that already has the slicer you want to reuse. Select the slicer you want to share in another PivotTable.