Creating Reports for Grant Deliverables Using Excel Dashboards

Feb 14th, 2022 / Dashboards
Are you tired of text heavy reports to summarize grant findings? Do you want to update the look and feel of your reporting templates? Save time and energy by using static Excel dashboards to design your grant deliverables. Read on to learn more about Josephine Engels’ journey implementing static dashboards in a non-profit context.
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 »

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 »