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

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.

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 …

Although Excel can tell you when a relationship is needed, it can't tell you which tables and columns to use, or whether a table relationship is even possible. Try following these steps to …

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 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 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 that case, you’ll connect to the external data source, and then create a PivotTable to summarize, analyze, explore, and present that data. Here’s how to create a PivotTable by …

You can create multiple page fields and assign your own item names for each source range. This lets you create partial or full consolidations; for example, one page field that consolidates …