This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn to Build Stunning Interactive Excel Dashboards from Scratch
Introduction to Excel dashboards
About this Course (1:40)
What is a Dashboard? (0:53)
Who Uses Dashboards? (1:22)
About me (1:10)
How to go through this course (1:26)
DOWNLOADS - All the files used in this course
Module 1 - Preparing the Data
1-1: Data Introduction (1:07)
1-2: Find Existing Data on the Web (3:25)
1-3: Creating Sample Data (10:44)
1-4: Pull in csv File into Excel (2:06)
1-5: Merge 2 Excel Files and pull into spreadsheet (5:25)
1-6: Link Spreadsheet to File of Data (3:48)
1-7: Append Data to Table (4:40)
1-8: Pull in Data from the Web (3:50)
1-9: Combine Multiple Tables (2:18)
1-10: Format Data as a Table (3:37)
1-11: Clean Data with Power Query (9:33)
Homework - Data (2:12)
Homework Answers - Data (7:01)
Module 2 - Pivot Tables and Charts
2-1: Pie Chart (4:52)
2-2: Column & Bar Charts (6:44)
2-3: Line Charts (3:49)
2-4: Combo Chart (3:17)
2-5: Scatter & Bubble Chart (3:57)
2-6: Waterfalls Chart (4:20)
2-7: Funnel Chart (2:28)
2-8: Sparklines (9:36)
2-9: Map Charts (11:00)
2-10: Format the Legend of a Chart (4:03)
2-11: Format Axis of a Chart (4:02)
2-12: Format Gridlines on a Chart (3:35)
2-13: Format Chart Title (3:08)
2-14: Create Scrolling Tables (10:00)
2-15: Thermometer Chart (4:42)
2-16: Progress Donut Chart (6:18)
2-18: Conditionally Format Chart (6:21)
2-19: Animate Charts using VBA (12:33)
2-20: Add images into your Charts (4:43)
2-17: Speedometer Chart (9:36)
Homework - Pivot Charts (1:37)
Homework Answers - Pivot Charts (11:07)
Module 3 - Slicers
3-1 : What are Slicers (0:54)
3-2: How to Insert Slicers, copy them to Dashboard and connect to charts (3:54)
3-3: Format Slicers (9:00)
3-4: Refreshing the Slicer Data (2:08)
3-5: Using Dropdowns to choose Data instead of Slicers (4:44)
3-6: Using Scrollbars instead of Slicers (6:11)
Homework - Slicers (0:41)
Homework - Answers - Slicers (3:44)
Module 4 - Building the Dashboard
4-1: What is a Dashboard with Examples (2:41)
4-2: Color Scheme and Flow of Dashboard (4:34)
4-3: Copy over the Charts & make a general outline of your Dashboard (5:41)
4-4: Formatting, Aligning, Sizing and Finishing up your Dashboard (16:52)
4-5: Using Text Boxes to Display Large Data in your Dashboard (1:59)
4-6: VLOOKUP an image into your Dashboard (3:46)
4-7 Create PDF of Dashboard (6:01)
Homework - Dashboard (0:37)
Homework - Answers - Dashboard (15:56)
Module 5 - Complete Builds going from Data to Dashboard
5-1 Paper Sales Dashboard (42:08)
5-3 Stock Portfolio Dashboard (31:11)
5-2 Call Center Survey Dashboard (31:47)
5-4 Fake Burger Sales and Gross Profit Dashboard (38:45)
5-5 Daily Fantasy Sports Dashboard (22:31)
Who Uses Dashboards?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock