Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

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
  1. Basic Excel skills
  2. Intermediate Excel skills
  3. Advanced Excel skills
  4. Which level jobs ask for
  5. Excel skills on your resume
  6. How to improve
  7. Keep learning
  8. FAQ

Basic Excel skills

Basic skills are what you need to work with any spreadsheet: enter data, do simple calculations and make it readable.

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".

Advanced Excel skills

Advanced users build models and reports that others rely on. They combine functions and pick the right tool for the job.

Which Excel level do jobs ask for?

Job ad saysUsually meansTypical roles
"Basic Excel", "MS Office"BasicCustomer service, retail, reception
"Good Excel skills"IntermediateOffice and admin, sales support, HR, planning
"Strong" or "advanced Excel"AdvancedData 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.

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.