Excel Proficiency Levels: Basic, Intermediate, Advanced

Excel proficiency levels are the labels job ads use, basic, intermediate, advanced and sometimes expert, to say how much Excel a role needs. There's no official standard behind them, so one employer's "advanced" can be another's "intermediate". This guide sets out what each level usually means, gives you a self-check task for each one and explains how employers test them, so you can describe your level accurately.

Why Excel levels are confusing#

Excel levels sound precise, but nobody owns the definitions. A finance team may call pivot tables basic, while an admin team may call them advanced. Job ads also use different words: "proficient", "strong", "working knowledge".

The practical answer is to stop thinking in labels and think in tasks. If you can show which tasks you can do on your own, the label matters much less. The levels below reflect what most office, finance and analyst roles commonly expect.

The four Excel proficiency levels at a glance#

Most office jobs ask for basic or intermediate. Analyst and finance roles often ask for intermediate to advanced. Expert skills are usually named explicitly in the ad when they're needed.

Self-check tasks for each level#

The fastest way to find your level is to try one task from each, on fresh data, without help. All three use this table in A1:C6:

Basic: total all sales#

=SUM(C2:C6)

The answer is 20200. At this level you should also manage the average (=AVERAGE(C2:C6) returns 4040) and sort the list by Sales.

Intermediate: total sales for one region#

=SUMIF(B2:B6,"West",C2:C6)

The answer is 6500 (3600 + 2900). At this level you'd also find a rep's sales with a lookup, such as =XLOOKUP("Cy",A2:A6,C2:C6), which returns 5100, and build a pivot of sales by region.

Advanced: find who sold the most#

=INDEX(A2:A6,MATCH(MAX(C2:C6),C2:C6,0))

The answer is Cy. MAX finds the top value, MATCH finds its row and INDEX returns the name. At this level you'd also list every East rep with =FILTER(A2:A6,B2:B6="East") (Excel 2021 or Microsoft 365), which returns Ana and Cy.

If the first two felt easy and the third took a while, you're solidly intermediate and on your way to advanced. Be strict with yourself: a task counts only if you did it without notes, got the right answer first time or spotted your own mistake, and could explain the formula to someone else. Doing it once with a tutorial open is a sign you're close, not that you're there.

How employers test each level#

Many employers check Excel claims with a short test, especially for office, finance and analyst roles. The format usually matches the level:

• Basic tests ask for totals, averages, simple formulas, sorting and formatting, often in 15 to 30 minutes.
• Intermediate tests add lookups, SUMIFS and COUNTIFS, IF and a pivot table.
• Advanced tests add INDEX MATCH, multi-condition problems, dynamic arrays and sometimes a case study.

The level in the job ad is a good guide to the test, but not a promise. Prepare for one level above what the ad says, so the harder questions don't surprise you. If you're told which platform the employer uses, practise that format too, for example the TestGorilla Excel test.

A timed mock test at the right level is the best rehearsal. The guide on how to use an Excel mock test explains how to take one and review it, and you can try the basic, intermediate and advanced mock tests in order to see where you stop feeling comfortable.

How to describe your level on a resume#

Put the level you can prove, then list specific skills that support it, such as "Intermediate Excel: XLOOKUP, SUMIFS, pivot tables, conditional formatting". Specific skills are far more convincing than a label alone, and they help with automated resume screening that looks for keywords. The guide on how to show Excel skills on your resume has examples. Some people add a certificate as extra evidence; see whether Excel certification helps you get a job.

How to move up a level#

Moving up is mostly about practice on realistic tasks, not more reading. A simple approach:

1. Pick the next level's skills from the table above.
2. Practise each one on fresh data until you can do it without looking anything up. The list of Excel practice tasks to do before a test gives ready-made tasks.
3. Check yourself with a timed test, then practise whatever slowed you down.

How long it takes depends on your starting point and how often you practise; how long it takes to learn Excel breaks it down by level. If a test goes badly along the way, the guide on what to do after a failed Excel test shows how to turn it into a plan.

Practise it#

Skill checks are the quickest way to confirm your level. Start with the basics skill check, then the summary grids skill check for intermediate SUMIFS and COUNTIFS, then the INDEX/MATCH skill check for advanced lookups. Each one checks your formulas instantly, so you'll know exactly where your level sits.