Microsoft Excel Skills for Your Resume, From Basic to Advanced
"Proficient in Microsoft Excel" shows up on so many resumes that readers skip right past it. The fix is to name what you do in Excel and what it was for. Below you'll find the features that usually mark basic, intermediate and advanced users, phrases to use in place of "proficient," bullets for six kinds of jobs, and a short plan for the Excel test some employers give.
What each level usually means
There's no official scale, but most employers read the levels roughly like this.
Basic. Entering and formatting data, sorting and filtering, simple formulas such as SUM, AVERAGE and COUNT, basic charts, freezing panes and printing a clean page.
Intermediate. PivotTables and PivotCharts, XLOOKUP or VLOOKUP, IF combined with AND and OR, SUMIFS and COUNTIFS, conditional formatting, data validation drop-downs, named ranges, protected sheets and formulas that pull from several tabs.
Advanced. Power Query for cleaning and combining data, Power Pivot and data models, dynamic array functions like FILTER, UNIQUE and SORT, LET and LAMBDA, What-If Analysis and Solver, macros and VBA, and dashboards driven by slicers.
Claim the highest level at which you can do most of the listed items without looking them up. Then name two or three features in your skills line, because "advanced Excel" alone doesn't say which kind of advanced you are. A financial analyst's advanced and an operations coordinator's advanced can look very different.
Replacing "proficient in Excel"
| Vague | Specific |
|---|---|
| Proficient in Excel | Excel: PivotTables, XLOOKUP, conditional formatting |
| Advanced Excel skills | Excel (advanced): Power Query, data models, VBA macros |
| Strong spreadsheet skills | Built and maintained weekly sales reports in Excel for 12 stores |
| Excel expert | Created the team's Excel templates for budgets and vendor tracking |
Leave out stars, bars and self-ratings. Nobody can tell what four stars in Excel means.
Excel bullets for six kinds of jobs
Accounting and bookkeeping
- Reconciled bank and card statements in Excel with SUMIFS and lookup checks, cutting month-end tie-out from two days to one
- Built a receivables aging report with PivotTables that the controller reviewed every Monday
Operations and supply chain
- Combined weekly shipment exports from three warehouses with Power Query, replacing a manual copy-and-paste routine
- Tracked reorder points with conditional formatting that flagged low stock automatically
Sales and marketing
- Created a pipeline dashboard with slicers so regional managers could filter by rep and month
- Cleaned and deduplicated event lead lists before they went into the CRM
Office and administration
- Kept the supply budget and vendor contacts in shared workbooks, using data validation to stop entry errors
- Turned a paper staff calendar into an Excel schedule the team updated themselves
Analyst roles
- Built a forecasting model with What-If scenarios that finance used in quarterly planning
- Automated a 40-step monthly report with VBA so it ran in minutes instead of an afternoon
Teaching, nonprofits and small business
- Tracked grades, attendance or donations in Excel and summarized them in charts for staff meetings
Where Excel belongs on the page
When a job leans on spreadsheets, give Excel its own line in the skills section and list features:
Excel: PivotTables · XLOOKUP · SUMIFS · Power Query · charts and dashboards
When Excel is only a supporting tool, fold it into a software line, such as "Microsoft Office (Excel, Word, PowerPoint) · Google Sheets." Either way, back it up with one or two experience bullets that say what the spreadsheet did for the team. A reader believes "built the weekly labor report" far more than a feature list alone.
Preparing for an Excel test
Some employers, especially for finance, administrative and analyst roles, give a short Excel test during hiring. These usually cover lookups, PivotTables, basic formulas and cleaning up a messy table. Before you claim a level, practice those tasks in a blank workbook with a timer running. If the result surprises you, it's better to find out at home than in the test.
Quick answers
Should I list Google Sheets separately?
Yes, if the posting mentions it or you used it at work. Most skills carry over, but some functions and features differ, so list the program you actually used.
Is "Microsoft Office" enough?
For jobs that barely touch spreadsheets, yes. If the posting names Excel or mentions reporting, list Excel on its own with features.
The resume builder can suggest wording for your skills section while you write. If your Excel work is mostly about finding patterns in data, our page on data analysis skills covers the next step.