How to Engage Your Audience with “Choose Your Own Adventure” Presentations

May 11th, 2021 / Presentations
Ready for an advanced presentation technique? Want to make sure your audience is engaged? No, those 10-minute Q&As at the end of a presentation don’t count as adequate engagement. Let’s notch up our engagement! In this blog post, you’ll learn about the “Choose Your Own Adventure” method for engaging our audiences during presentations. You’ll see a brief demo of the Choose Your Own Adventure method, a behind-the-scenes tour of my slides and a discussion of the caveats so you can decide when to use this method.
More »

How to Organize Your PowerPoint Slides by Adding Sections

Apr 27th, 2021 / Data Visualization
Want to organize your PowerPoint slides a little better? There’s a behind-the-scenes trick that I love using in my own presentations: Sections! In this blog post and video tutorial, I’ll give you a demo of what sections are, how to add them, how I use them to hide topics and how I use them to re-order topics.
More »

How to Visualize Qualitative Data with Colored Phrases

Apr 13th, 2021 / Data Visualization
Wondering how to visualize your qualitative data? Maybe you’ve got open-ended survey responses, focus group notes, or speech transcripts. Qualitative data visualization can bring our words and phrases to life. I created a tutorial on using colored phrases to visualize qualitative data. In this tutorial, you’ll learn: 1) the first time I ever used colored phrases to visualize qualitative data; 2) my favorite examples of colored phrases; and 3) practical tips for using colored phrases in your project.
More »

How to Pass the Excel Certification Exam

Apr 6th, 2021 / Data Analysis
Want to pass the Excel certification exam? Maybe you want proof that you can rock Excel for your resume? For your LinkedIn profile? Do you want a confidence boost that, yes, you know Excel? Back in January, I registered for the Excel certification exam. I’d always been curious to see whether I could pass. Spoiler alert: I passed! In this blog post, I’ll share behind-the-scenes tips for registering for and pacing the MOS-200 exam.
More »

How to Use Vlookup in Microsoft Excel: Two Step-by-Step Examples for Beginners

Mar 30th, 2021 / Data Analysis
Vlookup is my all-time favorite function in Excel! (Well, the entire lookup family—vlookup, hlookup, index-match, and xlookup.) In this blog post, I’ll walk you through what what vlookup is used for, why it’s tricky and how to fill in the four pieces of the formula. In this blog post, you’ll learn what vlookup is used for; why vlookup can be tricky; how to fill in the four pieces of the formula.
More »

10 Must-Have Analytical Skills

Mar 23rd, 2021 / Data Analysis
Data cleaning and data analysis alone can take hours, days, or weeks. It will always take some time, but it doesn’t have to take forever. It might not be your favorite part of the process. But it doesn’t have to be a headache, either. In this blog post, we’ll cover 10 analytical skills that can make your next data project easier, faster, and error-free.
More »