Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Office Hours 2021
2021 Office Hours Recordings
January 21, 2021: How to Align Lonnnng Labels on Horizontal Bar Charts (10:15)
February 24, 2021: Data Bars, Scorecards, & Diagrams on Slides (40:30)
March 10, 2021: Switch Row/Column, Slidedocs, Condensing 80 Indicators, & Changing Colors of Data Bars (55:38)
March 10, 2021: Part Deux! More Details on Automagically Changing the Color of Data Bars (8:56)
March 17, 2021: Making Heat Maps in Excel or Tableau (14:33)
March 24, 2021: Gradient-Filled Text in PowerPoint, Word, or Excel (22:57)
March 31, 2021: Linnea's 2-Page Dashboard & Annemarie's Data Entry Form in Word (20:37)
April 7, 2021: Welcome Simple Spreadsheets Participants; How to Submit Questions to Office Hours (9:07)
April 14, 2021: Adding Alt Text to Images and Charts (15:20)
April 14, 2021: Part Deux! Removing an Excel Table (9:55)
April 28, 2021: Lori's 10-Point Survey Data; Kirsten's Questions about Concatenation, Text to Columns, and Vlookup (38:48)
May 5, 2021: Vivian's Too-Tall Data Bars; Ladislas' =counta, =countblank, and =sum Issues with Tallying Survey Data (35:50)
May 19, 2021: Lauren's One-Page Dashboard with Checkboxes & Progress Bars (37:39)
May 26, 2021: Saving Chart Formatting as a "Template" & Troubleshooting Theme Color Issues with SurveyMonkey Charts (32:12)
June 2, 2021: Percentage Differences vs. Percentage Point Differences (39:52)
June 9, 2021: Spillover Bars, Displaying %s over Time, & Grayed-Out Dashes to Show Zeros (39:23)
June 24, 2021: Hlookup & Data Management (Building a Master Form vs. a Dozen Different Forms) (33:55)
June 30, 2021: Excel Tables, Heat Tables, & Diverging Stacked Bar Charts (40:28)
August 18, 2021 (46:03)
August 25, 2021 (39:10)
September 1, 2021 (19:19)
September 8, 2021 (28:47)
September 15, 2021 (36:30)
September 29, 2021: Theme Colors, Not Enough Brand Colors, & Grouping/Ungrouping Dates in Pivot Tables (39:21)
October 6, 2021: Font Eyedroppers, Theme Colors/Fonts, Icon Arrays for Small n's (28:05)
October 13, 2021 (40:41)
November 3, 2021: Maia's Dataset on Correct/Incorrect Test Questions (29:56)
November 10, 2021 (64:47)
November 17, 2021: Qualitative Coding, Radar Charts, and Pre/Post Visuals (46:32)
December 1, 2021: Lauren's "Blank" Cells; Ellen's Agree/Disagree Scales; Andrew's Combo Chart (50:38)
December 8, 2021: Formatting Quotes for One-Pagers (26:54)
December 15, 2021: Josephine's Excel Dashboards (39:33)
Teach online with
April 7, 2021: Welcome Simple Spreadsheets Participants; How to Submit Questions to Office Hours
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock