Excel Practice Online
Solve 24 Excel exercises that check your formulas, or open a blank sheet. Free, in your browser.
B8
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Expense | Amount | ||
| 2 | Rent | $1200.00 | ||
| 3 | Groceries | $380.00 | ||
| 4 | Utilities | $145.00 | ||
| 5 | Transport | $90.00 | ||
| 6 | Phone | $35.00 | ||
| 7 | Internet | $50.00 | ||
| 8 | Total | |||
| 9 | ||||
| 10 | ||||
| 11 |
Excel exercises that check your formulas
Practice Excel formulas in a real spreadsheet in your browser. Pick an exercise, write the formula in the highlighted cells and press Check: the sheet recalculates your answer and tells you which cell is wrong and why, whether that is a misspelled function, a lookup that finds nothing or a reference that moves when it should stay put.
The 24 exercises go from a first SUM to INDEX with two MATCHes, in six chapters: basics, logic, counting and summing, lookups, text, and numbers and dates. When you would rather build your own table, switch to the free sheet: a blank online spreadsheet that calculates as you type, with CSV import and export.
What makes this Excel practice different
- Answers are checked, not just shown. Your formula is recalculated on the table you see and on hidden versions of it with the numbers changed, so typing the result instead of a formula never passes.
- Feedback names the cell and the reason:
#N/Afrom a lookup that found nothing,#NAME?from a misspelled function, a total that drifts because the reference needed$signs. - A real spreadsheet with the Excel formula syntax: fill handle, formula bar, function suggestions as you type and number formats. Nothing to install, and it works on a phone.
- Using Excel in another language? The sheet recognizes translated function names like
SVERWEISorBUSCARVand tells you the English name it expects. - A free blank sheet for everything else, with CSV import and export. Your work and your progress stay saved in this browser.
What you can practice
- Formulas and references:
SUM,AVERAGE,MAX,MIN, copying a formula down, and when a reference needs$to stay fixed. - Logic and conditions:
IF,AND,IFS,IFERROR, and counting or adding up only the rows that match withCOUNTIF,SUMIF,COUNTIFS,SUMIFSandAVERAGEIF. - Lookups: exact and approximate
VLOOKUP,XLOOKUPto the left, andINDEXwithMATCHacross rows and columns. - Text and dates: joining names with
&,LEFT,UPPER,TRIM,PROPER,MIDwithFIND,ROUND, and date arithmetic withYEAR,MONTHandWEEKDAY.
Excel practice FAQ
Is this Excel practice free?
Yes. All 24 exercises and the free sheet are free, with no sign-up and no download. Your progress is kept in this browser.
How does it know my answer is right?
When you press Check, your formulas are recalculated by a spreadsheet engine on the table you see, and again on hidden copies of the table where some numbers and names are changed. The expected values come from a reference formula on the same data. A formula that is right on every version passes; a typed number is right on only one, so it does not.
Do I need Microsoft Excel installed?
No. The spreadsheet runs in your browser and uses the same formula syntax as Excel, so
=VLOOKUP(E2,$A$2:$C$6,3,FALSE) works here exactly as it does in Excel or Google Sheets. It is not Microsoft Excel itself, and it does not open or save .xlsx files.My Excel is in German, French or Spanish. Why does SUMME not work here?
Excel translates function names in some languages (
SUMME, SOMME and SUMA are all SUM) and there it separates arguments with a semicolon instead of a comma. This sheet uses the English names and commas. If you type a translated name, the check tells you the English one to use.Which Excel functions can I practice?
SUM, AVERAGE, MAX, MIN, IF, AND, IFS, IFERROR, COUNTIF, SUMIF, COUNTIFS, SUMIFS, AVERAGEIF, VLOOKUP, XLOOKUP, INDEX, MATCH, LEFT, UPPER, TRIM, PROPER, MID, FIND, LEN, ROUND, YEAR, MONTH and WEEKDAY, plus references with $, the & operator and date arithmetic. The free sheet accepts hundreds more.Can I practice pivot tables or charts here?
Not yet. This page is about formulas, which is what most Excel tests and interviews check first. Coddy's Excel course goes on to sorting, filtering and summarizing a dataset into a report.
Can I use it as a blank online spreadsheet?
Yes. Switch to Free sheet for an empty workbook that calculates as you type. You can import a CSV file, download your sheet as CSV (which opens in Excel), and it is saved in this browser until you reset it.
What should I learn after these exercises?
Coddy's free Excel course continues from here with guided lessons on formulas, cleaning up data, lookups and reports, each one a task in a live sheet like these, and a certificate when you finish.
Useful tools for Excel
Free, browser-based tools that pair well with the Excel Playground - all part of Coddy.