Share Description
In this course, you will learn :
- Pivot Tables
- Pivot Table Caluculations
- Grouping within Pivot Tables
- Calculated Fields in Pivot Tables
- Slicers and Timelines in Pivot Tables
Syllabus :
1. Pivot Table Basics
- Creating our First Pivot Table
- Changing the Default Calculations
- Formatting PivotTable Data
- Filtering the Pivot Table Data
- Managing the Data Source of Listed Data or Range Data
- Moving and Managing Pivot Tables
2. Slicers and Timelines
- Filtering with the Slicer Tool
- Filtering with the Timeline Tool
- Connecting Slicers and Timelines to Multiple Pivot Tables
- Pivot Table from Table Data Vs List Data (Range) - PT
- Grouping Data on Pivot Tables
