How good are people at Excel? Data from our test
Anonymous results from the people who take our free Excel level test: the level they reach and the functions they struggle with most.
Key figures
0
tests completed
since —
0%
reach at least intermediate level
0%
reach advanced level
0.0
correct answers on average, out of 12
The level they reach
Each person’s level is the highest one where they get at least 3 of its 4 questions right.
Beginner0%
Intermediate0%
Advanced0%
Who passes each block
Share of people who get at least 3 of the 4 questions of each level right, whether or not they passed the previous one.
Beginner0%
Intermediate0%
Advanced0%
What people struggle with most
The three questions most people get wrong or leave unanswered.
- 1Relative references when copying a formulaLevel Beginner · 0% get it wrong
- 2Freezing the header rowLevel Beginner · 0% get it wrong
- 3FiltersLevel Beginner · 0% get it wrong
What they can do, function by function
Share of people who answer each test question correctly.
| What the question tests | Level | Correct |
|---|---|---|
| Relative references when copying a formula | Beginner | 0% |
| Freezing the header row | Beginner | 0% |
| Filters | Beginner | 0% |
| Absolute references ($) | Beginner | 0% |
| Conditional formatting | Intermediate | 0% |
| IF function | Intermediate | 0% |
| VLOOKUP | Intermediate | 0% |
| PivotTables | Intermediate | 0% |
| INDEX + MATCH | Advanced | 0% |
| SUMIFS | Advanced | 0% |
| Solver | Advanced | 0% |
| Data Model (Power Pivot) | Advanced | 0% |
How this data is collected
- The test has 12 questions, 4 per level (beginner, intermediate and advanced), in Spanish, Catalan or English. You pass a level with at least 3 of its 4 questions right.
- It counts the tests completed on academyperfect.com since —: the public test (only the first attempt of each visit) and, with no names or company, the level exams we run for company teams.
- Results are anonymous: we only keep the day, the language and which questions were missed. No names, no emails, no companies, no IP addresses.
- This is not a representative sample of the whole population: they are people who want to know their level and company teams who train with us. Use it as a guide.
Data updated on 30 October 2026.
How to cite this data
You can use it as long as you credit the source with a link to this page:
Academy Perfect, “How good are people at Excel? Data from our level test”. https://academyperfect.com/en/excel-skills-data/
Is your team below average? We fix that with a tailored course
Two minutes, no commitment. We reply with levels, dates and a fixed price.
Who is the training for?