2024 Office Hours Recordings
-
RSVP to the Sessions
-
January 11: Feedback on a Static Excel Dashboard; Ideas for an Upcoming PowerBI Dashboard; How to Visualize Qualitative Data; How to Increase Engagement for Virtual Training Events (72:01)
-
January 25: Static Dashboards for Closed-Ended and Open-Ended Survey Responses; Tips on Building Your Org's Presentation Templates; an Annual Report in Infographic and Videographic Formats (54:45)
-
February 8: Annual Report for a Library; Subsections of a PPT Presentation; Analyzing Chat Comments; 2-Page Overview of Year 1 Achievements (111:42)
-
February 22: Transforming a Pie Chart; Setting Meeting Norms/Expectations at the Beginning of a Presentation; Mounds of Info across 10 Categories & 80 Indicators; Dealing with Muted Department Brand Colors (71:22)
-
March 1: Copying and Pasting Sparklines into Word; Turning a Stacked Bar Chart into an Icon Stack; Turning a Dual-Axis Chart into Small Multiples; Using Others' Brand Colors in Our Presentations (54:01)
-
March 5: How to Make Small Multiples Bar Charts and Small Multiples Stacked Bar Charts in Excel; Adding Icons for States, Provinces, or Countries to Graphs; Best Practices for Formatting Interactive Dashboards in Excel (61:34)
-
March 26: Excel-Based Dashboards; Finding "the" Takeaway to Highlight in Graphs; Timeline illustrating Board Members' Terms; A 2-Page Report (Map made in Excel; Formatting Photos; etc.). (82:19)
-
April 11: Carefully Fitting Tons of Info on a Single Slide; Labeling a Bar Chart with Both Numbers and Percentages (with concatenation() and round()) (57:26)
-
April 22: RECURRING ANALYSES, WOOHOO! Cole's 2nd Year of Survey Responses; Mary's Ongoing Database Entries; Anna's Pivot Tables (73:19)
-
May 1: Melea's Dataset-Plus-Tabulation-in-One & How to Motivate Staff to Enter Data; Mary's Excel Table & Pivot Tables (continued); Maia's Excel Table & vlookup Question (69:56)
-
May 10: Adding & Refreshing Pivot Tables; Making Color-Coded Table Easier on the Eyes (Graying Out Most Cells, Bump Charts in Excel) (82:45)
-
May 17: Process for Setting Up Interactive Dashboards; Using Maps with Interactive Dashboards (via Helper Tables and Lookups); 1 Map with Symbols into Small Multiples Maps; a Quarterly Report Input Form; Deciding Which Numbers to Compare on a Dashboard (47:52)
-
May 20: Feedback on PowerPoint-Based Reports (76:34)
-
May 24: How a Nonprofit Can Combine Multiple Databases/Data Sources into a Single Dashboard (Power BI?); Auto-Generated Monthly Reports (Excel Tables, Pivot Tables); Making "Data Bars" More Readable (48:44)
-
June 4: Visual Appendices; Starting with the Broad Overview and Then Diving Deeper (or, Vice Versa) (53:31)
-
August 15: How to Organize Pre-Post Test Spreadsheets; LinkedIn Strategy; Quick Feedback on a 2-Page Infographic (Small Multiples Donuts vs. Clustered Bars vs. Dot Plots) (58:00)
-
August 29: SmartArt Pros & Cons; Trends and Benchmarks for 15 Measures; First Draft of a Report about Library Content (64:03)
-
September 5: Small Adjustments to Lisa's Excel-Based 2-Pager about Library Circulation Stats (71:04)
-
September 12: ISBLANK and IF Formulas; Making Sure Charts Have 2+ Data Points for a Dashboard; Using Pivot Tables, Slicers, and Pivot Charts to Find Patterns in South Carolina's Standardized Testing Dataset (87:23)
-
September 19: Interactive Dashboards - What if Only One Timepoint is Selected, and the Graph Shows... Nothing??; Tweaking Diverging Stacked Bar Charts in a Report (73:18)
-
September 26: Adjusting the Y-Axis Scale (e.g., turning 1,500,000 into 1.5 million); Adding "Embedded" Captions to Videos (PPT/Descript Tips); Adding Visuals to an Excel-Based Dashboard (Data Bars & Deviation Bars) (65:56)
-
October 4: Analyzing Qualitative Data in Excel (Conditional Formatting, Thematic Coding, Pivot Tables); Troubleshooting a Line Chart with a Mysterious Gap/Break Between 2 Points (56:38)
-
October 11: Rawan's Excel Survey (continued); Un-Squishing a One-Pager in PowerPoint (white space, font sizes, graph types, page layout) (95:23)
-
October 18: Nit-Picking a Very Strong 2-Pager in Word; Adding Labels to a Tile Grid Map of the World; Quick Wins for a Conference Poster Made in PowerPoint (Text Hierarchy; White Space; etc.); Making Small Multiples Histograms for Survey Data (86:48)
-
October 24: Quick Wins for Canva Reports & Landscape PPT Reports (66:36)
-
November 1: Adding Labels to Line Graphs (Concatenation & Helper Cells); Turning a Paragraph into a Numbered List; Fixing #REF! Errors inside Concatenated Formulas; Turning a Dataset+Tabulation into Just Datasets or Just Tabulations (95:13)
-
November 8: Circular References; Distinguishing between Datasets vs. Tabulated Data; Pros and Cons of Several Mapping Approaches (66:34)
-
November 15: Final Review of an Excel-Based Short Report; Chart and Table Ideas for a Canva-Based Brief; Adding Headings and a Cover to a Nutrition Report in Word; Ideas for a Text-Only Report (61:39)
