Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Great Graphs in Excel
2024 Version
START HERE
Suggested Prerequisites & Materials to Download
Download the Excel Templates
The Data Visualization Design Process (67:59)
Set Up Custom Colors (22:19)
Set Up Theme Fonts (8:59)
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
Sunburst Diagrams (42:33)
Tree Maps (13:59)
Bump Charts (56:49)
Level 4: Non-Native Charts
B'Arc Charts (23:49)
Scatter Plots & Bubble Charts
Intro & Materials (6:30)
Step 1: Set Up Your Table (2:02)
Step 2: Insert a Scatter Plot (2:41)
Step 3: Declutter (1:00)
Step 4: Apply Brand Colors & Fonts (1:28)
Step 5: Adjust the Sizing (2:33)
Step 6: Adjust the Scales (17:23)
Step 7: Tell a Story with Dark Colors and Interpretive Text (18:34)
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
Intro & Materials (3:30)
Step 1: Set Up the Data Table (9:59)
Step 2: Cut and Paste the Sparklines into Position (8:50)
Step 3: Transfer from Excel into Word or PowerPoint (8:41)
Geographic Heat Maps
Intro & Materials (2:45)
Step 1: Set Up Your Table (5:33)
Step 2: Insert a Map (7:46)
Step 3: Format the Map (18:03)
Symbol Fonts
Webdings & Wingdings (14:23)
StateFace (10:03)
WeePeople (7:39)
=REPT() (8:08)
GIFs
How to Make a GIF with GIFMaker.me (21:58)
How to Make a Screen Recording GIF with ScreenToGIF (8:06)
How to Make a Whiteboard GIF with ScreenToGIF (6:14)
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
Ben Collins (50:12)
Kate Strachnyi (60:02)
Teach online with
START HERE
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock