Description: Demonstration of advanced functionality when using PivotTables.
Course outline:
- Formatting data for a PivotTable
- Importance of cleansing data for accuracy
- Benefit of using Format as Table command
- Working effectively with a PivotTable
- Multi-level row information
- Selecting specific sections
- Creating a Calculated field
- Controlling Automatic Grouping for date fields
- Applying Manual Grouping
- Applying Filters
- Adding a Slicer
- Adding a Timeline
- Linking Filters to multiple PivotTables
Not Enrolled
Course Includes
- 7 Lessons
- Course Certificate
Login
Accessing this course requires a login. Please enter your credentials below!