Intermediate — Your Excel Skill Level
You can answer questions from data, not just record it
Intermediate is where a spreadsheet stops being a record and starts being an instrument.
You are comfortable with formulas that reference other places, you can summarise data rather than only list it, and you can put together an answer to a question that was not anticipated when the sheet was built. The specific frontier of this band is joining and summarising: a lookup that pulls a value from another table, and a pivot table taken all the way through rather than half-built and abandoned. What is still ahead is not more functions. It is the part where the sheet has to hold up when someone who did not build it starts typing into it.
Strengths
- You can answer an unanticipated question from data you already have.
- Referencing across sheets and tables is normal to you, so data does not have to be duplicated.
- You summarise rather than list, which is what turns a spreadsheet into a report.
- This is the level most office job descriptions actually mean when they say "strong Excel".
- You have enough vocabulary to read someone else's formula and work out what it does.
Growth Edges
- A pivot table half-built is a common stopping point, and the value is in the second half.
- Nothing yet stops another person from typing over a formula and breaking the sheet.
- Data arriving in a messy shape is still cleaned by hand, which does not scale.
- Errors display as error codes rather than as something a reader can act on.
- The sheet works because you know where its soft spots are, which is not the same as it working.
Career Matches
Read More
- Intermediate Excel: Lookups, Pivot Tables and Where It Stops
- Advanced Excel: Building Sheets That Survive Being Edited by Someone Else
- Tech Savvy Intermediate Skills: Spreadsheets, Collaboration, and Automation
- Beginner Excel: What You Can Actually Build (and What Breaks)
- The Digital Skills That Quietly Gate Hiring in Non-Technical Roles
- Basic, Intermediate, Proficient, Advanced: What Each Computer Literacy Band Does in an Ordinary Office Job
Compare
Frequently Asked Questions
What does an Intermediate Excel result mean?
You can go beyond recording data to interrogating it: referencing across tables, summarising, and building an answer to a question the sheet was not originally designed to answer.
What should I learn next from this band?
The shipped next steps are a lookup you actually trust — INDEX/MATCH or XLOOKUP — and taking a pivot table all the way through rather than stopping at the first summary it produces.
What is the difference between Intermediate and Advanced Excel?
Intermediate is about what you can get the sheet to tell you. Advanced is about whether the sheet still works after someone who did not build it has been editing it for a month.
Should I learn XLOOKUP or INDEX/MATCH?
XLOOKUP is simpler and is the modern default, but it is not available in older versions of Excel. INDEX/MATCH works everywhere, which is why plenty of workplaces still standardise on it.
Is Intermediate Excel enough for an analyst role?
It is the working level for a lot of coordinator and junior analyst work. Roles that build models other people rely on generally expect the protection, naming and error-handling that come with the next band.
Is this a certified Excel qualification?
No. This is a self-check that places you in one of four bands so you know what to learn next. It is not a certification and it is not a validated assessment instrument.
Explore all results in depth
Already taken the test, or just curious? Read the in-depth guide for any result — strengths, challenges, career matches, famous people, and FAQs.
Results Library content is educational, not a clinical assessment.