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.
Video: Create a PivotTable and analyze your data - Microsoft …
Excel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows.
Pivot data in a PivotTable or PivotChart - Microsoft Support
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 PivotTable or PivotChart exactly the way that you want.
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.
Create a Data Model in Excel - Microsoft Support
A Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook. Within Excel, Data Models are used transparently, providing tabular data used in PivotTables and PivotCharts.
GETPIVOTDATA function - Microsoft Support
You can quickly enter a simple GETPIVOTDATA formula by typing = (the equal sign) in the cell you want to return the value to and then clicking the cell in the PivotTable that contains the data you want to return.
Design the layout and format of a PivotTable - Microsoft Support
In Excel, you can change the layout and format of the PivotTable data to make it easier to read and scan.
Use slicers to filter data - Microsoft Support
To create slicers for tables, data model PivotTables, or Power BI PivotTables, please use Excel for Windows or Excel for Mac. Create a slicer to filter data in a PivotTable Click anywhere in the PivotTable.
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.
Insert a PivotTable - Microsoft Support
PivotTables are great ways to summarize, analyze, explore, and present summary data, and in Excel for the web you can also collaborate with someone on a PivotTable at the same time.