Excel skills for your resume

Basic Excel skills: what you should be able to show

Basic means you can build and fix a simple sheet without looking anything up. If a resume says "Excel", employers will assume at least this.

• Enter data, format it as currency, percent or date, and freeze the header row
• Write formulas with + - * / and cell references, and copy them down correctly
• Use SUM, AVERAGE, MIN, MAX, COUNT and COUNTA
• Use $ to lock a reference (absolute references)
• Sort and filter a list without scrambling the rows
• Write a simple IF, such as "Over budget" or "OK"
• Make a basic chart and print a sheet on one page

Intermediate Excel skills

Intermediate is where most office reporting lives: pulling data together and summarizing it by category.

• COUNTIF, SUMIF, COUNTIFS and SUMIFS, with conditions typed in cells rather than in the formula
• VLOOKUP with an exact match, and XLOOKUP or INDEX/MATCH
• IF with AND or OR, nested IF or IFS, and IFERROR or IFNA
• Text cleanup: TRIM, LEFT, RIGHT, MID, TEXTJOIN, Text to Columns, Remove Duplicates
• Dates: days between dates, NETWORKDAYS, EOMONTH, DATEDIF
• PivotTables, conditional formatting and data validation drop-downs
• Percent change, percent of total and rounding with ROUND

Advanced Excel skills

Advanced is less about knowing more functions and more about building sheets that are correct, fast to update and hard to break.

• Dynamic arrays: FILTER, SORT, UNIQUE and SEQUENCE (Excel 365 and 2021)
• Two-way and multi-condition lookups; XLOOKUP match and search modes
• SUMPRODUCT and array logic for conditions SUMIFS cannot express
• Excel Tables and structured references so reports grow with the data
• PivotTables with calculated fields, grouping and slicers; Power Query for repeat imports
• Checking and auditing: Evaluate Formula, trace precedents, cross-check totals
• Macros or VBA, only if you can write or edit them yourself

How to word Excel skills on a resume

Two places work best. A skills line lists the tools, and your experience bullets show what you did with them. Describe the task, the tools and who used the result. Add a number only if it is real and you could explain it in an interview.

A skills line can be as simple as: Excel (XLOOKUP, SUMIFS and COUNTIFS, PivotTables, data cleanup, conditional formatting). Mirror the wording of the job post where it is true for you.

Example bullets that describe tasks, ready to adapt to what you actually did:

• Built a weekly sales report in Excel that totals orders by region with SUMIFS and flags late shipments with IF and conditional formatting.
• Cleaned and merged customer lists from two systems using XLOOKUP, TRIM and Remove Duplicates before each mailing.
• Maintained the team inventory sheet: reorder alerts with IF, a monthly summary with a PivotTable, and drop-down lists to keep entries consistent.
• Created a budget-versus-actual tracker with variance formulas for the monthly review meeting.
• Set up a shared timesheet that calculates hours and overtime with time formulas, replacing a hand-totaled paper sheet.

How to prove your Excel skills

Whatever you list, assume you may be asked to show it. These help you get ready and give you something concrete to point to.

• Take the free Excel practice test at the level the job asks for. Treat the score as a self-check, not a credential: aim for 8 out of 10 or more a few times in a row before you list that level.
• Practice hands-on in the Cellwise app, where you type real formulas, and try its timed skills assessment.
• Cellwise Plus members get a certificate of completion for each unit they finish, and one for the whole course. It shows you completed that training; it is not a proctored exam, so list it under Training rather than Certifications.
• If you want a proctored credential, Microsoft offers the Microsoft Office Specialist (MOS) exams for Excel.
• Build one small sample workbook with made-up data, never an employer's files, that shows the skills you list, and be ready to walk through it.