Excel is every in business.

Very few people can get through a day at work without using Excel, whether it’s for something simple like storing data or something more complex like creating a financial forecast.

As one of the UK’s leading providers of Excel training,  we recently surveyed 1,000 office workers in the UK to understand more.

For full details of the study, see – New Excel Facts & Statistics For 2022 – this includes full details of our research methods.

In this article, we are looking at answers to the first question.

KEY TAKEAWAYS:

  • More than 4 in 5 (83%) people rate their Excel skills as intermediate or advanced.
  • More than 1 in 10 (11%) people rate their Excel skills as beginner.
  • Older workers (>54 years old) have the lowest level of Excel skills. 17% rate themselves as beginner-level.
  • Workers 35 – 44 years old have the highest level of Excel skills. Just 7% rate themselves as beginner-level.

Question 1: “How Good Are Your Excel Skills?”

 

Chart showing people's self-reported Excel skills

 

More than half (57%) of people put their Excel skills at intermediate.

Another 27% of people rate themselves as advanced, meaning that 83% of people think they are either intermediate or advanced Excel users.

At the extremes of the spectrum, just 6% of people rate themselves as experts and 11% of people think that they are beginners.

Given how widely Excel is used, it is a shame that over 1 in 10 people feel that they only have beginners Excel skills.

Looking at the data in detail it was encouraging to note that men and women reported the same levels of Excel skills.

 

Excel Skills Split By Age

Looking at the data by age group we did find some interesting findings.

Older workers (>54 years old) have lower average levels of Excel skills with just 2% rating themselves as expert Excel users and 17% rating themselves as beginners.

By contrast, workers in the 35-44 years old range had the highest average level of Excel skills with just 7 % of them rating their Excel skills as beginner.

Categorising Levels Of Excel Skills

The following skills represent the levels of Excel skills.

Beginner:

    1. Carry out simple data entry.
    2. Format text and numbers as desired.
    3. Create simple charts
    4. Create absolute and relative cell references

Intermediate:

    1. Use Quick Analysis Tools (QATs) to visualise data
    2. Use filter and sort when working with data tables
    3. Use conditional formatting
    4. Use basic formulas and functions

Advanced:

    1. Use logical functions like =IF
    2. Use lookup functions and data validation
    3. Use Pivot Tables
    4. Use controls

Expert:

    1. Record macros
    2. Use VBA to control Excel

To see analysis of the other questions in this Excel survey see:

How Many People Have Ever Received Formal Excel Training?

How Much Do People Use Excel At Work?