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 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 »

Getting Started with Sketchnoting: A Conversation with Emily Mills

Jan 5th, 2021 / Data Visualization
I recently had the chance to talk with Emily Mills, who is a professional illustrator and expert in sketchnoting. Emily was a guest speaker in our Report Redesign course. She walked us through the basics of sketchnoting, her career, why hand drawn images stop the scroll, the cool brain science behind sketchnoting, and then led us through some drawing exercises.
More »

A Real-Life Excel Test from a Job Interview: Can You Pass??

Feb 18th, 2020 / Data Analysis
Ten year ago, I was interviewing for an analyst position and I’d sat in the interviewer’s office going on and on about all my great spreadsheet skills. And then the interviewer was like, “Prove it. Come with me.” I was then led to an office with a computer that had an Excel test just waiting for me. My heart just about stopped– what did I say I knew how to do again?? Spoiler alert: I got the job but fast forward ten years later- can I still pass that Excel test today?
More »