2024 Version
Suggested Prerequisites & Materials to Download
2023 Version
-
Week 1: 4 Levels of Excel Vizardry (10:55)
-
Week 1: Sparklines (19:59)
-
Week 1: Data Bars (10:45)
-
Week 1: Heat Tables (6:41)
-
Week 2: Bar & Column Charts (81:50)
-
Week 3: Pies (36:58)
-
Week 3: Transferring Graphs into Word/PPT (15:10)
-
Week 3: Donuts (1:13)
-
Week 4: Lines (57:59)
-
Week 5: Overlapping Bar/Column Charts (70:32)
-
Week 6: Target Lines on Bar/Column Charts (79:58)
-
Week 7: Slopes, Small Multiples Lines, Areas, Bumps (91:29)
-
Week 8: Small Multiples Bar Charts & Population Pyramids (58:03)
-
Week 9: Diverging Stacked Bar Charts & Waffle Charts (51:44)
-
Week 10: Dot Plots, Lollipops, & Swarm Plots (61:06)
Level 3: Underused Native Charts
Level 4: Non-Native Charts
Scatter Plots & Bubble Charts
Tile Grid Heat Maps
-
Intro & Materials (4:35)
-
Step 1: Set Up Your Table (4:11)
-
Step 2: Calculate the Bin Cutoffs (11:11)
-
Step 3: Fill in the Values by Linking Cells (5:15)
-
Step 4: Color-Code the Cells Based on their Values (13:46)
-
Step 5: Make a Legend (5:22)
-
Step 6: Transfer from Excel into Word or PowerPoint (6:41)
-
Bonus! Tile Grid Heat Maps for Canada (3:26)
Tile Grid Trendline Maps
Geographic Heat Maps
GIFs
Case Studies from Your Colleagues
-
Ellen's Agree/Disagree Survey Data (42:43)
-
Cat's Grantmaking Data for her Foundation (22:00)
-
Soren's Report with Color-Coded Divider Pages (29:39)
-
Ellen's One-Page Infographic in PowerPoint (42:11)
-
Andrew's Slides, One-Pagers, and Technical Reports (39:52)
-
Judy's Visualizing Rubrics and Rating Scales (69:57)
-
Kharaam's Deviation Bars and Arrows Comparing Different Sites (34:14)
-
Brainstorming about Sue's Data Strategy (44:09)
-
Fitting Maia's Small Multiples Bar Charts onto a Single Page (64:21)
-
Bringing Lisa's Survey Tables to Life with Color Scales or Data Bars (49:32)
-
Additional Case Studies from the 2021 Graduation Ceremony (56:22)
-
Megan's Summary Sheet (w/ Line Charts, Heat Tables, & Data Bars, Made Entirely in Excel); Stacked Bars; and Small Multiples Diverging Stacked Bars (78:13)
Guest Speakers
