Office Hours 2021
Live Q&A Sessions
Bring your draft visualizations, reports, slides, dashboards, or infographics, and get personalized feedback from Ann K. Emery!
Participants who are currently taking Full Courses are invited to join our live Office Hours sessions, which are held (most) Wednesdays at 12 pm Eastern.
Course Curriculum
-
StartJanuary 21, 2021: How to Align Lonnnng Labels on Horizontal Bar Charts (10:15)
-
StartFebruary 24, 2021: Data Bars, Scorecards, & Diagrams on Slides (40:30)
-
StartMarch 10, 2021: Switch Row/Column, Slidedocs, Condensing 80 Indicators, & Changing Colors of Data Bars (55:38)
-
StartMarch 10, 2021: Part Deux! More Details on Automagically Changing the Color of Data Bars (8:56)
-
StartMarch 17, 2021: Making Heat Maps in Excel or Tableau (14:33)
-
StartMarch 24, 2021: Gradient-Filled Text in PowerPoint, Word, or Excel (22:57)
-
StartMarch 31, 2021: Linnea's 2-Page Dashboard & Annemarie's Data Entry Form in Word (20:37)
-
StartApril 7, 2021: Welcome Simple Spreadsheets Participants; How to Submit Questions to Office Hours (9:07)
-
StartApril 14, 2021: Adding Alt Text to Images and Charts (15:20)
-
StartApril 14, 2021: Part Deux! Removing an Excel Table (9:55)
-
StartApril 28, 2021: Lori's 10-Point Survey Data; Kirsten's Questions about Concatenation, Text to Columns, and Vlookup (38:48)
-
StartMay 5, 2021: Vivian's Too-Tall Data Bars; Ladislas' =counta, =countblank, and =sum Issues with Tallying Survey Data (35:50)
-
StartMay 19, 2021: Lauren's One-Page Dashboard with Checkboxes & Progress Bars (37:39)
-
StartMay 26, 2021: Saving Chart Formatting as a "Template" & Troubleshooting Theme Color Issues with SurveyMonkey Charts (32:12)
-
StartJune 2, 2021: Percentage Differences vs. Percentage Point Differences (39:52)
-
StartJune 9, 2021: Spillover Bars, Displaying %s over Time, & Grayed-Out Dashes to Show Zeros (39:23)
-
StartJune 24, 2021: Hlookup & Data Management (Building a Master Form vs. a Dozen Different Forms) (33:55)
-
StartJune 30, 2021: Excel Tables, Heat Tables, & Diverging Stacked Bar Charts (40:28)
-
StartAugust 18, 2021 (46:03)
-
StartAugust 25, 2021 (39:10)
-
StartSeptember 1, 2021 (19:19)
-
StartSeptember 8, 2021 (28:47)
-
StartSeptember 15, 2021 (36:30)
-
StartSeptember 29, 2021: Theme Colors, Not Enough Brand Colors, & Grouping/Ungrouping Dates in Pivot Tables (39:21)
-
StartOctober 6, 2021: Font Eyedroppers, Theme Colors/Fonts, Icon Arrays for Small n's (28:05)
-
StartOctober 13, 2021 (40:41)
-
StartNovember 3, 2021: Maia's Dataset on Correct/Incorrect Test Questions (29:56)
-
StartNovember 10, 2021 (64:47)
-
StartNovember 17, 2021: Qualitative Coding, Radar Charts, and Pre/Post Visuals (46:32)
-
StartDecember 1, 2021: Lauren's "Blank" Cells; Ellen's Agree/Disagree Scales; Andrew's Combo Chart (50:38)
-
StartDecember 8, 2021: Formatting Quotes for One-Pagers (26:54)
-
StartDecember 15, 2021: Josephine's Excel Dashboards (39:33)
Your Instructor
Ann K. Emery is an internationally-acclaimed speaker who equips organizations to get their data out of dusty spreadsheets and into real-world conversations.
Each year, she delivers over 100 keynotes, workshops, and webinars with the aim of equipping organizations to visualize data more effectively.
She has been invited to speak in 30 states and 10 countries; 6,000 people have enrolled in her online training academy; and she has consulted to 200 organizations, including the United Nations, Centers for Disease Control, and Harvard University.
She earned a Bachelor’s degree from the University of Virginia and a Master’s degree from George Mason University.
After traveling full-time as a digital nomad, Ann now resides in Florida along with her husband and three children.