Overview
-
Explore quick, bite-sized tips on how to analyze data quickly with PivotTables in Microsoft Excel.
Syllabus
-
Introduction
- Analyze your data quickly with PivotTables
- Get data ready for a PivotTable
- Create a basic PivotTable
- Use a recommended PivotTable
- Rearrange a PivotTable
- Calculate values in a PivotTable
- Summarize values in a PivotTable
- Expand and collapse details in a PivotTable
- Format data in a PivotTable
- Group data in a PivotTable
- Filter data in a PivotTable
- Sort data in a PivotTable
- Apply conditional formatting to a PivotTable
- Remove conditional formatting from a PivotTable
- Create a basic PivotChart
- Insert slicers into a PivotTable
- PivotTable error messages: Field name not valid
- Refresh a PivotTable
- PivotTable error messages: Overlapping reports
