2025 Office Hours Recordings
-
RSVP to the Sessions
-
January 7: A 1-Page Public Health Infographic made in PPT; Quick Wins for a Power BI Dashboard; Brainstorming about a Year-End Infographic; How to Connect Forms, Spreadsheets, and Dashboards (51:58)
-
January 14: Box-and-Whisker Edits & Alternative Chart Types; Turning a PPT Report Page into a Presentation Slide; Sparkline Axes (Automatic, or Custom?) (53:04)
-
January 21: How to Make Area Charts in Excel (and Adjust the Transparency); Using Switch Row/Column to Transpose an Excel Line Chart; Help Improving Diagrams in a Presentation; Updates on a Power BI Chart for an Online Dashboard (64:21)
-
January 28: Adjusting a 1-Pager with a Checklist in Word; Filtering-Out Blank Responses in an Interactive Excel Dashboard; Showing "All" the Data in a Swarm Plot for a PowerBI Dashboard (81:19)
-
February 10: Jitter Plots; Quick Wins for Qualitative Data; Adjusting a Newsletter/Quarterly Report Template in Word; Spaghetti Bump Charts; Connecting Slicers to Maps in Excel (102:08)
-
February 18: Jitter Plots, Unjittered; Turning County-Level Crime Data Tables into Graphs (9:47)
-
February 27: PowerBI Dashboard; Net Promoter Scores (and Matrices?); Ideas for Visualizing a "Resources" Page in a PPT-Based Report; Quick Wins for a Word-Based Newsletter (94:39)
-
March 12: Audrey, Michelle, Sue (79:55)
-
March 27: Adjusting Helper Tables to Account for Future Data; Feedback on an Annual Report (in Canva); Vlookup & Index-Match (58:48)
-
April 4: Excel Slicer Connection Issues; How to Make a Report Template to Use 50+ Times that Someone Else Will be Filling In?!, How to Best Organize Files/Frameworks/Materials, Which Software is Best for Reports/Dashboards/Bulletins? (63:15)
-
April 11: Small changes to Angela's report; Helper cells for dynamic takeaway sentences in Excel dashboards; Setting up a dataset (to feed into a PowerBI dashboard) (87:29)
-
April 17: Vlookup reference errors; Lookup and IF mini training; Adding checklist imagery and/or photos to Kat's report in PPT; Making Ariane's report not feel so text-heavy (77:29)
-
April 24: 2 hard questions, followed by 3 easy ones, phew! (120:41)
-
April 24: Taylor's "columns" in a report (thirds vs. fourths layout considerations) (5:56)
-
May 2 (58:30)
-
May 5: A Step-by-Step Stacked Bar Chart Makeover; Pivot Table How-To (63:05)
