Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Office Hours 2022
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)
March 7: Elisa's Quarterly KPI Dashboard
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock