Home › Excel basics › Excel skills by level
Excel skills: basic, intermediate and advanced
"Good Excel skills" is on half of all job ads, but what does it mean? Here are the Excel skills per level, basic, intermediate and advanced, which level different jobs ask for, and how to describe your skills on your resume so a recruiter believes you.
In this guide
Basic Excel skills
Basic skills are what you need to work with any spreadsheet: enter data, do simple calculations and make it readable.
- Entering and editing data, using AutoFill for series.
- Simple formulas:
+ - * /and SUM, AVERAGE, MIN and MAX, COUNT. - Percentages and rounding.
- A simple IF.
- Absolute references like $A$1.
- Sorting and filtering, freezing the header row.
- Formatting numbers, dates and currency; a simple chart.
Intermediate Excel skills
At the intermediate level you combine data from several places and summarise it. This is what most office jobs mean by "good Excel skills".
- Lookups: VLOOKUP and XLOOKUP.
- Counting and adding with conditions: COUNTIFS and SUMIFS.
- Error handling with IFERROR; AND and OR inside IF.
- Text functions: TRIM, LEFT, RIGHT and MID, joining text.
- Dates: DATEDIF, NETWORKDAYS, EOMONTH.
- Pivot tables, Excel tables, conditional formatting and drop-down lists.
- Cleaning data: removing duplicates, Text to Columns.
Advanced Excel skills
Advanced users build models and reports that others rely on. They combine functions and pick the right tool for the job.
- INDEX MATCH and lookups with several conditions.
- Dynamic arrays: FILTER, UNIQUE, SORT.
- SUMPRODUCT, nested IF and IFS, INDIRECT.
- Reports that update by themselves, from tables and pivot tables.
- Charts for dashboards, such as a Gantt chart.
- Often also: Power Query, macros (VBA) and what-if analysis.
Which Excel level do jobs ask for?
| Job ad says | Usually means | Typical roles |
|---|---|---|
| "Basic Excel", "MS Office" | Basic | Customer service, retail, reception |
| "Good Excel skills" | Intermediate | Office and admin, sales support, HR, planning |
| "Strong" or "advanced Excel" | Advanced | Data analyst, financial analyst, controller, consultant |
Not sure where you stand? The Excel level test tells you in about 10 minutes.
How to put Excel skills on your resume
- Name the level and the skills. "Excel (intermediate): XLOOKUP, SUMIFS, pivot tables" says more than "proficient in Excel".
- Show what you did with it. "Built a weekly sales report in Excel that saved the team two hours a week."
- Make it checkable. Add a link to a certificate with your score, from one of the Excel tests.
- Don't overclaim. Many employers test Excel. "Advanced" on your resume and a basic score in the assessment costs you the job.
How to move up a level
Practise, don't just read. Typing a formula yourself is what makes it stick. The Excel lessons take you from basic to advanced in short steps, with a test at the end of each block. Then take the basic, intermediate or advanced Excel test to prove your level.
Keep learning
Frequently asked questions
What are basic Excel skills?
Entering data, simple formulas like SUM and AVERAGE, percentages, a simple IF, absolute references, sorting and filtering, and formatting a table or a chart.
What are intermediate Excel skills?
Lookups with VLOOKUP or XLOOKUP, SUMIFS and COUNTIFS, IFERROR, text and date functions, pivot tables, and cleaning data.
What are advanced Excel skills?
INDEX MATCH, lookups with several conditions, dynamic arrays like FILTER and UNIQUE, SUMPRODUCT, and building reports and models that update by themselves.
How do I describe my Excel skills on a resume?
Name your level and the main skills, give one example of what you achieved with them and, if you can, link to a certificate with your score.
How long does it take to get from basic to intermediate Excel?
With 15 to 20 minutes of practice a day, most people get there in a few weeks. Lookups, SUMIFS and pivot tables are the big steps.