You control your data

We use cookies to tailor the experience of creating resumes and cover letters. For these reasons, we may share your usage data with third parties. You can find more information about how we use cookies on our Cookies Policy. If you would like to set your cookies preferences, click the Settings button below. To accept all cookies, click Accept.

Settings Accept

Cookie settings

Click on the types of cookies below to learn more about them and customize your experience on our Site. You may freely give, refuse or withdraw your consent. Keep in mind that disabling cookies may affect your experience on the Site. For more information, please visit our Cookies Policy and Privacy Policy.

Choose type of cookies to accept

Analytics

These cookies allow us to analyze our performance to offer you a better experience of creating resumes and cover letters. Analytics related cookies used on our Site are not used by Us for the purpose of identifying who you are or to send you targeted advertising. For example, we may use cookies/tracking technologies for analytics related purposes to determine the number of visitors to our Site, identify how visitors move around the Site and, in particular, which pages they visit. This allows us to improve our Site and our services.

Performance and Personalization

These cookies give you access to a customized experience of our products. Personalization cookies are also used to deliver content, including ads, relevant to your interests on our Site and third-party sites based on how you interact with our advertisements or content as well as track the content you access (including video viewing). We may also collect password information from you when you log in, as well as computer and/or connection information. During some visits, we may use software tools to measure and collect session information, including page response times, download errors, time spent on certain pages and page interaction information.

Advertising

These cookies are placed by third-party companies to deliver targeted content based on relevant topics that are of interest to you. And allow you to better interact with social media platforms such as Facebook.

Necessary

These cookies are essential for the Site's performance and for you to be able to use its features. For example, essential cookies include: cookies dropped to provide the service, maintain your account, provide builder access, payment pages, create IDs for your documents and store your consents.

To see a detailed list of cookies, click here.

Save preferences
My Account
How to Describe Microsoft Excel Skills on Your Resume

How to Describe Microsoft Excel Skills on Your Resume

Spreadsheets can be a nightmare, but let’s face it—everyone needs them. Read why Excel skills are valuable, how to improve them, and how to describe Excel skills on a resume.

As seen in:

Some people thrive on spreadsheets, and some avoid them like the plague. Still, basic Excel skills are considered one of the critical digital literacy elements. Even artists use them, and not only for their works of art.

 

If you repeatedly notice that all interesting jobs require intermediate or advanced Excel skills, it’s high time to do something about it. Read on and learn what Excel skills employers are looking for, what advanced Excel skills are, and how to describe Excel skills on a resume.

 

This guide will show you:

 

  • What the basic, intermediate, and advanced Excel skills are.
  • Where to learn intermediate and advanced Excel skills easily.
  • How to list Excel skills on your resume.

 

Want to save time and have your resume ready in 5 minutes? Try our resume builder. It’s fast and easy to use. Plus, you’ll get ready-made content to add with one click. See 20+ resume templates and create your resume here.

 

Create your resume now

 

Sample resume made with our builder—See more resume examples here.

 

Excel is just one of the popular programs from Microsoft. Do you know what other Microsoft Office skills employers want? See here: 20+ Microsoft Office Skills on a Resume

 

Want to learn more about useful workplace skills? Check these articles:

 

 

What Are Basic Excel Skills?

 

Basic Excel skills are the fundamental skills needed to use Microsoft Excel and work with spreadsheets. Users with basic Excel skills can open, create, and save a file, navigate sheets, input data and format cells, use simple functions, create charts, and sort data.

 

If you spent your life hoping you could avoid using spreadsheets, I’ve got bad news for you. According to a study, around 80% of middle-skilled jobs require at least a basic knowledge of Excel.

 

Luckily, it’s not very difficult to learn basic Excel and Google Sheets skills. But first, you need to understand which functions and abilities are considered basic.

 

Basic Excel Skills

 

  1. Opening, saving, and creating new files
  2. Managing sheets
  3. Formatting cells
  4. Finding and replacing data
  5. Sorting data
  6. Creating charts
  7. Using simple functions such as SUM, COUNT, AVERAGE, SUMIF, COUNTIF

 

See? Nothing to be afraid of, really. There’s a good chance that you know how to use at least some of those things, even if you hate Excel with a passion. If you don’t feel confident about your abilities, grab a tutorial and learn those basic Excel skills ASAP.

Pro Tip: If you don’t want to spend money on buying a Microsoft Excel license just to learn how to use spreadsheets, you can use Google Sheets as a free alternative. You simply need a Google account to access Sheets, and you can try many spreadsheet functionalities with this app. In fact, many workplaces moved from using Excel to G-Sheets, as they can store files in the cloud, so it’s easy to share with entire teams.

How to Learn Intermediate and Advanced Excel Skills?

 

To learn intermediate Excel skills, you simply need to chant under the full moon, “GIVE ME YOUR POWERS, EXCEL!”

 

Just kidding.

 

There are plenty of resources you can use to master spreadsheets. Books, websites, video tutorials, online courses… But before you choose one, you must ask yourself a very important question.

 

What’s your level of Excel knowledge?

 

If you’re unsure, there are two solutions: take a look at the list of intermediate and advanced Excel skills below and see which of them you’ve got, or just take an Excel skill test and find out.

 

Intermediate Excel Skills

 

  1. Drop-Down Lists: add a predefined list of values to help enter data in select cells quickly.
  2. Text to Column: split a single column into multiple columns using a separator, such as a comma, dot, semicolon, etc.
  3. Filters: apply filters to specific columns to help you sift through the data.
  4. Go To Special: move to a specific cell or a range of cells within the sheet.
  5. Pivot Table: create a summary table from a data source.
  6. Named Range: name a cell or a range of cells to refer to them specifically.
  7. Conditional Formatting: apply visual changes (e.g., colors) to cells based on specific conditions.
  8. Sparklines: add mini charts to cells to visualize data trends.
  9. Quick Analysis Tool: basic options for data analysis.
  10. IFERROR: avoid showing errors in calculations by replacing the error code with a predefined value.

 

If the list above sounds like black magic to you, then it’s best to start learning those magic Excel tricks. They can make your office life easier.

 

Advanced Excel Skills Checklist:

 

  1. Monte Carlo Simulation: solve complex issues through random and probabilistic methods.
  2. VLOOKUP: look up one of the values in a table or retrieve information from a column.
  3. INDEX MATCH: pull up the corresponding value of another cell, which can be helpful for preparing reports, financial summaries, etc.
  4. Power Pivot: pull data from external sources into your spreadsheet.
  5. Power Query: import or connect external data in order to shape it and load it into Excel.
  6. Macros: automate an action, or a series of actions, that are often repeated.
  7. AutoFilter: turn the values in columns into filters based on the data in the cells.
  8. INDIRECT: convert text into a value reference.
  9. Flash Fill: edit data on a single cell or row, which is then automatically edited similarly in other cells.
  10. Add-ins: find and install Excel add-ins to perform certain tasks faster and easier.

 

OK, I know that this list was a bit intimidating. But not everyone needs to be an Excel expert! Knowledge of advanced-level Excel skills can land you good jobs in business and data analytics. But not all professions require being a spreadsheet magician.

 

Excel Skills Tests: Where to Find Them?

 

Knowing what beginner, intermediate, and advanced Excel skills are makes it easier to establish your proficiency. However, most employers don’t trust job applicants blindly. If they need an Excel pro, they will test candidates' knowledge before hiring them.

 

While some companies prepare their recruitment tasks and ask the candidates to complete them within a specified time frame, some businesses prefer using third-party tests. For example:

 

  • SHL Microsoft Excel Tests: these include Interactive, Interactive-Essentials, and Adaptive tests. While the Adaptive format uses multiple-choice questions of varying difficulty, the Interactive tests use simulation software and tasks that must be completed within a specified time.
  • Kenexa Prove It! Excel Tests: these interactive tests are designed for Normal Users (basic level) and Power Users (advanced level) and include a series of tasks that must be completed on simulation software.

 

If you have traumatic high-school memories that include standardized tests, don’t worry—you’re not alone. Even experts agree that standardized tests have significant drawbacks. However, sometimes you can’t just avoid them by hiding under your desk. You can only minimize the stress by preparing yourself beforehand.

 

The best way to prepare for an Excel skills test is to try out practice tests. Finding them online is pretty easy, but not all of them are free.

 

Check these free Excel skill tests to test your knowledge:

 

  • The Excel Club: this Excel training website currently offers two free tests that check the knowledge of Lookup Functions as well as knowledge of Date, Time, and Text Functions.
  • Wise Owl Training: this UK-based training center offers three Excel skills tests: Excel 365 test, Excel VBA test, and Legacy Excel tests, each with a pool of 100+ questions.
  • Corporate Finance Institute: this provider of online financial certification programs offers a free Excel test—you only need to provide your email address to receive your results.
  • LinkedIn Excel Skills Assessment: this multiple-choice test is available in English and French languages. If your results are in the top 30%, you’ll receive a badge to add to your LinkedIn profile.

 

If you feel you need to brush up on your knowledge, you can find many YouTube videos with Excel tips and tricks. They’re free, easily available, and more user-friendly than many text-based tutorials.

 

You can improve your Excel skills with online courses as well. They will not only equip you with the most useful and up-to-date knowledge of spreadsheets but also provide a certificate of completion that you can put on your resume. Browse online Excel courses on Coursera, EdX, and Udemy to find something suitable for you.

 

Excel Skills on a Resume

 

Modern-day workplaces use Excel for virtually anything, from the creation of sign-up forms for office parties to preparing in-depth reports that use external data sources. Even if you don’t have an office job, you can use Google Sheets to monitor your expenses, track workouts, or plan a holiday budget.

 

But some jobs need Excel more than others. In order to get those, it’s important to show off your Excel skills on a resume.

 

Now, you might be thinking: “I’ll just add ‘Excel’ to the list of skills on my job application.” The problem is that hundreds of other candidates will do the same. 

 

Read on, and see how to do it better.

 

What Excel Skills Are Employers Looking for?

 

Not all Excel skills were created equal, and that’s why some are considered basic and others advanced. However, many administrative and corporate jobs require a mix of all skill categories. It’s easy to notice that when reading job advertisements on job search websites.

 

So, which Excel skills are important for employers? See below:

 

  • Basic functions like SUM, COUNT, IF, AVERAGE, MIN., MAX.
  • VLOOKUP and XLOOKUP
  • INDEX/MATCH
  • SUMIF, COUNTIF
  • Pivot Tables
  • Filters
  • Charts
  • Macros
  • Data Simulations
  • Conditional Formatting

 

Now, don’t feel discouraged if you can’t do some of the above. You don’t need years to master spreadsheets. You can learn at least some of those in an hour!

 

You can start updating your resume sections to highlight your spreadsheet knowledge if you already possess those in-demand Excel skills.

Black-and-white resumes typed in Arial are a thing of the past. Get with the times. See here: 20+ Contemporary Resume Layouts

How to List Excel Skills on a Resume?

 

You’re all excited about that job ad you’ve just found, and that’s great. But the requirements say “Proficient in Microsoft Excel,” and you’re not sure how to show it in your resume.

 

Don’t worry. We’ve got your back!

 

Depending on your chosen resume format, you can add your Excel skill level to various sections. In the most popular reverse-chronological resume, add it to your skill list, as well as mention using Excel in the work experience section (and while describing other accomplishments, like academic achievements or a volunteering experience). If your job requires using Excel skills on a daily basis, mention your expertise in your resume summary or career objective.

 

Check the examples below to see how it’s done:

 

Advanced Excel Skills on a Resume: Resume Summary

Right

Meticulous Certified Public Accountant with 5+ years of experience and advanced Excel skills. Keen to optimize Yorkie Designs’ accounting operations by implementing new user-friendly budget tracking spreadsheets and improving the accuracy of reports through macros. Helped to avoid a significant financial loss of $123,500 by identifying fraudulent payment orders in 2021.

Well, well, well… This person knows what’s what. They did more than just mention their Excel proficiency level. They’ve also thrown in mentions of spreadsheets and macros to put theory to good use.

 

Now, let’s see how to include Excel skills in the work experience description:

 

Excel Skills on a Resume: Work Experience

Right

Accountant

Aquarius Fund, San Diego, CA

February 2019–Present

  • Created budget tracking Excel spreadsheets for each department head to help monitor expenditures regularly, leading to a 93% adherence to planned budgets.
  • Used Pivot Tables to pull data from a range of sources in order to automate the creation of monthly journal entries and tax statements.
  • Collected statistical data to prepare financial reports for the board of directors.
  • Led Excel training for accounting interns that received 100% positive feedback from participants. 

If that doesn’t cry EXCEL EXPERT, then I don’t know what will. As you can see, it’s pretty easy to show off your Excel skills if you have a pretty good knowledge of spreadsheets. And if you include it in the work experience section, then you don’t have to stuff the skill list with each particular Excel function that you know. This leaves space for other skills!

 

Check a sample skill section below:

 

Excel Skills on a Resume: Sample Skill Section

Right

Skills

 

  • Financial accounting and bookkeeping
  • Managing balance sheets
  • Financial auditing
  • Taxation
  • Problem-solving
  • Time management
  • QuickBooks
  • Microsoft Excel and Google Sheets

It’s as simple as that, especially if your job obviously involves using spreadsheets. Now, if your profession isn’t closely related to the administration or data analysis but it requires knowledge of Excel, you can add it to your skill list differently. Check the example below:

 

Example of Excel Skills on a Resume

Right

Skills

 

  • Graphic design
  • Digital illustration
  • Packaging design
  • Collaboration
  • Creativity
  • Advanced Adobe Illustrator and Photoshop knowledge
  • Intermediate Microsoft Excel and Google Sheets knowledge

Of course, that’s not the end of your resume yet. There’s one more thing that employers really like. And that’s certificates and licenses on a resume! So if you have a brand-new, shiny Excel certificate, mention it ASAP. Have a look at the example below:

 

Certificates of Excel Skills on a Resume: Example

RIGHT

Certifications

 

Microsoft Office Specialist: Excel Associate, 2020

Short and to the point. If the certificate was issued by an educational institution or a specific program, mention it along with the year when you obtained it.

 

Now, the above-mentioned resume sections are common in most resume formats. However, if you decide to go for a functional resume or a combination resume, you have another option of including your spreadsheet mastery. Those formats use an extended skill summary, which offers a great opportunity to brag about your advanced Excel skills. Check the example below to see what I’m talking about:

 

Excel Skills on a Resume: Skills Summary

Right

Microsoft Excel and Google Sheets

 

  • Created automated reporting spreadsheets using Pivot Tables and Power Queries for the marketing department to support their decision-making processes.
  • Prepared data visualizations with Excel charts for weekly and monthly presentations.
  • Built project schedules to track milestones, updates, and work progress of all team members on a regular basis.
  • Applied conditional formatting to spreadsheets containing sales data to help notice market trends.

See? There are so many things that can be done with a bit of Excel knowledge. And there are so many ways to show them off later in your resume!

Thinking of changing jobs? How about letting headhunters do the tedious work of scrolling through thousands of job ads? See here: Finding a Job Through a Headhunter

Key Takeaway

 

Now, we’ve covered everything you need to know about Excel skills. Need a reminder of the essential spreadsheet knowledge you should know to impress recruiters? OK, here it goes:

 

  • Learn by heart the spreadsheet functions like SUM, COUNT, IF, VLOOKUP and XLOOKUP, SUMIF and COUNTIF, Pivot Tables, and others.
  • Master the art of applying filters, creating charts, and using macros.
  • Highlight the Excel skills on a resume by adding them to the resume profile, work experience, skill list, and additional resume sections.

 

Now, either start learning or update your resume to get the job you want!

 

That’s it! Thanks for reading this article. Now, over to you—put your two cents in and tell me:

 

  • Do you find using Excel and Google Sheets easy?
  • Do you need advanced Excel skills at work?
  • How did you learn your Excel skills?

 

Let me know in the comments below!

Rate my article: excel skills on a resume
Average: 5 (4 votes)
Thank you for voting
Roma Kończak
Roma is a career expert with international work experience and a background in education and humanities. At Zety, she strives to provide the most up-to-date advice for resume and cover letter writing techniques to help readers land their dream jobs.

Similar articles