How to Show Excel Skills on Your Resume (Honestly)
By ExcelReady TeamUpdated 4 min read
The short answer
To show Excel skills on your resume honestly, name specific functions and features you can use without help, such as SUMIFS, XLOOKUP and pivot tables, instead of labels like "advanced". Add one or two bullets that describe a real task you did with them, and only list skills you could demonstrate in a test tomorrow.
Key takeaways
- Specific skills ("SUMIFS, XLOOKUP, pivot tables") say more than labels like "proficient" or "advanced".
- The best evidence is a bullet that names a task, the Excel tool you used and what it made possible.
- Only list what you can do without searching: many employers check Excel claims with a test.
- A self-test with no hints is the quickest honest way to decide what belongs on your resume.
On this page+
The honest way to show Excel skills on your resume is to name what you can actually do, such as SUMIFS, XLOOKUP and pivot tables, and back it up with a bullet about a real task. Labels like "proficient" or "advanced" mean different things to different people. This guide is for job seekers who want their Excel claims to be specific, believable and easy to prove in an interview or test.
Why vague Excel labels don't help#
Words like "basic", "intermediate", "advanced" and "proficient" have no shared definition. One hiring manager's "advanced" is VLOOKUP; another's is building models with dynamic arrays. A label alone gives the reader nothing to check.
Specific skills do the opposite. "SUMIFS, XLOOKUP, pivot tables, conditional formatting" tells a recruiter exactly what you can do, and matches the words job ads often use. It also makes the interview easier, because the questions follow from what you wrote.
Which Excel skills to list#
List skills in the words employers and job ads use: function names and feature names. Group them so they're easy to scan.
| Group | Examples to list (only if you can do them) |
|---|---|
| Core | Formulas, SUM, AVERAGE, absolute references ($), sorting, filtering |
| Logic | IF, AND, OR, IFS, IFERROR |
| Conditional math | COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIFS |
| Lookups | VLOOKUP, XLOOKUP, INDEX MATCH |
| Data tools | Pivot tables, conditional formatting, data cleaning (TRIM, TEXT functions) |
| Modern Excel | FILTER, UNIQUE, SORT (Excel 2021 or Microsoft 365) |
A test for each line: could you use it on a new dataset, without searching, in a few minutes? If not yet, leave it off
and add it once you can. If you know VLOOKUP, for example, you should be able to explain its four arguments and why the
last one is usually FALSE; the VLOOKUP function guide is a good self-check.
How to write Excel bullets that show results#
A strong bullet names a task, the Excel tool you used, and what it made possible. Use your own real numbers; if you don't have them, describe the scope instead. Some templates:
- "Built a monthly sales summary with SUMIFS and a pivot table, replacing a manual tally of [number] orders."
- "Cleaned and merged two customer lists with TRIM and XLOOKUP, flagging [number] missing records."
- "Tracked [team / office] supply orders in Excel with COUNTIF and filters to show pending items each week."
- "Calculated staff tenure with DATEDIF and TODAY so the review list updated automatically."
The brackets are for you to fill in with true figures. Never invent a number; an interviewer may ask how you got it. Coursework, volunteering and personal projects count too: "Analyzed a public dataset of [topic] with pivot tables and COUNTIFS" is a fair bullet if you did it.
Where to put Excel skills on your resume#
Put Excel in two places so it's both easy to find and believable:
- Skills section: one line, such as "Excel: SUMIFS, XLOOKUP, pivot tables, conditional formatting".
- Experience, education or projects: one or two bullets that show those skills in use.
If the job ad lists specific Excel skills you have, use the same words. Many employers search applications for keywords, and matching names like "pivot tables" or "VLOOKUP" helps a human reader too.
Your cover letter or online profile can carry one short example in a sentence, such as "In my last role I rebuilt our weekly order report with SUMIFS so it updated by itself." Keep the wording consistent across all of them. If your resume says XLOOKUP and your profile says "basic Excel", a reader will wonder which one is true.
Be ready to prove every Excel claim#
Many employers check Excel claims with a practical test or a few interview questions, so treat your resume as a promise. If you list COUNTIFS and SUMIFS, expect a question like "total revenue for the North region and Laptop product". If you list absolute references, expect "why does this formula break when I copy it down?"
Prepare by practising the exact skills you listed. The guide to COUNTIFS and SUMIFS and relative vs absolute references cover two of the most tested ones. Speed is noticed too: see the Excel shortcuts that make you look fast in a test. The guide to what Excel assessments test and how they're scored explains the common formats.
What not to write#
Avoid claims that are hard to defend or easy to misread:
- "Expert in Excel" unless you can teach it. It invites the hardest questions.
- Long lists of every function you've heard of. Ten you can use beat thirty you can't.
- Course certificates as the only proof. Mention them if you like, but pair them with a bullet that shows the skill in use.
- Made-up numbers. If you can't explain where a figure came from, leave it out.
Check your level before you write it down#
The quickest honest way to decide what to list is to test yourself on a task with no hints. If you can finish it without help, list those skills. If you get stuck, you know what to practise first, and the guide to how long it takes to learn Excel helps you plan the time.
Practise it#
Take the basics skill check, where you fix, calculate, fill and format a supplier order with no hints. Then try the summary grid skill check, which builds a region by product grid with one COUNTIFS or SUMIFS formula and mixed references. If you can pass both on your own, formulas, absolute references, COUNTIFS and SUMIFS belong on your resume. The exercise below is the first step of that grid.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
Prove one resume skill: a summary grid. Click H2 and count the orders for the region in G2 and the product in H1. Write it so the same formula could fill the whole grid: lock both data ranges, and use $G2 and H$1.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Product | Monitor | ||||||||
| 2 | Laptop | North | ||||||||
| 3 | Monitor | South | ||||||||
| 4 | Laptop | |||||||||
| 5 | Dock | |||||||||
| 6 | Monitor | |||||||||
| 7 | Laptop | |||||||||
| 8 | Laptop | |||||||||
| 9 | Monitor | |||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 |
Tip: COUNTIFS takes range and criteria pairs; $G2 keeps column G and H$1 keeps row 1.
Practise this in a lesson
Frequently asked questions
How do I describe my Excel level on a resume?
List the specific things you can do, like "SUMIFS, XLOOKUP, pivot tables, conditional formatting". If you also use a label, make sure the skills listed back it up.
Should I put Excel on my resume if I only know the basics?
Yes, if the job uses Excel and you can do the basics reliably. Say exactly what you can do, such as formulas, sorting, filtering and SUM, rather than overstating your level.
What counts as advanced Excel on a resume?
There is no official standard. Many people use it for skills like INDEX MATCH, multi-condition formulas, dynamic arrays and pivot tables, so name the skills rather than relying on the word.
Where should Excel go on a resume?
Put the specific skills in your skills section, and show them in action in one or two bullets under the job, course or project where you used them.