Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Dashboard Online Course
Introduction
Getting Started (7:32)
Course Introduction (1:38)
SuperStore Excel Sheet (2:28)
Join Our Closed Facebook Group
Course Index
Pivot Table
Create Pivot Table (8:57)
Pivot Table Calculation (7:54)
Pivot Table Relationship (13:23)
Distinct Count (3:23)
Excel Dashboard Creation
Create Excel Dashboard 1 (8:34)
Create Excel Dashboard 2 - Slicer (8:33)
Create Excel Dashboard 3 - Dynamic Previous Year (11:30)
Create Excel Dashboard 4 - Dount Chart (5:30)
Create Excel Dashboard 5 - Progress Bar (6:19)
Create Excel Dashboard 6 - Top N (6:23)
Create Excel Dashboard 7 - Dashboard Design (18:54)
Create Excel Dashboard 8 - Links (7:27)
Create Excel Dashboard 9 - Hide Sheets (1:58)
Create Excel Dashboard 10 - Conditional Formatting (7:23)
Create Excel Dashboard - New Dashboard Intro (2:15)
Create Excel Dashboard - New Dashboard Dynamic Chart Color (26:51)
Create Excel Dashboard - New Dashboard Variance Color (11:17)
Create Excel Dashboard - New Dashboard Chart Drill Down (8:34)
Create Excel Dashboard - New Dashboard Sheet Link (15:31)
Create Excel Dashboard - New Dashboard Progress Bar Color (7:02)
HR Dashboard
Download HR Dashboard
Projects Dashboard
Download Projects Dashboard
Finance Dashboard
Download Finance Dashboard
Finance Dashboard Introduction (9:43)
Extra Content
Add Variance to Chart (5:06)
Percentage and Value in the Same Chart (3:54)
Zero Base Chart (3:29)
Dynamic Number Format (10:34)
Copy Excel Dashboard to PowerPoint (3:04)
Actual Vs. Target (YTD) (3:52)
Pareto Chart (11:27)
Developer Tab - Combo Box (12:15)
Developer Tab - Combo Box with Dynamic Range (19:42)
Pivot Table - Calculated Field (2:31)
Donut Chart - Dynamic Colors (11:47)
Pivot Table - Calculated Item (5:30)
Custom Sort in Pivot Table (5:42)
Summary
Course Summary (2:08)
Course Feedback
Resources
Superstore - Dashboard Example
SuperStore - Interactive Dashboard
SuperStore - Developer Tab
Ramadan 2021 Competition
Question 1 (4:06)
Answer Question 1 (4:28)
Question 2 (1:28)
Answer Question 2 (2:06)
Question 3
Answer Question 3 (0:54)
Question 4 (1:49)
Answer Question 4 (4:52)
Question 5
Answer Question 5 (2:02)
Question 6
Answer Question 6 (4:54)
Question 7
Answer Question 7 (4:47)
Datasets For Practice
Sales & Marketing - Profit Cost
Capital Project Schedules and Budgets
Best Run Corp Retail
Sales Opportunity Win-Loss
HR Employee Attrition
Sales Data
Accounts Receivable
Add Variance to Chart
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock