Excel Dashboard Pro Course Page – Excel TV Members
Share The LOVE

# 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