Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Office Hours 2025
2025 Office Hours Recordings
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)
May 13: How to Make Interactive Dashboards in Excel (4 pieces); Scatter plot formatting; How to label stacked column charts with tiny slices (or zeros); Making sure that Word reports are ADA compliant when saved as PDFs (80:50)
May 20: Page layout ideas - Combining 2 pages of a report into a single page; Fixing spaghetti line charts (and setting up a contiguous dataset); Using different preattentive attributes in a dashboard (not just hue and saturation) (57:31)
May 27: Troubleshooting Interactive Excel Dashboards (slicers, pivot tables, Helper Tables, etc.) (59:39)
June 19: Rapid Fire! Tons of Questions. (57:47)
June 27: Copying/Pasting Data Bars from Excel into Word; Wide vs. Long Datasets; Making a Statistic More Relatable; Ideas for Directly Labeling Stacked Column Charts; (52:56)
July 11: Formatting Ideas for Stacked Bar Charts; Advanced Pivot+Helper Table Workarounds; Software Options for Interactive Dataviz & Movie Files (56:20)
July 15: Poor Alignment in Presentations & Newsletters; Deciding What Goes into Slicers (how does Year factor in??); Turning Wide Datasets into Long Datasets for Housing Shelters (53:55)
July 25 (55:10)
July 28 (25:12)
August 8 (47:00)
August 22: Excel MVP's Formulas; Survey Response Options Exported as Tons of Separate Columns (59:02)
August 28 (54:10)
September 2: Sue's Presentation with Preattentive Attributes; Fine-Tuning Maia's Graphs and Report Formatting; (57:20)
September 10: Formatting datasets for Pivot Tables; Adding Pivot Tables, Pivot Charts, and Slicers (50:29)
September 25: Adjusting Tables; Breathing Room for Pivot Tables; Long vs. Wide Datasets; Troubleshooting Data Validation; Spreadsheets vs. Forms vs. Databases; Creating a Single Contiguous Dataset for a Dashboard (64:42)
September 30 (60:40)
October 17: 2 Dynamic Excel Dashboards; How Screen Readers Work in Excel (52:45)
October 21: 2 Dynamic Excel Dashboards (continued) with Helper Tables (62:52)
October 21: 2 Dynamic Excel Dashboards (continued) with Helper Tables
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock