Intermediate Excel is the level most office work actually runs on. It is a lookup that pulls the right value out of a large table, a pivot table that turns a thousand rows into a five-line summary, and conditional formatting that flags a problem instead of hiding it in the data. It is genuinely useful — and it still breaks in ways that only show up once someone else touches the file.
What "Intermediate" Actually Covers
The centrepiece is a working lookup function — VLOOKUP, INDEX/MATCH, or XLOOKUP where it is available — used to pull a value from one table into another without retyping it. That single move underpins a large share of intermediate office work: matching an employee ID to a name, a product code to a price, an invoice number to a status.
Alongside that: IF and nested-IF logic for basic decision rules, COUNTIF/SUMIF for conditional totals, a pivot table that summarises a large table by category, and conditional formatting used to flag values rather than just decorate them. You can also apply data validation to restrict what goes into a cell, and you understand relative versus absolute references well enough to stop using them by accident.
This is the level a job ad usually means by plain "Excel skills required" without the word "advanced" attached — competent, fast, and able to build something new rather than only maintain something that already exists.
Where It Breaks
- A VLOOKUP that returns the wrong value after someone inserts a column, because it counts position rather than the header name
- A lookup range that does not expand automatically, so new rows added at the bottom silently fall outside it
- A pivot table showing stale numbers, because the underlying data changed and nobody clicked refresh
- Nested IF statements four or five levels deep that nobody, including the person who wrote them, can debug six months later
- A conditional format rule that quietly stops applying because the range reference was typed rather than selected
The pattern across all five is the same: intermediate Excel builds things that are correct at the moment of building and fragile after that. What breaks is not the logic — it is what happens when the sheet keeps being used by someone who was not in the room when it was built.
What to Put on a CV at This Level
"Intermediate Excel: VLOOKUP/INDEX-MATCH, pivot tables, conditional formatting, data validation, nested IF logic" is accurate and is what most job ads asking for "strong Excel skills" actually want. It signals you can build a working tool from raw data without help, which is the real threshold employers are screening for.
What would overstate it: claiming "advanced Excel" or "Excel expert" on the strength of a working VLOOKUP alone. Advanced work is specifically about the sheet surviving contact with other people — that is a different, testable claim.
The Next Rung
Advanced Excel is built around durability: structured tables that expand automatically, named ranges instead of typed cell references, data validation that stops bad input at the source, and enough macro or Power Query familiarity to automate a repeated task rather than redo it by hand every week.
The gap is not more formulas — it is fewer ways for the sheet to quietly go wrong once it leaves your hands. The Excel Skills test scores lookup and data-handling separately across 30 scenario questions, which is a fast way to see specifically whether your lookup skills or your data-handling habits are what is holding the score back.
Why Intermediate Excel Is Where Most Careers Actually Sit
It is worth saying plainly: intermediate is not a consolation tier. A large share of finance, operations, HR and admin work runs entirely on the skills covered here, and never touches the durability concerns of the advanced tier because the sheets in question are rebuilt from scratch each reporting cycle rather than maintained for years by strangers.
The honest reason to push into advanced territory is not that intermediate is insufficient — it is that any sheet built to be reused, shared, or handed off eventually meets someone who edits it in a way the original builder did not anticipate. If that describes the role you are aiming for, the next tier is worth the time. If it does not, intermediate Excel done well is a genuinely complete, employable skill.