Period
to 30 September 2020

The following table provides summary statistics for permanent job vacancies with a requirement for Spreadsheet skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Spreadsheet over the 6 months to 30 September 2020 with a comparison to the same period in the previous 2 years.

Spreadsheets
UK
6 months to
30 Sep 2020
Same period 2019 Same period 2018
Rank 598 791 842
Rank change year-on-year +193 +51 +6
Permanent jobs citing Spreadsheet 75 302 339
As % of all permanent jobs advertised in the UK 0.16% 0.22% 0.21%
As % of the Applications category 2.56% 2.65% 2.36%
Number of salaries quoted 66 217 258
Median annual salary £52,750 £42,500 £44,000
Median salary % change year-on-year +24.12% -3.41% +10.00%
10th Percentile £21,875 £21,800 £23,500
90th Percentile £117,500 £75,000 £75,000
UK excluding London median annual salary £34,370 £38,000 £35,000
% change year-on-year -9.55% +8.57% +1.15%

Spreadsheet is in the Software Applications category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for software application skills.

All Software Application Skills
UK
Permanent vacancies with a requirement for software application skills 2,935 11,388 14,390
As % of all permanent IT jobs advertised in the UK 6.09% 8.17% 8.76%
Number of salaries quoted 2,314 8,912 11,175
Median annual salary £45,000 £37,500 £38,800
Median salary % change year-on-year +20.00% -3.35% +3.47%
10th Percentile £26,000 £22,306 £21,540
90th Percentile £77,500 £67,500 £67,500
UK excluding London median annual salary £40,000 £33,500 £35,000
% change year-on-year +19.40% -4.29% +2.94%

Spreadsheet
Job Vacancy Trend

Job postings citing Spreadsheet as a proportion of all IT jobs advertised.

Job vacancy trend for Spreadsheet in the UK

Spreadsheet
Salary Trend

3-month moving average salary quoted in jobs citing Spreadsheet.

Salary trend for Spreadsheet in the UK

Spreadsheet
Salary Histogram

Salary distribution for jobs citing Spreadsheet over the 6 months to 30 September 2020.

Salary histogram for Spreadsheet in the UK

Spreadsheet
Top 16 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Spreadsheet within the UK over the 6 months to 30 September 2020. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +168 65 £68,000 +60.00% 23
London +212 36 £85,000 +47.83% 9
UK excluding London +167 35 £34,370 -9.55% 18
Midlands +132 15 £27,500 -8.33% 3
West Midlands +109 14 £27,500 -30.38% 3
Work from Home +48 6 £40,000 -26.61% 1
North of England +131 5 £40,000 +6.67% 5
South West +109 4 £41,135 +123.63% 2
North West +82 4 £54,000 +47.95% 2
South East +170 3 - - 4
Isle of Man - 3 £17,000 -
East of England +110 2 - -
Scotland +104 2 - - 3
Yorkshire +125 1 £36,094 -5.02% 1
East Midlands +90 1 £47,500 +72.73%
Wales +48 1 £32,646 +8.82% 1

For the 6 months to 30 September 2020, IT jobs citing Spreadsheet also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for Spreadsheet.

1 39 (52.00%) Microsoft Excel
2 23 (30.67%) Finance
3 21 (28.00%) Microsoft
3 21 (28.00%) VBA
4 20 (26.67%) Agile Software Development
5 18 (24.00%) SQL
6 14 (18.67%) Test Automation
7 13 (17.33%) DevOps
7 13 (17.33%) ETL
7 13 (17.33%) Degree
8 12 (16.00%) RESTful
9 11 (14.67%) QA
9 11 (14.67%) Microservices
9 11 (14.67%) Stakeholder Management
10 10 (13.33%) Continuous Delivery
10 10 (13.33%) Financial Modelling
10 10 (13.33%) Architectural Design
11 9 (12.00%) Analytics
11 9 (12.00%) Analytical Skills
11 9 (12.00%) Project Management
11 9 (12.00%) Management Information System
12 8 (10.67%) Front Office
12 8 (10.67%) Foreign Exchange (FX)
12 8 (10.67%) Java
12 8 (10.67%) .NET
12 8 (10.67%) SAP
12 8 (10.67%) Fixed Income
12 8 (10.67%) Google
12 8 (10.67%) Banking
12 8 (10.67%) Fintech

Spreadsheet
Co-occurring IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 3 (4.00%) Oracle Workflow
2 1 (1.33%) Confluence
Applications
1 39 (52.00%) Microsoft Excel
2 7 (9.33%) Microsoft Office
3 3 (4.00%) Microsoft PowerPoint
3 3 (4.00%) MS Visio
4 2 (2.67%) Quantrix
5 1 (1.33%) Microsoft Project
Business Applications
1 3 (4.00%) Oracle ERP
2 2 (2.67%) SAP MDG
2 2 (2.67%) SAP MDM
3 1 (1.33%) Dynamics CRM
Cloud Services
1 4 (5.33%) AWS
1 4 (5.33%) Azure
1 4 (5.33%) GCP
2 3 (4.00%) Google Analytics
2 3 (4.00%) PaaS
3 2 (2.67%) Power Platform
3 2 (2.67%) SaaS
4 1 (1.33%) G Suite
4 1 (1.33%) Slack
Database & Business Intelligence
1 5 (6.67%) SQL Server Integration Services
2 4 (5.33%) GIS
2 4 (5.33%) SQL Server Analysis Services
3 3 (4.00%) Relational Database
3 3 (4.00%) SQL Server
4 2 (2.67%) BODI
4 2 (2.67%) BusinessObjects
4 2 (2.67%) DataStage
4 2 (2.67%) QlikView
4 2 (2.67%) SAP Data Services
5 1 (1.33%) MySQL
5 1 (1.33%) Power BI
5 1 (1.33%) SQL Server Reporting Services
Development Applications
1 5 (6.67%) RStudio
2 4 (5.33%) Git (software)
2 4 (5.33%) JIRA
2 4 (5.33%) Subversion
3 2 (2.67%) LSMW
3 2 (2.67%) Visual Studio
4 1 (1.33%) ReSharper
4 1 (1.33%) SQL Server Management Studio (SSMS)
General
1 23 (30.67%) Finance
2 8 (10.67%) Banking
2 8 (10.67%) Front Office
3 5 (6.67%) Telecoms
4 1 (1.33%) Aerospace
4 1 (1.33%) Avionics
4 1 (1.33%) Back Office
4 1 (1.33%) Billing
4 1 (1.33%) French Language
4 1 (1.33%) German Language
4 1 (1.33%) Italian Language
4 1 (1.33%) Marketing
4 1 (1.33%) Military
4 1 (1.33%) Pharmaceutical
4 1 (1.33%) Public Sector
4 1 (1.33%) Publishing
4 1 (1.33%) Retail
4 1 (1.33%) Welsh Language
Job Titles
1 29 (38.67%) Developer
2 14 (18.67%) Analyst
3 10 (13.33%) DevOps Developer
3 10 (13.33%) Pricing Developer
4 7 (9.33%) Consultant
4 7 (9.33%) Electronic Trading Developer
4 7 (9.33%) Technical Consultant
5 6 (8.00%) Data Analyst
5 6 (8.00%) Electronic Trading Java Developer
5 6 (8.00%) Java Developer
5 6 (8.00%) Java Developer - Fintech
5 6 (8.00%) Java Pricing Developer
5 6 (8.00%) MATLAB Developer
5 6 (8.00%) RAD Developer
6 5 (6.67%) C++ Developer
6 5 (6.67%) Supply Chain Director
7 4 (5.33%) C++ Quantitative Developer
7 4 (5.33%) Graduate Consultant
7 4 (5.33%) Graduate Technical Consultant
7 4 (5.33%) Quantitative Developer
Libraries, Frameworks & Software Standards
1 12 (16.00%) RESTful
2 8 (10.67%) .NET
3 7 (9.33%) REST
3 7 (9.33%) Web Services
4 4 (5.33%) AngularJS
4 4 (5.33%) HTML
4 4 (5.33%) HTML5
4 4 (5.33%) Node.js
5 3 (4.00%) XML
5 3 (4.00%) XSL
6 2 (2.67%) BAPI
6 2 (2.67%) IDoc
7 1 (1.33%) ASP.NET
7 1 (1.33%) React
Miscellaneous
1 9 (12.00%) Analytical Skills
1 9 (12.00%) Management Information System
2 8 (10.67%) Fixed Income
2 8 (10.67%) Foreign Exchange (FX)
3 4 (5.33%) Self-Motivation
3 4 (5.33%) Social Media
4 2 (2.67%) Data Structures
4 2 (2.67%) NHS
4 2 (2.67%) NPfIT
4 2 (2.67%) SCADA
5 1 (1.33%) Equities
5 1 (1.33%) Hedge funds
5 1 (1.33%) Mobile App
5 1 (1.33%) PMI
5 1 (1.33%) Wiki
Operating Systems
1 2 (2.67%) Linux
2 1 (1.33%) Unix
Processes & Methodologies
1 20 (26.67%) Agile Software Development
2 14 (18.67%) Test Automation
3 13 (17.33%) DevOps
3 13 (17.33%) ETL
4 11 (14.67%) Microservices
4 11 (14.67%) Stakeholder Management
5 10 (13.33%) Architectural Design
5 10 (13.33%) Continuous Delivery
5 10 (13.33%) Financial Modelling
6 9 (12.00%) Analytics
6 9 (12.00%) Project Management
7 8 (10.67%) Decision-Making
7 8 (10.67%) Fintech
8 7 (9.33%) Electronic Trading
9 6 (8.00%) Logistics
9 6 (8.00%) Migration
9 6 (8.00%) RAD
9 6 (8.00%) Supply Chain Management
9 6 (8.00%) Workflow
10 5 (6.67%) Data Analysis
Programming Languages
1 21 (28.00%) VBA
2 18 (24.00%) SQL
3 8 (10.67%) Java
4 7 (9.33%) MATLAB
5 6 (8.00%) Python
5 6 (8.00%) R
6 5 (6.67%) C++
7 2 (2.67%) ABAP
7 2 (2.67%) C#
8 1 (1.33%) C
8 1 (1.33%) JavaScript
8 1 (1.33%) T-SQL
8 1 (1.33%) VB
Qualifications
1 13 (17.33%) Degree
2 3 (4.00%) Oracle Certification
3 2 (2.67%) DBS Check
3 2 (2.67%) HNC
3 2 (2.67%) SC Cleared
3 2 (2.67%) Security Cleared
4 1 (1.33%) APMP
4 1 (1.33%) ECDL
4 1 (1.33%) MAPM
4 1 (1.33%) Master's Degree
4 1 (1.33%) PMI Certification
Quality Assurance & Compliance
1 11 (14.67%) QA
2 3 (4.00%) Data Quality
3 1 (1.33%) PMBOK
3 1 (1.33%) PMO
System Software
1 1 (1.33%) NFS
Vendors
1 21 (28.00%) Microsoft
2 8 (10.67%) Google
2 8 (10.67%) SAP
3 5 (6.67%) Tableau
4 4 (5.33%) Salesforce.com
5 3 (4.00%) Oracle
6 2 (2.67%) Atlassian
7 1 (1.33%) Citrix
7 1 (1.33%) Progress
7 1 (1.33%) Serena
7 1 (1.33%) Zoho