Basics of the Pivot Table
- Introduction & Course Content
- Getting your data ready for Pivot Table
- Creating the Pivot Table
- Grouping and Ungrouping in Pivot Tables
- Collapsing and Expanding in Pivot tables
- Field Settings in Pivot Tables
- Introduction to Slicers in Pivot Tables
- Introduction to Timeline in Pivot Table
- End of Section Practice Exercise
- Solution to the Review Homework
Applying Filters in Pivot Tables
- Date Filters in Pivot tables
- Value Filters in Pivot Tables
- Label Filters in Pivot Tables
- End of Section Practice Exercise
- Solution to the Review Homework
More on the Pivot Table Ribbon
- Selecting, Clearing, Moving & Copying Pivot Tables
- Refreshing & Updating Pivot Tables
- Layout group on the ribbon
- Layout in Pivot tables
- Style options in Pivot Tables
- Calculated field in Pivot Tables
- Calculated field items in Pivot Tables
- End of Section Practice Exercise
- Solution to the Review Homework
Conditional Formatting in Pivot Tables
- Introduction to Conditional formatting in Pivot Tables
- Highlight cells rules
- Top Bottom rules
- Data bars, Color Scales and Icon Sets
- New rule, clear rules and manage rules
- End of Section Practice Exercise
- Solution video to the review exercise
Pivot Charts
- Introduction to Pivot Charts
- Inserting Pivot Charts
- Combining pivot charts
- Changing chart types in pivot charts
- Basic data filtering in pivot charts
- Formatting in pivot charts
