| 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 |
