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.
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.
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 …
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.
Create a Measure in Power Pivot - Microsoft Support
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 …
Use slicers to filter data - Microsoft Support
In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK. A slicer will be created for every field that you selected.
Create a PivotTable timeline to filter dates - Microsoft Support
Click Analyze > Insert Timeline to add one to your worksheet. Much like a slicer for filtering data, you can insert a Timeline one time, and then keep it with your PivotTable to change the range …
Calculate values in a PivotTable - Microsoft Support
Use different ways to calculate values in calculated fields in a PivotTable report in Excel.
Use multiple tables to create a PivotTable in Excel
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 PivotTable with an external data source
Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.