How to Describe Your Excel Skills in an Interview
By ExcelReady TeamUpdated 4 min read
The short answer
To describe your Excel skills in an interview, name a real task, the functions you used and the result, for example "I built a weekly sales summary with SUMIFS and a pivot table that the team used every Monday". Give an honest level, back it with specific examples and be ready to show it in a test.
Key takeaways
- Describe a task, the tools and the result, not just a level like "advanced".
- Name specific functions and features: SUMIFS, XLOOKUP, pivot tables, conditional formatting.
- Rate yourself honestly, because many employers check with a test.
- Without work experience, use projects, coursework or practice tasks as your examples.
On this page+
How to describe Excel skills in an interview comes down to one habit: talk about what you did with Excel, not how good you think you are. "I'm advanced in Excel" tells an interviewer nothing. "I built a weekly sales report with SUMIFS and a pivot table" tells them exactly what you can do. This guide gives a simple structure, sample answers you can adapt and the questions you're likely to hear.
Why "I'm good at Excel" isn't enough#
Interviewers hear "proficient in Excel" from almost everyone. Without detail, they can't tell a person who has typed a few totals from one who builds reports every week. Many employers also check with a practical test, so vague claims get tested anyway.
Specific answers do three things at once: they show what you know, they make you believable and they give the interviewer something to ask about. That follow-up conversation is where you can really stand out.
A simple structure: task, tools, result#
Use three parts for any Excel example:
- Task: what needed doing, and why. "Our team needed to see sales by region every Monday."
- Tools: the functions and features you used, named exactly. "I used SUMIFS for the totals and a % of total column, and conditional formatting to flag regions below target."
- Result: what changed. "The report went from a manual job to a few minutes, and managers could spot problems straight away."
Name functions in their real form: SUMIFS, XLOOKUP, INDEX MATCH, pivot tables, data validation. If you can, mention a detail that only someone who has done it would know, such as locking a rate with $ or using FALSE in VLOOKUP for an exact match.
Sample answers you can adapt#
These are templates. Swap in your own task and numbers, and only claim what you've really done.
Admin or HR role: "In my last role I kept the staff roster in Excel. I used XLOOKUP to pull each person's department from the HR list, COUNTIFS to report headcount by department, and DATEDIF to work out years of service for the anniversary list. Before that, someone counted by hand each month." The skills behind this answer are covered in Excel skills for HR jobs.
Sales or operations role: "I built a weekly sales report. Revenue by region came from SUMIFS, and I added a % of total column so managers could see each region's share. Conditional formatting highlighted anyone under target." See Excel skills for sales operations for the formulas.
Fresher or career changer: "For a college project I analysed survey results in Excel. I cleaned the responses with TRIM, counted answers with COUNTIF and built a pivot table and a chart for the presentation. I've since practised lookups and SUMIFS on timed exercises."
How to state your level honestly#
Interviewers often ask you to rate yourself. Give a level you can prove, then explain it with what you can and can't do yet:
| If you can... | Say something like... |
|---|---|
| Enter data, use SUM and AVERAGE, sort and filter | "Basic to intermediate: I'm comfortable with formulas and tidy data, and I'm learning lookups." |
| Use VLOOKUP or XLOOKUP, SUMIFS, IF and pivot tables without help | "Intermediate: I use lookups, conditional totals and pivots regularly." |
| Use INDEX MATCH, dynamic arrays, multi-condition lookups | "Advanced in formulas and pivots; I haven't needed macros yet." |
Saying what you haven't done yet sounds confident, not weak. It also protects you if a test follows.
Questions you'll likely hear, and how to answer#
"Rate your Excel skills from 1 to 10." Give the number, then the reason: "A 6. I use lookups, SUMIFS and pivot tables every week, but I haven't written macros." Avoid 10; it invites a very hard follow-up.
"What's the most complex thing you've done in Excel?" Pick one example and use task, tools, result. Complexity can be modest if you explain it well. A clear story about a two-condition SUMIFS that fixed a messy monthly report beats a vague mention of macros you can't describe. Say what was hard about it and how you checked the answer was right.
"How would you find a customer's order total from a list of 5,000 orders?" Talk it through: "I'd use SUMIFS with the customer ID as the condition, or a pivot table if I needed every customer." Being able to choose between tools is what they're listening for. The list of 25 Excel interview questions has more of these.
"Can you show us?" Say yes, and mean it. Many interviews include a short practical task or a case study. The guides on how to pass an Excel test for a job interview and the Excel case study interview explain what to expect.
Back up your words with practice#
The best way to describe Excel skills confidently is to have used them recently. Before the interview, work through one realistic task end to end, so your examples are fresh and your hands remember the formulas. For example, if you say you built a % of total column, you should be able to type =B2/SUM($B$2:$B$5) on the spot and explain why the $ signs are there. For a quick check of your level against the clock, take the Excel screening quiz.
Practise it#
Practise the two scenarios interviewers ask about most. Work the HR roster interview drill, with lookups, counts, totals and tenure, and the sales report interview drill, with revenue by region and a % of total column. Each task checks your formula instantly, so you'll walk into the interview with real, recent examples to describe.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
Back up a claim like "I added a % of total column to the sales report". Click C2 and divide North's revenue in B2 by the total of B2:B5.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | % of total | |||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 |
Tip: Divide the region's revenue by SUM of all four regions.
Practise this in a lesson
Frequently asked questions
How do I describe my Excel skills in an interview?
Describe a real task, the functions you used and what changed as a result. For example: I cleaned a list of 2,000 customer records with TRIM and removed duplicates, then summarised sales by region with SUMIFS. Then say what level that puts you at.
How do I rate my Excel skills from 1 to 10?
Give a number you can back up, then explain it: for example, a 6 because you use lookups, SUMIFS and pivot tables every week but haven't used macros. The explanation matters more than the number.
Should I say I'm advanced in Excel?
Only if you can do advanced tasks without help, such as INDEX MATCH, two-condition lookups, dynamic arrays and complex pivots. Many employers test Excel skills, so claiming more than you can show tends to backfire.
What if I have no work experience with Excel?
Use examples from coursework, a club or volunteer role, a personal budget or practice tasks. Describe them the same way: the task, the functions and the result.