Basics
Writing formulas, ranges, relative references and filters.
Excel skills test — free, in 5 minutes
Check your Excel skills with 12 questions, from the basics to PivotTables, XLOOKUP and Power Query. Every answer is explained, and at the end you see the next step for your level.
12 questions · about 5 minutes · no sign-up
After each question you see the right answer and a short explanation. At the end you get your level and the courses and tools that fit it.
- Basics · 4
- Intermediate · 4
- Advanced · 4
What the test checks
Intermediate
IF, VLOOKUP, COUNTIF and reporting with PivotTables.
Advanced
XLOOKUP, SUMIFS, dynamic arrays and Power Query.
Frequently asked questions
Is the test free?
Yes, it is completely free and needs no account. Your result is kept only in your browser.
Which Excel version is it for?
The questions are for Excel 2016 and later; XLOOKUP and dynamic arrays are in Excel 2021 and Microsoft 365.
What should I do with my result?
The result screen shows the courses, guides and tools for your level. Beginners do best starting with the free course.