Excel Exercises with Answers: Free Online Practice

By Rinkesh Shah, founder of Cellgrids.

Practise Excel the way you learn a language: by doing. Pick a level, open the live spreadsheet and solve real formula questions. Your answer is checked instantly, and you can read the syntax and a worked example for every function.

Beginner Excel exercises

Start here if you are new. These cover totals, averages, counting, rounding and your first IF.

• Practice SUM · SUM syntax
• Practice AVERAGE · AVERAGE syntax
• Practice COUNT · COUNT syntax
• Practice COUNTA · COUNTA syntax
• Practice MAX · MAX syntax
• Practice MIN · MIN syntax
• Practice ROUND · ROUND syntax
• Practice IF · IF syntax
• Practice LEN · LEN syntax
• Practice TRIM · TRIM syntax

Intermediate Excel exercises

Lookups, conditional totals and text and date work: the formulas used in most office reports.

• Practice VLOOKUP · VLOOKUP syntax
• Practice HLOOKUP · HLOOKUP syntax
• Practice INDEX · INDEX syntax
• Practice MATCH · MATCH syntax
• Practice SUMIF · SUMIF syntax
• Practice SUMIFS · SUMIFS syntax
• Practice COUNTIF · COUNTIF syntax
• Practice COUNTIFS · COUNTIFS syntax
• Practice LEFT · LEFT syntax
• Practice RIGHT · RIGHT syntax
• Practice MID · MID syntax
• Practice TEXT · TEXT syntax
• Practice DATEDIF · DATEDIF syntax
• Practice IFERROR · IFERROR syntax

Advanced Excel exercises

Modern and multi-condition formulas that separate strong candidates from average ones.

• Practice XLOOKUP · XLOOKUP syntax
• Practice FILTER · FILTER syntax
• Practice UNIQUE · UNIQUE syntax
• Practice SORT · SORT syntax
• Practice SEQUENCE · SEQUENCE syntax
• Practice SUMPRODUCT · SUMPRODUCT syntax
• Practice TEXTJOIN · TEXTJOIN syntax
• Practice IFS · IFS syntax
• Practice CHOOSE · CHOOSE syntax

Excel practice for job interviews

Employers test lookups, conditional totals and clean-up skills. Work through these guides, then try the practical tests.

• Excel interview questions for freshers
• Excel interview questions for data analysts
• Excel interview questions for business analysts
• Excel practical test for data analyst jobs
• All interview prep and practical tests

Real business exercises

Ready for more than single formulas? Try full Excel case studies with business data, such as payroll, reporting and dashboards.