Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Office Hours 2023
2023 Office Hours Recordings
January 9: Year-End Infographics; Dealing with #n/a's in Pivot Tables; Analyzing Qualitative Data in Excel & Other Programs (53:11)
January 23: MS Forms; Appending Tables; Vlookup/Xlookup on Messy Name/Email Data; Stacked Bar Charts Showing Training Attendance (75:13)
January 30: Scaled Data for a Tiny n (just 10 people!); Using Forms to Make Data Entry Easier; Turning 1 Graph into 2 Side-by-Side Graphs (69:18)
February 6: Analyzing Kate's Dataset from Start to (Almost) Finish; Sue's Tips on Font Readability and Color Contrast; Gerda's Recoding Question (Leaving blanks alone) (70:12)
February 13: Sankey Diagrams; Adding More Pivot Tables to Kate's Spreadsheet; Adjusting IF Statements to Get Cells to Show Up Empty (59:20)
February 20: Timelines in PowerPoint; Graphing Retention of Students Over Time; Feedback on a Course Registration Page (85:38)
February 27: Character Counts vs. Word Counts in Sheets/Excel; Gerda's Updated Dashboard; Thinking about the Summary Tables for Kate's Library Dataset (59:37)
March 6: Organizing Vanessa's Tables & Adjusting Graphs (49:41)
March 20: Admissions Graphs (Sankey? Not Quite); Project Management Template; Checking for Vlookup/Analysis Issues; Quick Wins for a One-Pager; Displaying an "Other" Bar (60:32)
March 27: Formatting Tables in Appendices; Setting Up Theme Fonts on a Mac; Suggestions for Stacked & Diverging Bar Charts (56:07)
April 3: Stacked/Diverging Stacked Bar Charts; Positioning Labels on Charts; Adding Visuals to Tables; Locking Cells (51:48)
April 10: Sankey Diagrams; Cleaned-Up Bar Charts & Maps in Excel; Small Multiples Bar & Column Charts with "Placeholder" Data (60:13)
April 14: Adding Formulas to Library Data; Event Log Data (69:14)
April 17: Pivot Tables; Stacked Bar Charts; Locking Cells & Data Validation; Event Logs (70:23)
May 1: Headers & Footers Across Multiple Excel Sheets; Event Logs (& Pivot Tables & Pivot Charts); Slides with Screenshots; Small Multiples Charts for Age Ranges (62:43)
May 5: Quick Wins for an Upcoming Report (Small Multiples, Waffles, etc.); Exploring Data in Excel to Find the Overall Message for a Conference Poster; Feedback on a PowerPoint-Based Infographic (80:37)
May 8: Visualizing Demographic Data & Scaled Survey Responses; Adding More Pivot Tables & Pivot Charts to an Event Log (51:31)
May 12: Exploratory Dataviz for a University Survey; An Updated Infographic Made in PowerPoint; Small Multiples Bar Charts in Excel with LOTS of Categories (81:50)
May 19: Population Pyramids with Forecasts; Visualizing Likert Data - Beyond Bar Charts; Adjust Date Formulas to Indicate Whether Projects are Overdue; Thinking through a Survey Response Log (91:20)
May 22: Survey Logs; Hidden Slides (and Sections, and Collapsing Sections); Transforming a Clustered Bar Chart into a Small Multiples Layout (53:38)
May 26: Troubleshooting a SUMIFS Formula; Setting Up Theme Colors for a Mac in Word (with the Quick Access ribbon) (44:15)
June 2: Tiny Slivers in Stacked Bar Charts; Success Story in Applying Client's Brand Colors; Population Pyramids for 2 Time Periods (Small Multiples & Overlapping); Theme Colors on a Mac (63:42)
June 5: Visualizing a Range of Data (The Min/Max, Not the Average or Sum); Adding a Monthly Graph to a Spreadsheet; Adjusting a One-Pager (to Add More White Space) (66:37)
June 9: Adjusting Side-by-Side Graphs within a PPT-Based Report; Editing a One-Pager about Outcome Harvesting; Board Packet with 2 Line Graphs Side by Side; Adjusting a Table with 50+ Rows & Columns (Decluttering and then Adding Conditioning Formatting) (72:40)
July 13: Streamlining a Government Agency's Workflow as They Collect & Visualize Grantee Data; Quick Visuals to Add to Grant Reporting Spreadsheets in Excel (62:05)
July 18: Setting Up a (1) Data Entry Table and (2) Summary Table for Sharon's Timesheets (53:11)
July 24: Meenakshi's Simplified Box-and-Whisker Plot (aka "Span Chart") Showing the Min & Max Values (63:31)
August 2: Maria-Theresa's Dashboard/Report with Quick Vizzes (continued); Robin's Vertical Dot Plot Question; Barbara's Dot Plot (How-To & Formatting Tips) (99:50)
August 10: Fine-Tuning the Visuals in Maria-Theresa's "Dashboard Report;" Adjusting Barbara's Slides with Outcome Chains (102:39)
Teach online with
April 14: Adding Formulas to Library Data; Event Log Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock