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
Create Pivot Table
Complete and Continue
Discussion
58
comments
Load more
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login
58 comments