Excel TV

Academy course

Excel Dashboard Pro

67 lessons across 17 modules · Jordan Goldmeier

Excel Dashboard Pro

What’s in this course

Dashboard Primer

  • Course Introduction
  • Why Excel?
  • Why Dashboards?
  • Interactive Dashboards in Excel

Thinking Like A Dashboard Pro

  • Thinking Outside the Cell
  • Why Develop Differently?
  • Inserting the Camera Tool
  • Camera Tool Demo
  • Development Principles

Working With Formulas

  • Formula Editing Tips
  • Excel’s Calculation Engine
  • Writing Better Formulas

Lookup Functions And Array Formulas

  • Lookup Functions
  • VLookup
  • Index Match
  • Combination
  • Array Formulas
  • Array Formulas DEMO
  • Array Formulas Review

Excel Tables

  • Introduction to Excel Tables
  • Inserting an Excel Table
  • Working with Excel Tables
  • Excel Table Chart Example
  • Excel Table Rules

Sorting & Decision Functions With Excel

  • Sorting Functions
  • Filters & SUMPRODUCT
  • Filtering on Excel Tables
  • Aggregation with Excel Tables
  • Summary of Sorting Decision Functions

Introduction to Form Controls

  • Installing the Developer Tab
  • Excel Controls
  • Form Controls DEMO
  • Form Control BASICS
  • Scrollable Tables

Formula Driven Development

  • Excel Development Styles
  • Information-Transformation-Presentation

Interactive Legends in Excel

  • Introduction to Interactive Legends in Excel
  • Setting Up the Interactive Legend
  • Perfecting the Interactive Legend
  • Maintaining the Interactive Legend

Interactive Chart Toggle

  • Introduction to Interactive Chart Toggle
  • Setting Up the Interactive Toggle
  • Formatting the Interactive Toggle
  • Maintaining the Interactive Toggle

Interactive Dashboards

  • Introduction to Interactive Dashboards
  • Setting Up the Interactive Dashboard
  • Formatting the Interactive Dashboard
  • Maintaining the Interactive Dashboard

Data Visualization Primer

  • Visual Perception
  • Gestalt Laws of Grouping
  • Preattentive Attributes
  • The Problem with Pie Charts
  • Data Visualization vs Infographics

Expanding the Chart Library

  • Introduction to Advanced Charts
  • Dual Axis Banding
  • Area Chart Banding
  • Limit Charts

Bullet Charts

  • Introduction to Bullet Charts
  • Bullet Charts DEMO
  • Horizontal Bullet Chart Trick

Infographics in Excel

  • Introduction to Infographics in Excel
  • Progress Meter DEMO
  • Donut Chart DEMO
  • Waffle Unit Chart DEMO
  • Bringing It All Together with the Camera Tool

Summary

  • Review & Resources

Get The Downloads

  • Get All the Labs and Files

Curriculum

Dashboard Primer 4 lessons
  1. 1. Course Introduction
  2. 2. Why Excel?
  3. 3. Why Dashboards?
  4. 4. Interactive Dashboards in Excel
Thinking Like A Dashboard Pro 5 lessons
  1. 1. Thinking Outside the Cell
  2. 2. Why Develop Differently?
  3. 3. Inserting the Camera Tool
  4. 4. Camera Tool Demo
  5. 5. Development Principles
Working With Formulas 3 lessons
  1. 1. Formula Editing Tips
  2. 2. Excel's Calculation Engine
  3. 3. Writing Better Formulas
Lookup Functions And Array Formulas 7 lessons
  1. 1. Lookup Functions
  2. 2. VLookup
  3. 3. Index Match
  4. 4. Combination
  5. 5. Array Formulas
  6. 6. Array Formulas DEMO
  7. 7. Array Formulas Review
Excel Tables 5 lessons
  1. 1. Introduction to Excel Tables
  2. 2. Inserting an Excel Table
  3. 3. Working with Excel Tables
  4. 4. Excel Table Chart Example
  5. 5. Excel Table Rules
Sorting & Decision Functions With Excel 5 lessons
  1. 1. Sorting Functions
  2. 2. Filters & SUMPRODUCT
  3. 3. Filtering on Excel Tables
  4. 4. Aggregation with Excel Tables
  5. 5. Summary of Sorting Decision Functions
Introduction to Form Controls 5 lessons
  1. 1. Installing the Developer Tab
  2. 2. Excel Controls
  3. 3. Form Controls DEMO
  4. 4. Form Control BASICS
  5. 5. Scrollable Tables
Formula Driven Development 2 lessons
  1. 1. Excel Development Styles
  2. 2. Information-Transformation-Presentation
Interactive Legends in Excel 4 lessons
  1. 1. Introduction to Interactive Legends in Excel
  2. 2. Setting Up the Interactive Legend
  3. 3. Perfecting the Interactive Legend
  4. 4. Maintaining the Interactive Legend
Interactive Chart Toggle 4 lessons
  1. 1. Introduction to Interactive Chart Toggle
  2. 2. Setting Up the Interactive Toggle
  3. 3. Formatting the Interactive Toggle
  4. 4. Maintaining the Interactive Toggle
Interactive Dashboards 4 lessons
  1. 1. Introduction to Interactive Dashboards
  2. 2. Setting Up the Interactive Dashboard
  3. 3. Formatting the Interactive Dashboard
  4. 4. Maintaining the Interactive Dashboard
Data Visualization Primer 5 lessons
  1. 1. Visual Perception
  2. 2. Gestalt Laws of Grouping
  3. 3. Preattentive Attributes
  4. 4. The Problem with Pie Charts
  5. 5. Data Visualization vs Infographics
Expanding the Chart Library 4 lessons
  1. 1. Introduction to Advanced Charts
  2. 2. Dual Axis Banding
  3. 3. Area Chart Banding
  4. 4. Limit Charts
Bullet Charts 3 lessons
  1. 1. Introduction to Bullet Charts
  2. 2. Bullet Charts DEMO
  3. 3. Horizontal Bullet Chart Trick
Infographics in Excel 5 lessons
  1. 1. Introduction to Infographics in Excel
  2. 2. Progress Meter DEMO
  3. 3. Donut Chart DEMO
  4. 4. Waffle Unit Chart DEMO
  5. 5. Bringing It All Together with the Camera Tool
Summary 1 lesson
  1. 1. Review & Resources
Get The Downloads 1 lesson
  1. 1. Get All the Labs and Files
Member access: Lesson videos and downloadable resources require academy login. Existing members get the same access they had on academy.excel.tv.