2022 Office Hours Recordings
-
January 5: What To Do When External Evaluators' Reports Need to be Redesigned?; Fine-Tuning a Static Excel Dashboard; Program Fidelity Data (40:21)
-
January 19: Static Dashboards; Pre/Post Survey Results for Small n's; Stacked Bar Charts with Spacing (42:57)
-
January 26: Adding Visuals to a Text-Only Page; Formatting a Static Excel Dashboard; How to Visualize Post-Training Survey Results (45:22)
-
February 1: How Do You Figure Out a Client's Brand Font?; Visually Organizing a 70-Page Workbook into Chapters; Visualizing Open-Ended Survey Comments with Diagrams (53:01)
-
February 8: Ellen's Pre-Post Results: Table, Clustered Bars, and/or Dot Plots? (51:06)
-
February 15: Gerda's Overlapping Area Charts & Ellen's Pre-Post Data in Clustered Bar Charts (31:06)
-
February 22: Josephine's 5-Point Survey Scale (29:30)
-
February 28: Sally's Dashboard Drafts & Troubleshooting Gerda's Eyedropper Tool (26:00)
-
March 7: Elisa's Quarterly KPI Dashboard (31:47)
-
March 21: Vivian's Report Colors, Alisyn's Min/Max/Mean Dataset, Ellen's Stacked Bar Chart with Switch Row/Column (37:45)
-
March 28: Lisa's Scatterplot with 4 Quadrants; Aimee's 5-Point Survey Scale with Neutral Shown Separately (48:07)
-
April 7: Kayla's Tableau-Based Dashboard for a University (22:29)
-
April 14: Sally's Survey Data from 20-50 Trainings Per Year (23:52)
-
April 21: PowerPoint Sections, Footers, & the Slide Master; Dataviz Design Guides & Excel Graph Templates; Feedback on a Focus Group Report (32:22)
-
April 28: Starting to Analyze Aimee's Spreadsheet (Pivot Tables vs. Formulas; Cleaning/Re-Coding Variables; Raw vs. Clean) (36:20)
-
May 6: Adding the "n" to Sarah's Interactive Dashboard in Excel; Shibani's Questions about Becoming a Better Presenter (20:52)
-
May 13: Brooke's Dashboard on the Strategic Planning Process (29:36)
-
May 20: Turning Kristin's Tables into Graphs; Weighing the Pros and Cons of Stacked Column Charts vs. Line Charts; Adding the "total" to the Top of the Columns (Without Annoying Text Boxes) (32:00)
-
May 27: Pros/Cons of Excel vs. Sheets vs. R vs. Others; Ideas for Clara's PowerPoint-Based Dashboard (58:25)
-
August 15: Melika's PowerPoint Slides (18:30)
-
August 29: Sue's Quotes, Lisa's School District Heat Tables, Ellen's Report in Word (41:47)
-
September 12: Clara's PPT-Based Dashboard; Ellen's Lookup Questions; Gerda's Survey Streamlining Questions (61:34)
-
September 19: Continuing with Gerda's Spreadsheet Automation Process; Best Practices for Sue's Colors; Ellen's Quick Charts (79:44)
-
September 26: Maia's Slides about Focus Group Results (37:07)
-
October 3: Accessibility for Tracey's Report; Maia's Lollipop Charts (56:17)
-
October 17: Gerda's Updated Dashboard; Sue's Discussion about Conference Posters (59:11)
-
October 24: Kayla & Maia's Questions about Color Contrast (51:18)
-
October 31: Tackling Kate H.'s Survey (Data Management, Cleaning, Analysis, & Quick Vizzes) (66:54)
-
November 7: Gerda's Question about Setting Expectations with Consultants & Clients for Dashboard Projects; Brittany's Data Entry Spreadsheet with Drop-Down Menus & Data Validation (51:18)
-
November 14: Maia's Series of Matching Dashboards; Gerda's Dashboard with 2 Drop-Down Menus (54:34)
-
November 28: xlookup with "n/a" values; Sue's Zillow line graph (a combo chart); and more (58:10)
-
December 5: Year-End Infographics; 8 Ingredients for Designing One-Pagers; Adding Pivot Tables Instead of Manually Filtering Data (62:09)
-
December 12: Nested IFs, Year-End Infographic, Creating Courses & Selling Digital Products (106:44)
