Online Excel Challenges for Real World Practice
Learn Excel by doing online challenges based on real work situations practice formulas and data skills with simple exercises and clear feedback
Categories
Swipe ->
Remove Duplicate Names
Use COUNTIF with an expanding range to mark first appearances as Keep and later repeats as Duplicate.
Calculate Days Between Dates
Calculate date differences using subtraction, NETWORKDAYS, and DATEDIF for calendar days, workdays, and segmented durations.
Standardize Full Names
Use PROPER and TRIM together to fix messy capitalization and extra spaces in name data.
Split First and Last Names
Split full names into separate first and last name columns using LEFT, SEARCH, RIGHT, and LEN.
Extract Email Domains
Use FIND with MID, RIGHT, or REPLACE to extract the domain after the @ sign from email addresses.
Format Phone Numbers
Format 10-digit raw numbers into readable phone numbers using TEXT, LEFT/MID/RIGHT, or REPLACE.
Check for Matching Passwords
Use EXACT to compare two password fields with strict case-sensitive matching.
Calculate Sales Tax
Multiply net prices by a shared tax rate using absolute references, then sum net and gross totals.
Identify Overdue Invoices
Use IF and AND to flag invoices that are both past their due date and still unpaid.
Practice That Feels Real
These challenges are built to feel close to real spreadsheet work. Instead of tiny drills, you get scenarios with messy data, practical formulas, and the kind of decisions people make in real reports and workflows.
You work through each challenge in the sandbox, build the formula yourself, and get feedback right away. That makes it easier to learn the logic step by step, spot what needs fixing, and keep moving without the usual guesswork.
Pick Your Scenario
Choose a real-world scenario from finance, logistics, or marketing.
Analyze the Data
Figure out what formulas you need and how to solve the problem.
Build the Solution
Use the Spreadsheet Editor to build formulas right in your browser.
Earn Points
For each challenge you solve, you get 2 EXP.