Period
to 17 November 2017

The following table provides summary statistics for permanent job vacancies advertised in the City of London 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 17 November 2017 with a comparison to the same period in the previous 2 years.

Spreadsheets
Central London > City of London
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 286 340 372
Rank change year-on-year +54 +32 +32
Permanent jobs citing Spreadsheet 41 13 55
As % of all permanent IT jobs advertised in the City of London 0.40% 0.11% 0.32%
As % of the Applications category 3.97% 1.11% 3.14%
Number of salaries quoted 41 12 42
City of London median annual salary £50,000 £45,000 £42,500
Median salary % change year-on-year +11.11% +5.88% -15.00%
10th Percentile £32,500 £30,500 £23,275
90th Percentile £57,500 £59,675 £95,000
Central London median annual salary £50,000 £45,000 £42,500
% change year-on-year +11.11% +5.88% -15.00%

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 advertised in the City of London with a requirement for software application skills.

All Software Application Skills
City of London
Permanent vacancies with a requirement for software application skills 1034 1167 1752
As % of all permanent IT jobs advertised in the City of London 10.11% 9.97% 10.09%
Number of salaries quoted 960 1064 1501
City of London median annual salary £50,000 £46,250 £45,000
Median salary % change year-on-year +8.11% +2.78% +3.75%
10th Percentile £28,000 £26,250 £25,625
90th Percentile £81,275 £76,250 £72,500
Central London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

Spreadsheet
Job Vacancy Trend in the City of London

Job postings citing Spreadsheet as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for Spreadsheet in the City of London

Spreadsheet
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Spreadsheet in the City of London.

Salary trend for Spreadsheet in the City of London

Spreadsheet
Salary Histogram in the City of London

The salary distribution of IT jobs citing Spreadsheet in the City of London over the 6 months to 17 November 2017.

Salary histogram for Spreadsheet in the City of London

For the 6 months to 17 November 2017, IT jobs citing Spreadsheet also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the City of London region with a requirement for Spreadsheet.

1 34 (82.93%) Finance
2 32 (78.05%) Microsoft Excel
3 27 (65.85%) SQL Server
4 23 (56.10%) Microsoft
5 21 (51.22%) Windows
5 21 (51.22%) Agile Software Development
6 20 (48.78%) JIRA
6 20 (48.78%) SDLC
7 18 (43.90%) Linux
7 18 (43.90%) MySQL
8 17 (41.46%) MS Access
8 17 (41.46%) Client/Server
8 17 (41.46%) MS Visio
8 17 (41.46%) Firewall
9 12 (29.27%) Degree
10 10 (24.39%) SQL Server Integration Services
10 10 (24.39%) SQL Server Reporting Services
10 10 (24.39%) CRM
11 8 (19.51%) Business Intelligence
11 8 (19.51%) SQL
11 8 (19.51%) Data Analysis
12 7 (17.07%) Marketing
12 7 (17.07%) Analytics
12 7 (17.07%) Creative Thinking
13 6 (14.63%) QA
13 6 (14.63%) Power BI
13 6 (14.63%) Data Quality
13 6 (14.63%) Data Structures
13 6 (14.63%) Retail
13 6 (14.63%) Data Management

Spreadsheet
Co-occurring IT Skills in the City of London 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 4 (9.76%) IIS
1 4 (9.76%) SharePoint
1 4 (9.76%) Tomcat
Applications
1 32 (78.05%) Microsoft Excel
2 17 (41.46%) MS Visio
Business Applications
1 4 (9.76%) Dynamics CRM
2 1 (2.44%) Primavera
Cloud Services
1 1 (2.44%) Google Analytics
1 1 (2.44%) Google Tag Manager
Communications & Networking
1 17 (41.46%) Firewall
2 4 (9.76%) Internet
2 4 (9.76%) TCP/IP
Database & Business Intelligence
1 27 (65.85%) SQL Server
2 18 (43.90%) MySQL
3 17 (41.46%) MS Access
4 10 (24.39%) SQL Server Integration Services
4 10 (24.39%) SQL Server Reporting Services
5 6 (14.63%) Power BI
5 6 (14.63%) SQL Server Analysis Services
6 1 (2.44%) Big Data
6 1 (2.44%) Relational Database
Development Applications
1 20 (48.78%) JIRA
2 4 (9.76%) Octopus Deploy
2 4 (9.76%) TeamCity
3 1 (2.44%) Selenium
General
1 34 (82.93%) Finance
2 7 (17.07%) Marketing
3 6 (14.63%) Retail
4 1 (2.44%) Telecoms
Job Titles
1 24 (58.54%) Analyst
2 17 (41.46%) Business Analyst
3 9 (21.95%) Software Analyst
4 6 (14.63%) Operations Manager
4 6 (14.63%) Sales Manager
4 6 (14.63%) SQL Analyst
5 5 (12.20%) Applications Manager
6 4 (9.76%) Applications Support
6 4 (9.76%) Applications Support Manager
6 4 (9.76%) Support Manager
7 3 (7.32%) Project Manager
8 2 (4.88%) Data Analyst
8 2 (4.88%) IT Manager
8 2 (4.88%) IT Project Manager
8 2 (4.88%) Junior
8 2 (4.88%) Junior IT Manager
8 2 (4.88%) Junior IT Project Manager
8 2 (4.88%) Junior Project Manager
8 2 (4.88%) Project Officer
8 2 (4.88%) Project Support Officer
Libraries, Frameworks & Software Standards
1 4 (9.76%) .NET
2 1 (2.44%) HTML
2 1 (2.44%) JSON
Miscellaneous
1 17 (41.46%) Client/Server
2 6 (14.63%) Data Structures
2 6 (14.63%) Management Information System
3 2 (4.88%) Foreign Exchange (FX)
4 1 (2.44%) Analytical Skills
4 1 (2.44%) Social Media
Operating Systems
1 21 (51.22%) Windows
2 18 (43.90%) Linux
3 1 (2.44%) Unix
Processes & Methodologies
1 21 (51.22%) Agile Software Development
2 20 (48.78%) SDLC
3 10 (24.39%) CRM
4 8 (19.51%) Business Intelligence
4 8 (19.51%) Data Analysis
5 7 (17.07%) Analytics
5 7 (17.07%) Creative Thinking
6 6 (14.63%) Data Management
6 6 (14.63%) Data Modelling
6 6 (14.63%) Reverse Engineering
7 5 (12.20%) Change Management
8 4 (9.76%) ITIL
8 4 (9.76%) Problem Management
8 4 (9.76%) Service Delivery
8 4 (9.76%) Service Management
9 3 (7.32%) Business Development
9 3 (7.32%) Gantt Chart
9 3 (7.32%) Presales
9 3 (7.32%) Waterfall
10 2 (4.88%) Mentoring
Programming Languages
1 8 (19.51%) SQL
2 6 (14.63%) VB
2 6 (14.63%) VBA
3 4 (9.76%) C#
3 4 (9.76%) Java
3 4 (9.76%) PowerShell
4 1 (2.44%) Go
4 1 (2.44%) JavaScript
4 1 (2.44%) Python
4 1 (2.44%) R
Qualifications
1 12 (29.27%) Degree
2 2 (4.88%) DV Cleared
2 2 (4.88%) Security Cleared
3 1 (2.44%) PRINCE2 Certification
Quality Assurance & Compliance
1 6 (14.63%) Data Quality
1 6 (14.63%) QA
2 3 (7.32%) PMO
Vendors
1 23 (56.10%) Microsoft
2 6 (14.63%) Salesforce.com
2 6 (14.63%) Siebel
2 6 (14.63%) Tableau
3 2 (4.88%) Capita
3 2 (4.88%) CheckPoint
4 1 (2.44%) Google