Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
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?
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock