Click any formula for a task to solve, or just start typing — it's a real, free-to-use spreadsheet.
👆 Choose a formula from the list, or just start typing below — it's a real, live spreadsheet.
Use this page for online Excel practice. Pick any formula from the list, or press Random Question, and solve the task in the spreadsheet. It is a quick way to build Excel formula practice habits: short exercises, real data and a result you can check.
Questions run from Beginner to Advanced. Start with SUM, SUMIF, SUMIFS, SUMPRODUCT, AVERAGE, AVERAGEIF, COUNT, COUNTA, then move to lookups (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH), dynamic arrays (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE), text and date formulas.
When you are comfortable, try Excel interview questions, build a business case study, or read an Excel tutorial on the formula you are practising.
Yes. You can start practising without signing up. A free account saves your progress and puts you on the leaderboard.
No. The spreadsheet runs in your browser, so you can practise Excel formulas on any computer or phone without installing anything.
Graded questions check your formula and the result as soon as you submit, and tell you straight away if it is correct.
More than 500 functions, from SUM, IF and COUNTIF to VLOOKUP, XLOOKUP, INDEX and MATCH, FILTER and SUMPRODUCT. Pick a formula or press Random Question.
Yes. The questions run from beginner to advanced, and the interview prep section adds practical tests for data analyst, MIS and business analyst roles.
