- Introduction
- Understanding Dataset
- The Importance of Cleaning Data
- Formatting Data as a Table
- Creating a PivotTable
- Analyzing Data by Pivoting Table Fields
- Grouping Data
- Value Field Settings
- Number Formatting
- Sub-totals and Grand Totals
- Report Layouts
- PivotTable Styles
- Creating Pivot Charts from PivotTables
- Filtering with Slicers
- Updating Data
Syllabus
Taught by
Simon Sez IT