Formuladrill

All 68 Excel formula exercises

Formuladrill is Excel formula practice in your browser. Every exercise gives you a real spreadsheet, a real question and a formula bar. You type the formula, it is checked on the data you see and on a second version you do not, so only a formula that really works gets the green light. The exercises are listed here level by level. 8 are free without an account; Pro unlocks the rest.

Start practicing free

Level 1: Basics

SUM, AVERAGE, MIN, MAX, COUNT, ROUND, MEDIAN, absolute references and running totals.

  1. Add it upFree
  2. Class averageFree
  3. Best and worst monthFree
  4. Tax on every lineFree
  5. Percent changeFree
  6. Count the numbersPro
  7. Count the answersPro
  8. Round to centsPro
  9. Profit marginPro
  10. Running totalPro
  11. Typical house pricePro
  12. Second biggest dealPro

Level 2: Logic and counting

IF, AND, OR, IFS, IFERROR, COUNTIF(S), SUMIF(S), AVERAGEIF and MAXIFS.

  1. Pass or failPro
  2. Letter gradesPro
  3. Bonus for the northPro
  4. Count the shipped ordersPro
  5. Sales for one regionPro
  6. Two conditions at oncePro
  7. Flag for reviewPro
  8. Count with two conditionsPro
  9. Average for one regionPro
  10. Scores above a barPro
  11. Best sale in a regionPro
  12. Shipping tiersPro
  13. No more #DIV/0!Pro

Level 3: Lookups

VLOOKUP, XLOOKUP, INDEX with MATCH, two-way lookups and bracket tables.

  1. Find the pricePro
  2. Look left with INDEX and MATCHPro
  3. When the code does not existPro
  4. Tax bracket lookupPro
  5. Finishing positionPro
  6. Price gridPro
  7. Return from the leftPro
  8. Price list into an orderPro

Level 4: Text and dates

TRIM, PROPER, TEXTJOIN, SUBSTITUTE, YEAR, MONTH, EDATE and EOMONTH.

  1. Build an email addressPro
  2. Pull out the domainPro
  3. Payment due datesPro
  4. Clean up namesPro
  5. Join the tagsPro
  6. Digits onlyPro
  7. Days between datesPro
  8. Year and monthPro
  9. Contract end datePro
  10. Pay by month endPro

Level 5: Finance

PMT, NPV, IRR, PV, FV, CAGR, break-even and depreciation.

  1. Loan instalmentPro
  2. Is the project worth it?Pro
  3. Growth over timePro
  4. Portfolio returnPro
  5. Internal rate of returnPro
  6. Value of an annuityPro
  7. Total interest on a loanPro
  8. Compound annual growthPro
  9. Break-even unitsPro
  10. Straight-line depreciationPro

Level 6: Work mode

Requests from Sales, Finance and Support on messy sheets: numbers stored as text, stray spaces, text dates and duplicates.

  1. Clean the customer namesFree
  2. Numbers stored as textPro
  3. Sales by region with messy labelsPro
  4. Flag duplicate ordersPro
  5. Days late from text datesPro
  6. Lookups that fail on stray spacesPro

Level 7: Find the error

Finished budgets, price lists and loan sheets with a planted mistake: a range that stops short, a typed-in rate, a flipped sign. Find it and fix it.

  1. The budget that looks fineFree
  2. A rate typed into a formulaFree
  3. Commission copied downPro
  4. Growth that does not add upPro
  5. The wrong price columnPro
  6. An average with the wrong countPro
  7. A region total that misses a rowPro
  8. A loan payment that is far too highPro
  9. Variance with the wrong signPro

Try the first eight drills free.

No sign-up needed for the first eight exercises. If it works for you, Pro unlocks all 68, and a free account saves your progress across devices.

Start practicing free