Period
to 19 January 2020

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Microsoft Excel skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Microsoft Excel over the 6 months to 19 January 2020 with a comparison to the same period in the previous 2 years.

Microsoft Excel
Central London > City of London
6 months to
19 Jan 2020
Same period 2019 Same period 2018
Rank 83 83 85
Rank change year-on-year 0 +2 -6
Permanent jobs citing Microsoft Excel 311 365 375
As % of all permanent IT jobs advertised in the City of London 3.43% 3.57% 3.58%
As % of the Applications category 38.44% 40.38% 39.47%
Number of salaries quoted 280 331 345
City of London median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% +2.15%
10th Percentile £26,250 £29,000 £31,750
90th Percentile £77,500 £76,250 £72,500
Central London median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +3.26%

Microsoft Excel 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 809 904 950
As % of all permanent IT jobs advertised in the City of London 8.93% 8.84% 9.06%
Number of salaries quoted 713 797 869
City of London median annual salary £47,500 £46,000 £47,500
Median salary % change year-on-year +3.26% -3.16% +5.56%
10th Percentile £25,500 £26,250 £27,500
90th Percentile £77,500 £80,000 £80,000
Central London median annual salary £45,000 £45,500 £47,500
% change year-on-year -1.10% -4.21% +5.56%

Microsoft Excel
Job Vacancy Trend in the City of London

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

Job vacancy trend for Microsoft Excel in the City of London

Microsoft Excel
Salary Trend in the City of London

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

Salary trend for Microsoft Excel in the City of London

Microsoft Excel
Salary Histogram in the City of London

The salary distribution of IT jobs citing Microsoft Excel in the City of London over the 6 months to 19 January 2020.

Salary histogram for Microsoft Excel in the City of London

For the 6 months to 19 January 2020, IT jobs citing Microsoft Excel 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 across the City of London region with a requirement for Microsoft Excel.

1 159 (51.13%) Microsoft
2 120 (38.59%) Finance
3 105 (33.76%) SQL
4 88 (28.30%) Microsoft Office
5 85 (27.33%) Microsoft PowerPoint
6 71 (22.83%) VBA
7 61 (19.61%) Business Intelligence
8 60 (19.29%) SQL Server
9 59 (18.97%) Windows
10 58 (18.65%) Degree
11 49 (15.76%) Banking
12 47 (15.11%) Agile Software Development
13 46 (14.79%) MS Visio
14 43 (13.83%) Analytical Skills
15 41 (13.18%) Office 365
16 40 (12.86%) Analytics
17 38 (12.22%) Active Directory
18 35 (11.25%) ETL
19 33 (10.61%) Open Source
19 33 (10.61%) Power Platform
20 32 (10.29%) Power BI
21 31 (9.97%) Problem-Solving
21 31 (9.97%) Visualisation
21 31 (9.97%) Python
22 30 (9.65%) ITIL
22 30 (9.65%) Project Management
22 30 (9.65%) SQL Server Integration Services
22 30 (9.65%) Data Analysis
23 29 (9.32%) Business Development
23 29 (9.32%) C++

Microsoft Excel
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 15 (4.82%) SharePoint
2 10 (3.22%) MS Exchange
3 9 (2.89%) SAS
4 8 (2.57%) Confluence
5 4 (1.29%) Elasticsearch
6 2 (0.64%) CMS
7 1 (0.32%) Exchange Server 2010
7 1 (0.32%) IIS
7 1 (0.32%) MS Project Server
7 1 (0.32%) Oracle Workflow
7 1 (0.32%) Sitecore CMS
7 1 (0.32%) Umbraco
7 1 (0.32%) WordPress
Applications
1 88 (28.30%) Microsoft Office
2 85 (27.33%) Microsoft PowerPoint
3 46 (14.79%) MS Visio
4 15 (4.82%) AutoCAD
5 14 (4.50%) Microsoft Project
6 6 (1.93%) Spreadsheet
7 4 (1.29%) SPSS
Business Applications
1 11 (3.54%) Remedy ITSM
2 4 (1.29%) Dynamics CRM
2 4 (1.29%) FastStats
3 3 (0.96%) Carpe Diem
4 2 (0.64%) Magento
4 2 (0.64%) RiskWrite
5 1 (0.32%) Elite 3E
5 1 (0.32%) iTrent
5 1 (0.32%) Payment Gateway
5 1 (0.32%) Salesforce.com CRM
Cloud Services
1 41 (13.18%) Office 365
2 33 (10.61%) Power Platform
3 19 (6.11%) Azure
4 3 (0.96%) Google Analytics
5 2 (0.64%) SaaS
6 1 (0.32%) AdWords
6 1 (0.32%) BrowserStack
6 1 (0.32%) Google Sheets
6 1 (0.32%) Google Tag Manager
6 1 (0.32%) Microsoft Flow
Communications & Networking
1 18 (5.79%) Wireless
2 16 (5.14%) VoIP
3 11 (3.54%) TCP/IP
4 10 (3.22%) Firewall
5 9 (2.89%) BGP
5 9 (2.89%) Ethernet
5 9 (2.89%) MPLS
5 9 (2.89%) Network Security
5 9 (2.89%) OSPF
5 9 (2.89%) VLAN
5 9 (2.89%) Wi-Fi
6 8 (2.57%) GPON
6 8 (2.57%) LAN
6 8 (2.57%) Peer-to-Peer Networking
6 8 (2.57%) VPN
6 8 (2.57%) WAN
7 6 (1.93%) Internet
8 2 (0.64%) DNS
9 1 (0.32%) DHCP
9 1 (0.32%) Intranet
Database & Business Intelligence
1 60 (19.29%) SQL Server
2 32 (10.29%) Power BI
3 30 (9.65%) SQL Server Integration Services
4 26 (8.36%) SQL Server Reporting Services
5 24 (7.72%) Data Warehouse
6 18 (5.79%) SQL Server Analysis Services
7 14 (4.50%) MS Access
8 13 (4.18%) QlikView
9 10 (3.22%) SQL Server 2016
10 9 (2.89%) Big Data
10 9 (2.89%) OLAP
10 9 (2.89%) OLAP Cube
11 7 (2.25%) Relational Database
12 6 (1.93%) PostgreSQL
13 5 (1.61%) Data Lake
13 5 (1.61%) SQL Server 2008
14 4 (1.29%) Azure SQL Database
14 4 (1.29%) Crystal Reports
14 4 (1.29%) Oracle Database
14 4 (1.29%) Qlik Sense
Development Applications
1 18 (5.79%) JIRA
2 9 (2.89%) Visual Studio
3 8 (2.57%) Team Foundation Server
4 5 (1.61%) Subversion
5 4 (1.29%) Jenkins
5 4 (1.29%) WinDbg
6 3 (0.96%) GCC
7 2 (0.64%) Eclipse
7 2 (0.64%) SQL Server Management Studio (SSMS)
7 2 (0.64%) Visual Studio Tools for Office
8 1 (0.32%) Cucumber
8 1 (0.32%) HP UFT
8 1 (0.32%) Selenium
8 1 (0.32%) TestDirector
General
1 120 (38.59%) Finance
2 49 (15.76%) Banking
3 25 (8.04%) Marketing
4 17 (5.47%) Law
5 16 (5.14%) Advertising
6 9 (2.89%) Front Office
6 9 (2.89%) Legal
7 4 (1.29%) Financial Institution
8 3 (0.96%) Back Office
8 3 (0.96%) Public Sector
9 2 (0.64%) Publishing
9 2 (0.64%) Retail
10 1 (0.32%) Automotive
10 1 (0.32%) Billing
10 1 (0.32%) Games
10 1 (0.32%) Investment Banking
10 1 (0.32%) Retail Banking
10 1 (0.32%) Retail Finance
10 1 (0.32%) Telecoms
Job Titles
1 131 (42.12%) Analyst
2 69 (22.19%) Developer
3 57 (18.33%) Support Analyst
4 37 (11.90%) IT Support
5 36 (11.58%) IT Analyst
6 34 (10.93%) IT Support Analyst
7 30 (9.65%) Data Analyst
8 28 (9.00%) C++ Developer
9 23 (7.40%) Service Analyst
10 20 (6.43%) Active Directory Analyst
10 20 (6.43%) Active Directory Support
10 20 (6.43%) Active Directory Support Analyst
11 16 (5.14%) Service Desk Analyst
12 15 (4.82%) Service Desk Support
13 14 (4.50%) Applications Support
13 14 (4.50%) Service Desk Support Analyst
14 13 (4.18%) Applications Support Analyst
14 13 (4.18%) Business Intelligence Analyst
14 13 (4.18%) SQL Developer
14 13 (4.18%) Systems Developer
Libraries, Frameworks & Software Standards
1 28 (9.00%) Boost C++ Libraries
1 28 (9.00%) Qt
2 20 (6.43%) .NET
3 13 (4.18%) XML
4 11 (3.54%) ASP.NET
5 8 (2.57%) HTML
6 7 (2.25%) CSS
7 4 (1.29%) SailPoint
8 3 (0.96%) JSON
9 2 (0.64%) .NET Framework
9 2 (0.64%) AngularJS
9 2 (0.64%) Backbone.js
9 2 (0.64%) Ember.js
9 2 (0.64%) FIX Protocol
9 2 (0.64%) jQuery
9 2 (0.64%) MDX
9 2 (0.64%) Oracle Fusion
9 2 (0.64%) React
9 2 (0.64%) Spring
9 2 (0.64%) Web Services
Miscellaneous
1 43 (13.83%) Analytical Skills
2 24 (7.72%) Management Information System
3 12 (3.86%) Self-Motivation
4 9 (2.89%) iPhone
5 8 (2.57%) Derivative
6 7 (2.25%) Equity Derivative
6 7 (2.25%) Reinsurance
7 6 (1.93%) Analytical Mindset
8 5 (1.61%) Data Structures
9 4 (1.29%) Blackberry
9 4 (1.29%) Fat Client
9 4 (1.29%) Greenfield Project
9 4 (1.29%) Handset
9 4 (1.29%) Thin Client
9 4 (1.29%) Video Conferencing
10 3 (0.96%) Data Centre
10 3 (0.96%) Fixed Income
10 3 (0.96%) User Experience
11 2 (0.64%) Credit Risk
11 2 (0.64%) Market Risk
Operating Systems
1 59 (18.97%) Windows
2 28 (9.00%) Windows Server
3 23 (7.40%) Android
3 23 (7.40%) Windows 7
4 22 (7.07%) Windows 10
5 11 (3.54%) Apple iOS
6 9 (2.89%) Windows Server 2012
7 8 (2.57%) Windows Vista
8 6 (1.93%) Linux
9 5 (1.61%) Unix
10 1 (0.32%) Mac OS
10 1 (0.32%) Windows 8
Processes & Methodologies
1 61 (19.61%) Business Intelligence
2 47 (15.11%) Agile Software Development
3 40 (12.86%) Analytics
4 35 (11.25%) ETL
5 33 (10.61%) Open Source
6 31 (9.97%) Problem-Solving
6 31 (9.97%) Visualisation
7 30 (9.65%) Data Analysis
7 30 (9.65%) ITIL
7 30 (9.65%) Project Management
8 29 (9.32%) Business Development
9 27 (8.68%) Fintech
10 22 (7.07%) ITIL V3
11 21 (6.75%) Data Modelling
12 20 (6.43%) Line Management
12 20 (6.43%) PRINCE2
13 18 (5.79%) Data Management
13 18 (5.79%) Scrum
14 17 (5.47%) Business Analysis
15 16 (5.14%) Waterfall
Programming Languages
1 105 (33.76%) SQL
2 71 (22.83%) VBA
3 31 (9.97%) Python
4 29 (9.32%) C++
5 26 (8.36%) C#
6 25 (8.04%) T-SQL
6 25 (8.04%) VB
7 16 (5.14%) R
8 8 (2.57%) PL/SQL
9 6 (1.93%) Java
9 6 (1.93%) JavaScript
9 6 (1.93%) PowerShell
10 5 (1.61%) VB.NET
10 5 (1.61%) VBScript
11 3 (0.96%) C
11 3 (0.96%) Shell Script
12 2 (0.64%) VB6
13 1 (0.32%) Bash Shell
13 1 (0.32%) Ruby
13 1 (0.32%) XAML
Qualifications
1 58 (18.65%) Degree
2 18 (5.79%) Microsoft Certification
3 15 (4.82%) MCSA
4 9 (2.89%) CCNP
4 9 (2.89%) Cisco Certification
5 8 (2.57%) CCDA
5 8 (2.57%) CCDP
5 8 (2.57%) JNCIA
6 5 (1.61%) CBAP
7 4 (1.29%) PMP
8 3 (0.96%) CISSP
8 3 (0.96%) Master's Degree
8 3 (0.96%) PMI Certification
9 2 (0.64%) CISA
9 2 (0.64%) Computer Science Degree
9 2 (0.64%) CRISC
9 2 (0.64%) MCP
9 2 (0.64%) MCSE
9 2 (0.64%) Postgraduate
9 2 (0.64%) Six Sigma Yellow Belt
Quality Assurance & Compliance
1 22 (7.07%) SLA
2 19 (6.11%) Data Quality
3 12 (3.86%) QA
4 6 (1.93%) Sarbanes-Oxley
5 5 (1.61%) GDPR
6 3 (0.96%) PMO
7 2 (0.64%) Basel III
7 2 (0.64%) COBIT
7 2 (0.64%) COSO
7 2 (0.64%) MiFID
7 2 (0.64%) NIST
7 2 (0.64%) Solvency II
System Software
1 38 (12.22%) Active Directory
2 8 (2.57%) Hyper-V
2 8 (2.57%) VMware Infrastructure
3 1 (0.32%) Cronacle
3 1 (0.32%) Virtual Machines
Systems Management
1 12 (3.86%) SCCM
2 4 (1.29%) Perfmon
3 1 (0.32%) QRadar
Vendors
1 159 (51.13%) Microsoft
2 22 (7.07%) Oracle
2 22 (7.07%) Tableau
3 15 (4.82%) Autodesk
3 15 (4.82%) HP
4 14 (4.50%) ShoreTel
5 12 (3.86%) Cisco
6 11 (3.54%) Remedy
6 11 (3.54%) ServiceNow
7 9 (2.89%) Cognos
7 9 (2.89%) Juniper
8 8 (2.57%) Alteryx
8 8 (2.57%) Huawei
8 8 (2.57%) VMware
9 7 (2.25%) Bloomberg
9 7 (2.25%) Reuters
9 7 (2.25%) SAP
10 5 (1.61%) Apple
10 5 (1.61%) Citrix
11 4 (1.29%) Salesforce.com