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)
