Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Office Hours 2026
2026 Office Hours Recordings
January 15: Pivot table workarounds; book cover mock-ups; fine-tuning graphs in reports and one-pagers (66:38)
January 23: Evaluation plan resources (AEA, TIGs, affiliates, etc.); One-pagers (KPI/overview icons; grid alignments) (57:00)
January 29: Data modeling with Power Pivot; A Tableau "pin drop" map with icons; Making sure 2 similar graphs have the exact same inner/outer proportions in PPT; Workarounds for "check all" questions in Excel pivot tables (and showing percentages instead of counts) (80:04)
February 5: Bizarre PDFing issues with "error bars" charts; Recent eye-tracking research on speaker webcams (32:29)
February 19: Analyzing "Check-All" Questions in Excel (Splitting, =SEARCH, binary values in pivot tables); Developing a "Coordinated Ecosystem" Graphic with SmartArt (59:08)
February 26: Making Sure Graph Topics are Clear (Titles, Axis Labels, Subheadings, etc.) without Being Redundant; 2 Options for Writing Takeaway Sentences in Excel; Turning a Stacked Chart into a Regular Chart (61:50)
March 6 (46:41)
March 12: Quick Wins for Stacked Bar Charts; STEP Framework (rotated); Mapping Counties in South Carolina (70:24)
March 24: Tiny Edits to a Map made in Tableau; Adjusting a Survey Workflow to use Pivot Tables (59:02)
April 3 (56:27)
April 8 (61:58)
April 17 (61:14)
April 23 (53:17)
May 15: Pivot Table "Crosstabs," Xlookup, Index-Match, and even Power Query! (58:24)
May 15: Pivot Table "Crosstabs," Xlookup, Index-Match, and even Power Query!
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock