Excel practice exercises
Practice in your browser. No Excel install. No sign-up required.
Work through real spreadsheet scenarios and practice formulas, lookups, logic, dates, and text functions with instant feedback.
All exercises
Browse everything and pick what you want to practice next.
| Not completed | A/B test results analysisData Analysis Statistical, Math | Advanced |
| Not completed | Reference | Beginner |
| Not completed | Logic, Date | Intermediate |
| Not completed | Logic | Intermediate |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation, Statistical | Intermediate |
| Not completed | Aggregation, Date | Intermediate |
| Not completed | Bank statement reconciliationAccounting Lookup, Logic, Math | Advanced |
| Not completed | Logic | Beginner |
| Not completed | Aggregation | Beginner |
| Not completed | Error, Logic | Beginner |
| Not completed | Math | Beginner |
| Not completed | Break-even unitsFinance Financial, Math | Intermediate |
| Not completed | Build a basic cohort retention tableData Analysis Math, Statistical | Intermediate |
| Not completed | Date | Beginner |
| Not completed | Financial, Math | Intermediate |
| Not completed | Date | Beginner |
| Not completed | Math, Statistical | Beginner |
| Not completed | Date | Intermediate |
| Not completed | Math, Aggregation | Beginner |
| Not completed | Date | Intermediate |
| Not completed | Math | Intermediate |
| Not completed | Logic | Intermediate |
| Not completed | Text | Advanced |
| Not completed | Text | Beginner |
| Not completed | Math | Beginner |
| Not completed | Text | Intermediate |
| Not completed | Text | Beginner |
| Not completed | Complex commission structureSales/Marketing Logic, Math | Advanced |
| Not completed | Text | Advanced |
| Not completed | Text | Beginner |
| Not completed | Contribution marginFinance Financial, Math | Intermediate |
| Not completed | Text | Beginner |
| Not completed | Date | Intermediate |
| Not completed | Aggregation, Text | Intermediate |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation | Intermediate |
| Not completed | Aggregation | Beginner |
| Not completed | Error, Logic | Beginner |
| Not completed | Lookup, Reference | Advanced |
| Not completed | Reference, Math | Beginner |
| Not completed | Date | Intermediate |
| Not completed | Date | Beginner |
| Not completed | Depreciation schedule (multiple methods)Accounting Financial | Advanced |
| Not completed | Aggregation, Date | Intermediate |
| Not completed | Text | Advanced |
| Not completed | Date | Beginner |
| Not completed | Text | Beginner |
| Not completed | Text | Intermediate |
| Not completed | Text | Intermediate |
| Not completed | Text | Intermediate |
| Not completed | Lookup | Beginner |
| Not completed | Date | Beginner |
| Not completed | Statistical | Beginner |
| Not completed | Math, Statistical | Beginner |
| Not completed | Statistical | Beginner |
| Not completed | Math, Statistical | Beginner |
| Not completed | Statistical | Beginner |
| Not completed | Text | Beginner |
| Not completed | Logic | Beginner |
| Not completed | Text, Date | Beginner |
| Not completed | Text | Intermediate |
| Not completed | Full data reconciliationAccounting Lookup, Logic | Advanced |
| Not completed | Funnel conversion analysisData Analysis Math, Statistical | Advanced |
| Not completed | FV future valueFinance Financial | Intermediate |
| Not completed | Financial, Statistical | Intermediate |
| Not completed | Error, Aggregation | Intermediate |
| Not completed | Lookup | Beginner |
| Not completed | Logic | Intermediate |
| Not completed | Logic, Math | Beginner |
| Not completed | Logic | Intermediate |
| Not completed | Lookup | Intermediate |
| Not completed | Lookup | Intermediate |
| Not completed | Text | Intermediate |
| Not completed | Loan amortization scheduleFinance Financial | Advanced |
| Not completed | Lookup | Intermediate |
| Not completed | Lookup | Beginner |
| Not completed | Lookup | Beginner |
| Not completed | Date, Text | Beginner |
| Not completed | Text, Logic | Beginner |
| Not completed | Math, Statistical | Beginner |
| Not completed | Reference, Math | Beginner |
| Not completed | Statistical, Math | Intermediate |
| Not completed | Logic, Math | Intermediate |
| Not completed | Logic | Intermediate |
| Not completed | Logic | Intermediate |
| Not completed | Date | Intermediate |
| Not completed | Financial, Date | Advanced |
| Not completed | Pareto analysis (80/20)Data Analysis Statistical, Math, Logic | Advanced |
| Not completed | Text | Intermediate |
| Not completed | Logic | Beginner |
| Not completed | Statistical | Beginner |
| Not completed | Remove duplicate customer recordsData Analysis Aggregation, Logic | Intermediate |
| Not completed | Lookup, Array | Advanced |
| Not completed | Math | Beginner |
| Not completed | Simple DCF modelFinance Financial | Advanced |
| Not completed | Logic | Beginner |
| Not completed | Math | Beginner |
| Not completed | Math | Beginner |
| Not completed | Math | Beginner |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation | Beginner |
| Not completed | Aggregation | Intermediate |
| Not completed | Array, Aggregation | Intermediate |
| Not completed | Array, Math | Intermediate |
| Not completed | Logic | Intermediate |
| Not completed | Tax calculation with bracketsAccounting Logic, Math, Financial | Advanced |
| Not completed | Error, Logic | Beginner |
| Not completed | Text | Beginner |
| Not completed | Two-way lookupSales/Marketing Lookup | Advanced |
| Not completed | Lookup | Beginner |
| Not completed | Math, Statistical | Beginner |
| Not completed | Lookup | Beginner |
| Not completed | Lookup | Beginner |
| Not completed | Lookup | Intermediate |
| Not completed | XIRR for real cash flowsFinance Financial, Date | Advanced |
| Not completed | Lookup | Beginner |
| Not completed | Lookup | Intermediate |
| Not completed | XLOOKUP multiple criteriaSales/Marketing Lookup | Advanced |
| Not completed | Lookup | Intermediate |
| Not completed | Lookup | Beginner |
| Not completed | Lookup | Intermediate |
| Not completed | Year-over-year comparisonFinance Math, Date | Advanced |
| Not completed | Math | Beginner |
Statistical, Math
Reference
Logic, Date
Logic
Aggregation
Aggregation, Statistical
Aggregation, Date
Lookup, Logic, Math
Logic
Aggregation
Error, Logic
Math
Financial, Math
Math, Statistical
Date
Financial, Math
Date
Math, Statistical
Date
Math, Aggregation
Date
Math
Logic
Text
Text
Math
Text
Text
Logic, Math
Text
Text
Financial, Math
Text
Date
Aggregation, Text
Aggregation
Aggregation
Aggregation
Aggregation
Aggregation
Aggregation
Error, Logic
Lookup, Reference
Reference, Math
Date
Date
Financial
Aggregation, Date
Text
Date
Text
Text
Text
Text
Lookup
Date
Statistical
Math, Statistical
Statistical
Math, Statistical
Statistical
Text
Logic
Text, Date
Text
Lookup, Logic
Math, Statistical
Financial
Financial, Statistical
Error, Aggregation
Lookup
Logic
Logic, Math
Logic
Lookup
Lookup
Text
Financial
Lookup
Lookup
Lookup
Date, Text
Text, Logic
Math, Statistical
Reference, Math
Statistical, Math
Logic, Math
Logic
Logic
Date
Financial, Date
Statistical, Math, Logic
Text
Logic
Statistical
Aggregation, Logic
Lookup, Array
Math
Financial
Logic
Math
Math
Math
Aggregation
Aggregation
Aggregation
Array, Aggregation
Array, Math
Logic
Logic, Math, Financial
Error, Logic
Text
Lookup
Lookup
Math, Statistical
Lookup
Lookup
Lookup
Financial, Date
Lookup
Lookup
Lookup
Lookup
Lookup
Lookup
Math, Date
Math
Excel practice for beginners
Short exercises covering formulas, references, and basic aggregation. Do them in any order, or follow the beginner essentials track .
Excel practice for job interviews
Lookup, logic, and reporting tasks that regularly come up in Excel assessments and take-home tests.
Look up a product with XLOOKUP
BeginnerUse XLOOKUP to find a product's category from a product catalog.
Open exerciseVLOOKUP for price
BeginnerFind a product's price from a product catalog using the product code.
Open exerciseSum revenue by region with SUMIF
BeginnerUse SUMIF to calculate total revenue for each sales region from a transaction log.
Open exerciseIF with AND
IntermediateApprove a loan only if credit score > 700 AND income > $50,000.
Open exerciseCalculate business days between
IntermediateCalculate the number of business days between order and delivery.
Open exerciseFrequently asked questions
Where should I start if I'm new to Excel?
Start with the beginner essentials track. It opens with 'Your first formula' and moves through SUM, cell references, and IF before branching into lookups and text functions. Each one is a short, focused task.
Can I use these exercises to prepare for an Excel job interview?
Yes. Many exercises target the skills most commonly tested: VLOOKUP and XLOOKUP, SUMIF and COUNTIF, IF combined with AND/OR, date arithmetic, and text parsing. The 'Excel practice for job interviews' section on this page is a focused starting set.
How long does each exercise take?
Most take 2–10 minutes. Each one is a single scoped task: write a formula, or a small set of formulas, to solve a specific problem. You can do one during a break, or chain several together for a longer session.
Can I see hints or check the solution if I get stuck?
Yes. Exercises include progressive hints you can reveal one at a time, and a full solution you can check once you've given it a try. You decide when to peek. The hints are there to keep you moving, not to give the answer away.
Will these formulas work in Excel 365, older Excel versions, or Google Sheets?
Most exercises use functions available in Excel 2016 and later. A few, like XLOOKUP and FILTER, require Excel 365, Excel 2021, or Excel for the web. Google Sheets supports most of the same functions, though a handful have small syntax differences.