Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Data Visualization in Excel: Unveiling Insights with Dashboards
Introduction to the Course
1. Introduction To The Course (8:27)
2. Introduction Of The Instructor (3:11)
3. Course Requirements (2:59)
4. How To Get Excel (4:14)
Source files
Dashboards Introduction
1. What Will We Learn In This Section (1:20)
2. What Are Dashboards (5:39)
3. Answers You Need Before You Start A Dashboard (7:45)
4. Best Practices For Dashboard Layout (4:42)
5. Best Practices For Dashboard Colors (3:54)
6. Section Summary (3:40)
Source Code
Build a Dashboard Project
1. What Will We Learn In This Section (1:16)
2. Build A Wireframe In Excel (5:42)
3. Prepare Raw Data For Dashboard (5:57)
4. Prepare Calculation Sheet (13:01)
5. Section Summary (6:08)
Source Code
Scrolling Data Table
1. What Will We Learn In This Section (2:48)
2. Build A Combo Box (10:44)
3. Complex Lookup (14:36)
4. Build A Scrolling Data Table (11:41)
5. Conditionally Format Actual Values Vs Budgeted Values (10:52)
6. Conditional Headers (9:25)
7. Section Summary (3:01)
Source Code
Show Top Indicators
1. What Will We Learn In This Section (1:50)
2. Show Top Matches Over And Under Budget (9:21)
3. List Box To Select Indicators (5:11)
4. Toggle Between Top Over Or Under (12:50)
5. Section Summary (2:19)
Source Code
Scrollable Line Chart
1. What Will We Learn In This Section (3:20)
2. Prepare Data For Scrolling Chart (14:19)
3. Scrollable Line Chart (11:17)
4. Remove Crashing Lines (4:13)
5. Toggle Visibility Of Line Series (9:56)
6. Finetune The Line Series (7:08)
7. Section Summary (5:35)
Source Code
Interactivity
1. What Will We Learn In This Section (1:56)
2. Add Interactivity To Reports With Pivot Slicers (10:44)
3. Column Chart Controlled By Slicer (6:47)
4. Pivot Slicer Sorting (4:26)
5. Select Only 1 Slicer (2:13)
6. Dynamic Comments With Slicers (11:36)
7. Section Summary (2:58)
Source Code
Finetune the Dashboard
1. What Will We Learn In This Section (1:01)
2. Add Calculations For Variances In Pivot Tables (4:23)
3. Conditional Formatting In Pivot Tables (7:04)
4. Refresh Pivot Table With Easy Vba (7:49)
5. Section Summary (2:33)
Source Code
Course Summary
1. Course Summary And Next Steps (10:27)
4. How To Get Excel
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock