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 …
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.
Use slicers to filter data - Microsoft Support
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what …
Create a Data Model in Excel - Microsoft Support
Within Excel, Data Models are used transparently, providing data used in PivotTables, PivotCharts, and Power View reports. You can view, manage, and extend the model using the …
Use PivotTables and other business intelligence tools to analyze …
Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.
Find out which data sources are used in a workbook data model
If you're working with data that's been added to an Excel data model, then sometimes, you may lose track of which tables and data sources were added to the data model. Note: Make sure …
Create a relationship between tables in Excel - Microsoft Support
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 …
Power Pivot - Overview and Learning - Microsoft Support
In the following sections, you’ll find additional resources and tutorials that go into detail about how to use Power Pivot, and how it can be combined with Power Query and Power View to perform …
GETPIVOTDATA function - Microsoft Support
If the pivot_table argument is not a range in which a PivotTable is found, GETPIVOTDATA returns #REF!. If the arguments do not describe a visible field, or if they include a report filter in which …
Use the Field List to arrange fields in a PivotTable
Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.