Creating a Community through Graphs

Sep 14th, 2021 / Data Visualization
Maddison Staszkiewicz is a Depict Data Studio student and evaluator. She was part of the 2020 Great Graphs: Excel How-To’s cohort and is sharing her experiences with us. She especially loved the community of the course which helped her to learn new techniques, perspectives, gain valuable feedback and much more.
More »

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 »

Escaping the Bar Chart

Jun 8th, 2021 / Data Visualization
Bar charts aren’t evil. But they’re overused. I talked about Designs to Start Using Instead at the DataScienceGO conference in April 2021. We talked about my three favorite techniques for exploratory data visualization– spark lines, data bars and heat tables– and then I gave them some different options for maps. Are you ready to escape the bar chart?
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 »