FormulaGym
XP 0
Streak 0

Practise Excel formulas by doing them

Short exercises with fresh data every time, instant feedback, and a lesson on every function. Learn the formulas and shortcuts that matter for your job.

Try one now

Write the formula in the bar, then press Check answer. No sign-up needed.

How it works

1. Learn it

Every function has a short page: what it does, the syntax, a worked example and the mistakes people make.

2. Do it

Fix a real task on a practice sheet. The checker tests your formula, not just the number.

3. Keep going

Fresh data every time, a shortcut trainer and a streak-based Sudden Death mode.

Find the function for your job

All 17 functions with free lessons

SUMBeginner

Add up a column or range of numbers

FinanceSales & OpsHR
6 lessons · 1 freeLearn it
AVERAGEBeginner

Find the typical value in a set of numbers

FinanceSales & OpsHR
6 lessons · 1 freeLearn it
MAX / MINBeginner

Find the highest or lowest value fast

Sales & OpsFinance
5 lessons · 1 freeLearn it
COUNTBeginner

Count how many cells contain numbers

Data cleanupHR
5 lessons · 1 freeLearn it
COUNTIFIntermediate

Count rows that meet a condition

Sales & OpsHRData cleanup
6 lessons · 1 freeLearn it
SUMIFIntermediate

Add up only the rows that meet a condition

FinanceSales & Ops
5 lessons · 1 freeLearn it
COUNTIFSIntermediate

Count rows that meet several conditions

HRSales & OpsData cleanup
5 lessons · 1 freeLearn it
SUMIFSIntermediate

Add up rows that meet several conditions

FinanceSales & Ops
6 lessons · 1 freeLearn it
IFIntermediate

Show one result or another based on a test

FinanceHRSales & Ops
6 lessons · 1 freeLearn it
Nested IFIntermediate

Choose between three or more outcomes

FinanceHRSales & Ops
5 lessons · 1 freeLearn it
AND / ORIntermediate

Combine several tests inside IF

FinanceHRSales & Ops
5 lessons · 1 freeLearn it
ROUNDIntermediate

Tidy numbers to a set number of decimals

Finance
5 lessons · 1 freeLearn it
VLOOKUPIntermediate

Find a value in a table by its ID

Sales & OpsFinanceHR
6 lessons · 1 freeLearn it
XLOOKUPIntermediate

A modern, flexible replacement for VLOOKUP

Sales & OpsFinanceData cleanup
6 lessons · 1 freeLearn it
INDEX / MATCHAdvanced

Look things up in any direction

FinanceSales & Ops
5 lessons · 1 freeLearn it
IFERRORIntermediate

Replace errors with something readable

Data cleanupFinance
5 lessons · 1 freeLearn it
LEFTBeginner

Pull the first characters out of text

Data cleanup
6 lessons · 1 freeLearn it

See the full catalogue

Keyboard shortcuts too

Learn the 20 shortcuts that save the most time, with a cheat sheet for Windows and Mac and a drill that tests you.

Common questions

Is it free?

Every function and shortcut has a free practice lesson with fresh data each time. The full course will be a paid subscription.

Do I need Excel to use it?

No. The practice sheet runs in your browser, so you can try formulas without opening Excel.

Will I get the same exercise twice?

Exercises are generated from patterns with different data and layouts each time, so repeats are very unlikely.

Does it check my formula or just my answer?

Both. It works out the right answer from the data and checks that you used the function the lesson is about, so your formula keeps working when the data changes.