Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/create-…
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/overvie…
Overview of PivotTables and PivotCharts - Microsoft Support
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.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/use-mul…
Use multiple tables to create a PivotTable in Excel
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.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/use-piv…
Use PivotTables and other business intelligence tools to analyze your ...
Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/create-…
Create a PivotChart - Microsoft Support
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.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/power-p…
Power Pivot - Overview and Learning - Microsoft Support
The following links and information can get you going with Power Pivot, including how to enable Power Query in Excel, how to get started using Power Pivot, then tutorials, and community connections.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/learn-t…
Learn to use Power Query and Power Pivot in Excel
With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/topic/create-p…
Create PivotTables with Copilot in Excel - Microsoft Support
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. The more details you include, the more accurate and useful Copilot's results will be.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/subtota…
Subtotal and total fields in a PivotTable - Microsoft Support
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 grand totals with or without filtered items.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/group-o…
Group or ungroup data in a PivotTable - Microsoft Support
In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.