Excel formula practice that does not let you fake it
Most Excel practice sites hand you a workbook, a list of questions and an answer key. You peek, you type the number, you move on, and a week later you still cannot write a SUMIFS from scratch. Formuladrill was built around one rule: the only way through an exercise is a working formula.
Every drill runs your formula twice. First against the data on screen, then against an alternate version of the same table with different numbers. A formula that hard-codes the answer, or that only works by luck on the visible rows, fails the second run and is marked as fragile. That one check is the difference between recognizing a formula and being able to produce it under pressure.
Practice Excel online, right in your browser
There is nothing to download and no add-in to install. Formuladrill renders a working grid with cell references, a formula bar and the Excel functions you use every day. You write the formula exactly as you would in Excel, press Enter, and get an answer with an explanation.
That makes it useful in the places where opening a full workbook is awkward: on a laptop between meetings, on a train, or in the ten minutes before an interview. Progress is saved in your browser, and a free account keeps it across devices, so you can pick up where you left off.
Excel practice exercises built in seven levels
The 68 exercises are organized into levels, and each level only introduces one or two new ideas on top of what you already know.
- Basics: SUM, AVERAGE, MIN, MAX, COUNT, ROUND, MEDIAN, percent change, absolute and relative references, running totals.
- Logic and counting: IF, AND, OR, IFS, IFERROR, COUNTIF and COUNTIFS, SUMIF and SUMIFS, AVERAGEIF, MAXIFS.
- Lookups: VLOOKUP, XLOOKUP, INDEX with MATCH, left lookups, two-way lookups and tax-bracket tables.
- Text and dates: TRIM, PROPER, FIND, SUBSTITUTE, TEXTJOIN, YEAR, MONTH, EDATE and EOMONTH.
- Finance: PMT, NPV, IRR, PV, annuities, total interest, CAGR, break-even and straight-line depreciation.
- Work mode: real requests on messy sheets, with numbers stored as text, stray spaces, text dates and duplicates.
- Find the error: finished sheets with one planted mistake that you have to locate and fix.
Within a level the drills get harder one notch at a time. By the end of the Lookups level you have written an XLOOKUP that handles a missing code, a two-way INDEX and MATCH and a lookup that reads to the left, not because you read about them, but because the exercise would not pass until you did.
Open the exercise list
Excel formula exercises for work, not trivia
The data in every drill looks like something you would actually see in a job: a sales table by region and month, a list of invoices with due dates, an employee roster with start dates, a loan schedule. The questions are the ones a manager asks: total sales for the North region, how many orders have shipped, the monthly instalment on this loan.
The Work mode level goes one step further. The sheet arrives the way it does in real life, with amounts stored as text, names with trailing spaces and dates typed as words, and the request comes from Sales, Finance or Support. The Find the error level flips it around: the sheet is finished, one formula is wrong, and your job is to find it before the number goes out. You will not be asked to compute the factorial of a cell. The goal is that the next time someone sends you a spreadsheet and a question, you already know which function to reach for.
Learn Excel formulas by getting them wrong first
A hint is one click away, but the worked solution opens only after your second attempt. That is on purpose. Writing a formula, seeing it return #N/A, reading the hint and fixing it yourself is the part that sticks. Copying a solution before you have tried does not.
Every exercise also comes with an explanation of why the reference formula is built the way it is: why the lookup range is locked with dollar signs, why the criteria text is in quotes, why IFERROR wraps the lookup and not the other way around. Read it after you pass, and the pattern is yours.
Excel test practice for interviews and assessments
More and more finance, accounting, analyst and operations roles include an Excel test as part of the hiring process, and many of them are timed. The questions are rarely exotic. They are SUMIFS, a lookup with an error handler, a date calculation and a percentage change, written quickly and correctly while someone watches.
Formuladrill's drills are the same shape as those questions, and timed mode puts a clock on the screen so you get used to writing under time pressure, with hints and solutions locked until time is up. Run through the first three levels the week before an assessment and the test will feel like one more drill.
Try a timed drill
Excel practice for finance, accounting and analysts
If you work in a bank, an accounting firm, a corporate finance team or a consultancy, your Excel is judged on two things: whether the numbers are right and how fast you got there. Formuladrill was built by someone who reviews credit files and financial statements for a living, and the exercises reflect that: loan instalments, total interest, growth over time, variance against budget and a loan payment that is far too high because a yearly rate was used for monthly periods.
The Finance level covers PMT, PV, NPV and IRR, the value of an annuity, compound annual growth, break-even units and depreciation. Pass those drills and the formulas in your next model will be ones you wrote, not ones you copied from the last file.
XLOOKUP practice, SUMIFS practice and the functions people search for
Some functions deserve extra attention because they are where most people get stuck, so they come back in several exercises, each one a notch harder than the last.
- XLOOKUP practice: exact match, a friendly result when the code does not exist, returning from the left, and lookups inside IFERROR.
- SUMIFS and COUNTIFS practice: one criterion, two criteria at once, criteria that reference a cell instead of a typed value, and averages for one region.
- INDEX and MATCH practice: looking left where VLOOKUP cannot reach, a price grid with a row and a column lookup, and a finishing position with MATCH.
- IF practice: pass or fail, letter grades with IFS, a bonus for one region with AND, and shipping tiers.
Why hands-on beats watching
You can watch a ten-minute video on XLOOKUP and feel like you understand it. Then you open Excel, type =XLOOKUP( and stop. The gap between recognizing and producing is the whole problem, and the only thing that closes it is reps.
A Formuladrill session is five to fifteen minutes of writing formulas, each one slightly different from the last. Ten sessions in, the function names, the argument order and the reference locking are automatic. That is what fast at Excel means in practice.
Excel exercises for beginners and for people who use Excel every day
If you have never written a formula, the Basics level starts with =SUM and relative references and does not assume anything. If you already use Excel every day, skip to the lookups, the finance level or Find the error and look for the gaps: most experienced users have one or two functions they have always avoided, and the drills find them quickly.
Every exercise is independent, so you can jump to the one you need for today's problem and come back to the rest later.
Formuladrill
