Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

Excel Formula Challenges

Below are some fun formula challenges. Strengthen your existing skills and learn new approaches at the same time. Submit answers as comments below each challenge.

Formula challenge - list names by teams

Formula challenge - convert Y/N to days of week

Formula challenge - multiple OR criteria

Formula challenge - flag out of sequence codes

Formula challenge - 2D lookup and sum

Formula challenge - build answer key for tests

Formula challenge - difference from last entry

Formula puzzle - sum payments by year

Formula puzzle - how long was the truck stopped?

Highlight dates in the same month and year

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

Get PDF Guide

It is only because of your website that I have the interest to learn how to use Excel. I can only say a huge burden was lifted off my head when I discovered your site. I used to hate Excel before. I found it complex and was disinterested too, but all that has changed now. I'm grateful.
RB
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page