Unit 1 |
Course Introduction |
Unit 2 |
Why Excel? |
Unit 3 |
Why Dashboards? |
Unit 4 |
Interactive Dashboards in Excel |
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 |
Unit 1 |
Formula Editing Tips |
Unit 2 |
Excel’s Calculation Engine |
Unit 3 |
Writing Better 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 |
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 |
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 |
Unit 1 |
Installing the Developer Tab |
Unit 2 |
Excel Controls |
Unit 3 |
Form Controls Demo |
Unit 4 |
Form Control Basics |
Unit 5 |
Scrollable Tables |
Unit 1 |
Excel Development Styles |
Unit 2 |
Information-Transformation-Presentation |
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 |
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 |
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 |
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 |
Unit 1 |
Introduction to Advanced Charts |
Unit 2 |
Dual Axis Banding |
Unit 3 |
Area Chart Banding |
Unit 4 |
Limit Charts |
Unit 1 |
Introduction to Bullet Charts |
Unit 2 |
Bullet Charts Demo |
Unit 3 |
Horizontal Bullet Chart Trick |
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 |
Unit 1 |
Review & Resources |