The Inside Scoop on Excel with Bill Jelen (Mr. Excel)

Jul 20th, 2021 / Data Analysis
I recently had the honor of speaking with Bill Jelen, a.k.a. Mr. Excel. He’s a big, big deal in the Excel community! I’ve internet-stalked him for years on his website and his popular YouTube channel and frankly, I’m still shocked he agreed to come speak with us. We talked about his background, favorite Excel features, how many of the more than 480+ Excel functions he actually uses and more.
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 »

24 Conditional Formatting Visuals in Microsoft Excel that Should Be Retired

“You should go work at Microsoft and fix Excel’s terrible formatting.” I can’t tell you how many times I’ve heard this from workshop participants. Bill Gates, are you reading this?? Microsoft Excel is lonnnnng overdue for some updates. Don’t get me wrong—it’s still my favorite program. With 750 million users worldwide, I won’t be switching to anything else. It’s used by every business professional I know for at least part of their workflow. I’m getting tired of making excuses for Microsoft. Here are 24 conditional formatting visuals that should be retired ASAP because they’re ableist, time-consuming to read, or look like they’re from 1995.
More »

Learn How to Make Great Graphs in Excel with Ann K. Emery

Jun 23rd, 2020 / Data Visualization
Our software how-to visualization course, “Great Graphs: Excel How-To’s,” is open for once-a-year enrollment between June 22-26, 2020. We started building this virtual training in 2018. Since then, we quadrupled the videos and templates. We added Office Hours so you can pick my brain about your individual projects. We added Discussion Boards and a Facebook group to build community. We added Guest Experts so you can learn about programs beyond Excel. We added Lifetime Access. This Excel dataviz training is the best it’s ever been.
More »