PivotTables Extended (FULL COURSE)

Banner showing the post is advertising PivotTables extended video

Demonstration of advanced functionality when using PivotTables.

The topics:

  • 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