Excel Dashboard Pro Course Page

Module 1	Dashboard Primer
Unit 1	Course Introduction
Unit 2	Why Excel?
Unit 3	Why Dashboards?
Unit 4	Interactive Dashboards in Excel
Module 2	Thinking Like a Dashboard Pro
Unit 1	Thinking Outside the Cell
Unit 2	Why Develop Differently?
Unit 3	Inserting the Camera Tool
Unit 4	Camera Tool Demo
Unit 5	Development Principles
Module 3	Working with Formulas
Unit 1	Formula Editing Tips
Unit 2	Excel’s Calculation Engine
Unit 3	Writing Better Formulas
Module 4	Lookup Functions and Array Formulas
Unit 1	Lookup Functions
Unit 2	VLookup
Unit 3	Index Match
Unit 4	Combination
Unit 5	Array Formulas
Unit 6	Array Formulas Demo
Unit 7	Array Formulas Review
Module 5	Excel Tables
Unit 1	Introduction To Excel Tables
Unit 2	Inserting an Excel Table
Unit 3	Working With Excel Tables
Unit 4	Excel Table Chart Example
Unit 5	Excel Table Rules
Module 6	Sorting & Decision Functions with Excel
Unit 1	Sorting Functions
Unit 2	Filters & SUMPRODUCT
Unit 3	Filtering on Excel Tables
Unit 4	Aggregation with Excel Tables
Unit 5	Summary of Sorting Decision Functions
Module 7	Introduction to Form Controls
Unit 1	Installing the Developer Tab
Unit 2	Excel Controls
Unit 3	Form Controls Demo
Unit 4	Form Control Basics
Unit 5	Scrollable Tables
Module 8	Formula Driven Development
Unit 1	Excel Development Styles
Unit 2	Information-Transformation-Presentation
Module 9	Interactive Legends in Excel
Unit 1	Introduction to Interactive Legends in Excel
Unit 2	Setting Up the Interactive Legend
Unit 3	Perfecting the Interactive Legend
Unit 4	Maintaining the Interactive Legend
Module 10	Interactive Chart Toggle
Unit 1	Introduction to Interactive Chart Toggles
Unit 2	Setting Up the Interactive Toggle
Unit 3	Formatting the Interactive Toggle
Unit 4	Maintaining the Interactive Toggle
Module 11	Interactive Dashboards
Unit 1	Introduction to Interactive Dashboards
Unit 2	Setting Up the Interactive Dashboard
Unit 3	Formatting the Interactive Dashboard
Unit 4	Maintaining the Interactive Dashboard
Module 12	Data Visualization Primer
Unit 1	Visual Perception
Unit 2	Gestalt Laws of Grouping
Unit 3	Preattentive Attributes
Unit 4	The Problem with Pie Charts
Unit 5	Data Visualization vs Infographics
Module 13	Expanding the Chart Library
Unit 1	Introduction to Advanced Charts
Unit 2	Dual Axis Banding
Unit 3	Area Chart Banding
Unit 4	Limit Charts
Module 14	Bullet Charts
Unit 1	Introduction to Bullet Charts
Unit 2	Bullet Charts Demo
Unit 3	Horizontal Bullet Chart Trick
Module 15	Infographics in Excel
Unit 1	Introduction to Infographics in Excel
Unit 2	Progress Meter Demo
Unit 3	Donut Chart Demo
Unit 4	Waffle Unit Chart Demo
Unit 5	Bringing it Together with the Camera Tool
Module 16	Summary
Unit 1	Review & Resources