Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Data Analysis Masterclass - Data Visualization
01. Introduction to the Course
1.1 Introduction To The Course (8:27)
1.2 Introduction Of The Instructor (3:11)
1.3 Course Requirements (2:59)
1.4 How To Get Excel (4:13)
Source files
02. Dashboards Introduction
2.1 What Will We Learn In This Section (1:20)
2.2 What Are Dashboards (5:39)
2.3 Answers You Need Before You Start A Dashboard (7:45)
2.4 Best Practices For Dashboard Layout (4:42)
2.5 Best Practices For Dashboard Colors (3:54)
2.6 Section Summary (3:40)
Source Code
03. Build a Dashboard Project
3.1 What will we learn in this section (1:16)
3.2 Build a Wireframe in Excel (5:42)
3.3 Prepare Raw Data for Dashboard (5:57)
3.4 Prepare Calculation sheet (13:01)
3.5 Section Summary (6:08)
Source Code
04. Scrolling Data Table
4.1 What will we learn in this section (2:48)
4.2 Build a Combo Box (10:44)
4.3 Complex Lookup (14:36)
4.4 Build a Scrolling Data Table (11:40)
4.5 Conditionally Format Actual Values vs Budgeted Values (10:52)
4.6 Conditional Headers (9:25)
4.7 Section Summary (3:01)
Source Code
05. Show Top Indicators
5.1 What will we learn in this section (1:50)
5.2 Show Top Matches Over and Under Budget (9:20)
5.3 List Box to Select Indicators (5:11)
5.4 Toggle Between Top Over or Under (12:50)
5.5 Section Summary (2:19)
Source Code
06. Scrollable Line Chart
6.1 What will we learn in this section (3:20)
6.2 Prepare Data for Scrolling Chart (14:19)
6.3 Scrollable Line Chart (11:17)
6.4 Remove Crashing Lines (4:12)
6.5 Toggle Visibility of Line Series (9:56)
6.6 Finetune the Line Series (7:08)
6.7 Section Summary (5:34)
Source Code
07. Interactivity
7.1 What will we learn in this section (1:56)
7.2 Add Interactivity to Reports with Pivot Slicers (10:44)
7.3 Column Chart Controlled by Slicer (6:47)
7.4 Pivot Slicer Sorting (4:26)
7.5 Select Only 1 Slicer (2:13)
7.6 Dynamic Comments with SLicers (11:36)
7.7 Section Summary (2:58)
Source Code
08. Finetune the Dashboard
8.1 What will we learn in this section (1:01)
8.2 Add Calculations for Variances in Pivot Tables (4:23)
8.3 Conditional Formatting in Pivot Tables (7:04)
8.4 Refresh Pivot Table with Easy VBA (7:49)
8.5 Section Summary (2:33)
Source Code
09. Course Summary
9.1 Course Summary and Next Steps (10:27)
1.1 Introduction To The Course
Complete and Continue
BDOW!