Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel Dashboards & Data Visualization Masterclass
1 - Introduction
1.1 Introduction (0:49)
1.2 Why Even Use Excel? (7:35)
1.3 Why Dashboards + Datavis? (5:23)
1.4 Interactive Dashboards in Excel (10:19)
1.5 Quiz
2 - Thinking Outside the Cell
2.1 Thinking Outside the Cell (6:47)
2.2 Why develop differently (3:40)
2.3 Inserting the camera tool (2:57)
2.4 How to use the camera tool (7:54)
2.5 Development Principles (12:49)
2.6 Quiz
3 - Working with Formulas
3.1 Formula Editing Tips (11:52)
3.2 Excel Calculation Engine (9:08)
3.3 Writing Better Formulas (11:10)
3.6 Quiz
4 - Advanced Formulas for Dashboards & Decisions
4.1 Lookup Functions (2:44)
4.2 How to use VLOOKUP (3:24)
4.3 How to use INDEX/MATCH (6:28)
4.4 Combining formulas (4:24)
4.5 How to use Array Formulas (2:49)
4.6 Array Formulas Demo (20:44)
4.7 Section Review (2:20)
4.8 Quiz
4.9 Practice
5 - Excel Tables are the Best!
5.1 Introduction to Excel Tables (3:43)
5.2 Inserting a New Excel Table (8:35)
5.3 Working with Tables (7:29)
5.4 Excel Tables Demo (4:34)
5.5 Rules for using Excel Tables (2:35)
5.6 Quiz
5.7 Practice
6 - Sorting and Decision Functions
6.1 Introduction to Sorting Functions (19:20)
6.2 Creating Filters with SUMPRODUCT (1:38)
6.3 Filtering on Excel Tables (17:26)
6.4 Data Aggregation (13:26)
6.5 Section Summary (2:12)
6.6 Quiz
6.7 Practice
7 - Form Controls for Interactivity
7.1 The DEVELOPER Tab (1:32)
7.2 Excel Form Controls (3:44)
7.3 Form Controls Demo (14:55)
7.4 Form Control Basics (1:59)
7.5 Creating a Scrollable Table (7:26)
7.6 Quiz
7.7 Practice
8 - Formula-driven Development
8.1 Introduction to Formula-driven Development (29:11)
8.2 The Information-Transformation-Presentation Dynamic (5:06)
8.3 Quiz
9 - Creating an Interactive Legend Dashboard
9.1 Section Introduction (1:50)
9.2 Creating an Interactive Legend (7:18)
9.3 Perfecting the Interactive Legend (16:50)
9.4 Maintaining the Interactive Legend (3:11)
9.5 Practice
10 - Creating an Interactive Chart Dashboard
10.1 Section Introduction (0:38)
10.2 Setting up an Interactive Chart (6:56)
10.3 Formatting the Interactive Chart (5:04)
10.4 Maintaining the Interactive Chart (2:51)
10.5 Practice
11 - Interactive Tornado Dashboard with Drill Downs
11.1 Section Introduction (0:41)
11.2 Setting up the Interactive Dashboard (15:27)
11.3 Formatting the Interactive Dashboard (1:49)
11.4 Maintaining the Interactive Dashboard (2:58)
11.5 Practice 1
11.6 Practice 2
12 - Data Visualization
12.1 Introduction to Visual Perception (8:22)
12.2 The Gestalt Laws of Grouping (4:37)
12.3 Preattentive Attributes (2:34)
12.4 The Problem with Pie Charts (1:45)
12.5 Introduction to Infographics (2:01)
12.6 Quiz
13 - Special Charts
13.1 Expanding the Chart Library (0:26)
13.2 Dual Axis Band Chart (4:21)
13.3 Shaded Area Banded Chart (4:31)
13.4 Limit and Control Charts (3:11)
14 - Bullet Charts
14.1 Introduction to Bullet Charts in Excel (1:28)
14.2 Bullet Chart Demo (7:00)
14.3 Horizontal Bullet Chart Trick (4:03)
14.4 Practice
15 - Infographics in Excel
15.1 Introduction to Infographics in Excel (1:17)
15.2 Progress Meter Chart (8:44)
15.3 Donut Chart (6:01)
15.4 "Waffle" Chart (5:58)
15.5 Bringing it all together with the CAMERA (2:13)
15.6 Practice
16 - Conclusion
Continue Learning! (2:38)
1.1 Introduction
Complete and Continue