Introduction to Excel dashboards
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
