Advanced Pivot Tables: The Ticket to Self-service Dashboards

The course is presented in four parts:

First, the course illustrates where pivot tables stand in Excel Techniques, and covers the topic of when and when NOT to use a pivot table.

Second, the course illustrates how to build a self-service dashboard using:

• pivot tables
• pivot charts
• slicers
• timeline

Third, the course provides 5 extreme hacks for pivot tables including:

• How to collapse 12 months data into 1 field?
• How to break free of Pivot Tables?
• How to use Power Pivot without opening Power Pivot?
• How to connect tables without using VLOOKUP()?

Last, the course explores best practices in building a dashboard. They include:

• Do follow data table naming convention
• Do fix changing column width
• Do keep column/bar charts sorted
• Do add a heat map for pivot tables

Course Key Concepts: Artificial Intelligence, Pivot chart, Slicer, Timeline, Power Pivot, Power Query, Data model, Outline form, Calculated fields, Calculated item, Auto Refresh, VBA, Macro.