How to Prove Your Excel Skills to an Employer

If you're wondering how to prove Excel skills to an employer, the answer is to show the work, not describe it. Almost every CV says "advanced Excel", so the words alone carry little weight. What convinces a hiring manager is evidence: a passed skills test, a clean sample workbook, specific resume bullets and a confident live demo. This guide shows how to build each one, starting with the proof employers ask for most.

Why saying "advanced Excel" isn't enough#

"Advanced" means different things to different people. To one manager it means VLOOKUP; to another it means Power Query and dynamic arrays. A level on its own doesn't tell anyone what you can actually do.

So employers check. Many send an online Excel assessment, set a task during the interview, or ask you to walk through a file. Your goal is to have proof ready for each of these, and to describe your level honestly. The guide to Excel proficiency levels explains what basic, intermediate and advanced usually mean, so you can pick the right word.

If you're not sure where you stand, take the Excel level test first. It takes a few minutes and tells you which skills to strengthen before you apply.

1. Pass the employer's Excel test#

The most direct proof is passing the test the employer gives you. These tests are usually timed and practical: you complete tasks in a spreadsheet or answer questions about formulas.

Prepare the same way you'd train for any timed task:

• Practise under a timer. Knowing SUMIF is different from writing it correctly in 90 seconds. Timed online mock tests build that speed.
• Match the level to the job. Admin roles usually test basics like totals, sorting and simple formulas. Analyst roles add lookups, conditional totals and PivotTables. Try the intermediate Excel test if the role mentions lookups or reporting.
• Know the format. If the invitation names the platform, read a guide to it, such as the TestGorilla Excel test guide or the SHL Excel test guide. These pages explain the format and the skills to practise. ExcelReady doesn't have any provider's real questions and isn't affiliated with them.

A typical task looks like the exercise on this page: total the revenue for one region with SUMIF, quickly and without errors.

2. Build a small Excel portfolio#

A portfolio is two or three workbooks that show what you can do. It's the best proof if you're changing careers or don't yet have Excel on a job title. Keep each one small, clean and focused on one skill set:

A few rules make a portfolio convincing:

1. Use made-up or public data. Never share a current or past employer's files.
2. Separate inputs, calculations and outputs. Put raw data on one sheet and the summary on another, with clear headings.
3. Add a short notes sheet. Explain the question, the steps and what you found in a few sentences.
4. Make it easy to open. Share a link to the file in OneDrive or Google Drive, plus a PDF of the summary for people reading on a phone.

If you need ideas, the sales report interview drill and the real estate case study are good models: each one is a realistic task you can rebuild on your own data.

3. Write resume bullets that show the work#

Resume bullets prove skill when they name a task, the tools you used and what changed. Compare:

Only include numbers you can back up, such as how many reports or how much time a process took before and after. If you're asked in the interview, you'll need to explain them. The guide to listing Excel skills on a resume has more examples by job type.

4. Show it live in the interview#

Some interviews include a live task: "here's a file, find the top region" or "talk me through how you'd build this report". This is where real practice shows.

• Talk while you work. Say what you're doing and why: "I'll use SUMIFS here because there are two conditions."
• Check your answer. Compare a total with a quick SUM or a filter. Interviewers notice candidates who check.
• Have a story ready. Describe one spreadsheet you built using the situation, task, action and result pattern. The guide to describing Excel skills in an interview shows how.
• Know a PivotTable cold. Summarising data by category is one of the most common live tasks. The PivotTable lesson takes you through it step by step.

If you get stuck, say how you'd find the answer. Knowing where to look is a real skill too.

5. Consider a certification#

A certification is formal proof that you passed a standard exam. Microsoft offers Microsoft Office Specialist (MOS) certifications for Excel at Associate and Expert levels. They can help early in your career, or when a job advert asks for one by name.

A certificate doesn't replace the other proof, though. Many employers still give their own test, because it checks the exact tasks the job needs. The guide to Excel certifications for jobs compares the options.

Which proof should you focus on?#

Pick the proof that matches your situation:

Most people need two of these, usually test practice plus either a portfolio or stronger resume bullets.

Practise it#

Start with the exercise on this page, then build the skills employers check most. Practise a full sales report like an Excel test, work through the real estate case study, and build PivotTables in a live spreadsheet. Every step is checked instantly, so you know your skills are real before an employer tests them.