Interactive Dashboards with Excel
Module 01A - Introduction to Interactive Dashboards with Excel (Why Excel) 
Module 01B - Introduction to Interactive Dashboards with Excel (Why Dashboards) 
Module 01C - Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo) 
Module 02A - Thinking Outside the Cell (Introduction) 
Module 02B - Thinking Outside the Cell (Why Develop Differently) 
Module 02C - Thinking Outside the Cell (Inserting the Camera Tool) 
Module 02D - Thinking Outside the Cell (Using the Camera Tool) 
Module 02E - Thinking Outside the Cell (Development Principles) 
Module 03A - Working with Formulas (Formula Editing Tips) 
Module 03B - Working with Formulas (Excel's Calculation Engine) 
Module 03C - Working with Formulas (Writing Better Formulas) 
Module 04A - Lookup Functions (Introduction) 
Module 04B - Lookup Functions (VLOOKUP, INDEX, MATCH) 
Module 04C - Lookup Functions (Array Formulas) 
Module 04D - Lookup Functions (Array Formulas Review) 
Module 05A - Excel Tables (Introduction) 
Module 05B - Excel Tables (Inserting an Excel Table) 
Module 05C - Excel Tables (Working with Tables) 
Module 05D - Excel Tables (Excel Table Chart) 
Module 05E - Excel Tables (Excel Table Rules) 
Module 06A - Sorting and Decision Function with Excel Tables (Sorting Functions) 
Module 06B - Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT) 
Module 06C - Sorting and Decision Function with Excel Tables (Filtering on Excel Tables) 
Module 06D - Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables) 
Module 06E - Sorting and Decision Function with Excel Tables (Summary) 
Module 07A - Introduction to Form Controls (Enabling the Developer Tab) 
Module 07B - Introduction to Form Controls (Excel Controls) 
Module 07C - Introduction to Form Controls (Form Control Basics) 
Module 08A - Formula Driven Development (Introduction) 
Module 08B - Formula Driven Development (Information-Transformation-Presentation) 
Module 09A - Interactive Legends in Excel (Setting Up the Interactive Legend) 
Module 09B - Interactive Legends in Excel (Perfecting the Interactive Legend) 
Module 10A - Interactive Chart Toggle (Setup) 
Module 10B - Interactive Chart Toggle (Formatting) 
Module 10C - Interactive Chart Toggle (Maintenance) 
Module 11A - Interactive Dashboards (Setup) 
Module 11B - Interactive Dashboards (Formatting) 
Module 11C - Interactive Dashboards (Maintenance) 
Module 12A - Primer on Data Visualizations (Visual Perception) 
Module 12B - Primer on Data Visualizations (Gestalt Laws of Grouping) 
Module 12C - Primer on Data Visualizations (Preattentive Attributes) 
Module 12D - Primer on Data Visualizations (The Problem with Pie Charts) 
Module 12E - Primer on Data Visualizations (Data Vis vs Infographics) 
Module 13A - Expanding the Chart Library (Dual Axis Banding) 
Module 13B - Expanding the Chart Library (Area Chart Banding) 
Module 13C - Expanding the Chart Library (Limit Charts) 
Module 14A - Bullet Charts in Excel (Building the Chart) 
Module 14B - Bullet Charts in Excel (Horizontal Bullet Chart Trick) 
Module 15A - Infographics (Introduction) 
Module 15B - Infographics (Progress Meter) 
Module 15C - Infographics (Donut Chart) 
Module 15D - Infographics (Waffle Chart) 
Module 15E - Infographics (Bringing it Together with the Camera) 
Module 16 - Summary ​​