Report Formula Challenge

3-Level Excel Challenge for All Skill Levels

Sharpen your skills one level at a time in a challenge that's anything but ordinary. This hands-on challenge is designed to test (and teach) the real formulas that build fast, reliable reports from scratch. You’ll start simple, then level up. Inside, you’ll find:

  • ✅ A workbook with beginner-to-advanced challenges

  • ✅ An answer key for each level

  • ✅ A follow-up video to your inbox with various options (pros and cons)

Whether you're new to Excel or a seasoned pro, this challenge will reveal your blind spots, reinforce your strengths, and give you a taste of what it's like to train inside Excel University.

report challenge invite (1)

Note: when you click the button, you'll be able to download the file immediately from this page, plus, I'll email it to you and send you the solutions video in a couple days 🙂

mos_badge_150x150
expert_badge_150x150
MVP_Logo_Secondary_greyscale_RGB_72_150x238
stackedregandqasv4bandw_greyscale_150x197
top 10
MCT_150x150
Trustpilot

Additional Info

Beginner? You're absolutely welcome. This 3-level challenge is designed to support all skill levels, from formula newcomers to seasoned Excel pros. You’ll start with a simple task and level up gradually.

You'll basically write formulas to populate this report:

Sound easy? You haven't seen the data yet! The data gets increasingly messy (aka, realistic) as you proceed! Can you handle all 3 levels? Don't worry if you get stuck along the way ... I'll send a follow up video with a variety of solutions so you can pick the best approach for any situation you encounter!

  • Excel for Windows is recommended. Excel for Mac is fully supported.

  • Estimated time: 15–30 minutes per level — go at your own pace.

  • Includes: A workbook with 3 challenges, answer keys, and a video walkthrough coming soon.

  • Topic focus: This challenge sharpens your reporting workflow — with SUMIFS, lookup formulas, and even Power Query (Level 3).

  • Follow-up: After the challenge, you’ll get my best Excel tips and videos via email to keep learning.

Taught by Jeff Lenning, CPA and Microsoft Excel MVP.

Entry price: FREE 🙂