Excel Skills for Your Resume: What to List and How to Prove It
Which Excel skills to put on your resume, how to describe your level honestly, and examples of bullet points that show real results instead of buzzwords.
By Ayoub Farid · · 2 min read
"Proficient in Microsoft Excel" appears on so many resumes that recruiters skip right past it. What gets attention is specific skills, tied to something you did. And if the job has an Excel test, what you list will be checked.
What recruiters actually look for
Most office roles need the same core set. List the ones you can really do:
Core (most office jobs)
- Formulas: SUM, AVERAGE, COUNT, MIN, MAX
- Absolute and relative references ($)
- IF and logical functions
- COUNTIF, SUMIF, SUMIFS
- Sorting, filtering and basic formatting
Intermediate (analyst, finance, operations)
- VLOOKUP, XLOOKUP, INDEX/MATCH
- Pivot tables
- Data cleaning: TRIM, text functions, removing duplicates
- Charts
- Data validation and conditional formatting
Advanced (specialist roles)
- Dynamic arrays (FILTER, UNIQUE, SORT)
- Power Query, Power Pivot
- Financial modelling
- VBA / macros
Our list of advanced Excel skills explains each one.
How to describe your level
Avoid vague labels like "expert" unless you can back them up in a test. Group skills instead:
Excel: lookups (XLOOKUP, VLOOKUP), conditional sums (SUMIFS, COUNTIFS), pivot tables, data cleaning, charts
That tells a recruiter exactly what you can do and matches the keywords applicant tracking systems scan for.
Bullet points that prove it
Weak:
- Used Excel for reporting.
Better:
- Built a weekly sales report in Excel with SUMIFS and pivot tables, cutting preparation time from about 3 hours to 30 minutes.
- Cleaned and merged two customer lists (about 4,000 rows) using XLOOKUP and TRIM, removing duplicates before a mailing.
- Created a budget tracker with variance formulas used by a team of 6.
Use real numbers from your own work, even approximate ones. If you're a student, use projects: "Analysed survey results for a class project with COUNTIFS and charts."
If you don't have experience yet
- Do a small project and describe it: a personal budget, a sports stats tracker, a price comparison.
- Practise for the test you'll probably face. See Excel test for job interview.
- Learn the gap skills first. Most people who struggle in tests trip on $ references and lookups.
Cellio is a quick way to build the core: two-minute lessons on formulas, $ locks and fill down, where you write every formula yourself and get told exactly what went wrong.
Frequently asked questions
Should I put Excel on my resume?
Yes, if the role uses spreadsheets, but list specific skills rather than just "Excel".
What level of Excel do employers expect?
For most office jobs: core formulas, $ references, IF, COUNTIF/SUMIF, a lookup function, sorting and filtering. Analyst roles add pivot tables and data cleaning.
How do I prove my Excel skills?
Through concrete resume bullets, a portfolio file, or by doing well on the employer's Excel assessment.
Is "proficient in Excel" a good phrase?
It's too vague on its own. Follow it with the actual functions and tools you use.