Home › Excel tests › Excel level test
Excel level test: what's your Excel level?
How good are you at Excel, really? This level test starts easy and gets harder: 12 tasks, from a simple sum to INDEX MATCH and SUMPRODUCT. When you finish, you see your level, from beginner to advanced, and what to learn next.
Take the Excel level test
Work in the Excel window as you would in Excel: click a cell, type the formula, press Enter. Some tasks are quick questions. Do what you can; the harder tasks are there to find your ceiling.
- Add up the scores in B6
- What does the
$in$A$1do? - Show "Late" in C2 if the days are more than 30, otherwise "On time"
- Work out the share of Team A in the total, in C2
- Count the orders from Spain that are "Paid", in F2
- Find the department of employee E-104 with XLOOKUP, in F2
- Add up the sales of Kim in the North, in F2
- You have 5,000 sales rows and want the total per region and month. What's the quickest tool?
- Return the price of the Tablet with INDEX and MATCH, in F2
- Work out the total revenue (quantity × price for every row), in B6, with one formula
- A
FILTERformula finds 5 matching rows. What happens? - Which function counts the working days between two dates?
The four Excel levels
| Level | Score | What you can do |
|---|---|---|
| Beginner | under 30% | Type data, simple sums, basic formatting. |
| Basic | 30–59% | SUM, AVERAGE, IF, percentages, locked references like $A$1. |
| Intermediate | 60–84% | COUNTIFS, SUMIFS, XLOOKUP or VLOOKUP, pivot tables. |
| Advanced | 85% and up | INDEX MATCH, SUMPRODUCT, dynamic arrays, combined formulas. |
Want to know exactly what each level covers? See Excel skills: basic, intermediate and advanced.
What to do with your level
- Beginner or basic: follow the Excel lessons in order. Each lesson takes about ten minutes and gives you a tip at every step.
- Basic, with a job interview coming up: take the basic Excel test. Most office jobs test at this level.
- Intermediate: take the intermediate Excel test and add the certificate to your LinkedIn profile.
- Advanced: take the advanced Excel test, the level analyst and finance roles ask for.
How to describe your Excel level on your CV
"Good knowledge of Excel" says little. Name the level and what you can do with it, so a recruiter sees it at a glance:
- Basic: "Excel (basic): formulas, SUM, IF, sorting and filtering."
- Intermediate: "Excel (intermediate): XLOOKUP, SUMIFS, pivot tables, data cleaning."
- Advanced: "Excel (advanced): INDEX MATCH, dynamic arrays, SUMPRODUCT, reporting."
A certificate with your score makes the claim easy to check: link to it from your CV or LinkedIn.
Frequently asked questions
How do I know my Excel level?
Take a test with real tasks, not a questionnaire about how confident you feel. This level test has 12 tasks from easy to hard; the further you get, the higher your level.
What counts as intermediate Excel?
At an intermediate level you use lookups like VLOOKUP or XLOOKUP, conditional sums and counts like SUMIFS and COUNTIFS, and pivot tables. Most office jobs that ask for "good Excel skills" mean this level.
What counts as advanced Excel?
Advanced users combine functions: INDEX MATCH, SUMPRODUCT, nested IFs, dynamic arrays like FILTER and UNIQUE, and they build reports others can rely on.
How long does the level test take?
About 10 minutes. There's no time limit.
Can I take the level test again?
Yes, as often as you like. Practise the functions you missed and see your level go up.