Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Storytelling in Excel
Core Lessons (replays from 2024 live classes)
Welcome! Start Here (15:57)
Level 1: Overused Native Charts -- Bar Charts (64:16)
Level 1: Overused Native Charts -- Line Charts (41:30)
Level 2: Underused Native Charts -- Bar Charts with Target Lines (or Average Lines) (56:05)
Level 2: Underused Native Charts -- Scatter Plots and Bubble Charts (34:01)
Level 2: Underused Native Charts -- Geographic Heat Maps, Tree Maps, and Sunburst Diagrams (51:04)
Level 3: Non-Native Charts -- Overlapping Bars, Small Multiples Bars, Population Pyramids, Diverging Stacked Bars, Waffles, B'arcs (89:04)
Level 3: Non-Native Charts -- Dot Plots (51:09)
Bonus: Symbol Fonts
Webdings & Wingdings (14:23)
StateFace (10:03)
WeePeople (7:39)
=REPT() (8:08)
Bonus: 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)
Olivia's Short Reports in Canva (2024) (17:07)
Tiffany's Online Report for her University (2024) (18:15)
Niki's Full-Length Report in Canva (2024) (19:31)
Dalisha's Ordinal Survey Variables as Data Bars (2024) (14:00)
Beth: Nested Donuts for Weekly Screening Progress (2024) (7:04)
Guest Speakers
Ben Collins (50:12)
Kate Strachnyi (60:02)
Teach online with
Level 2: Underused Native Charts -- Bar Charts with Target Lines (or Average Lines)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock