Period
to 19 October 2018

The following table provides summary statistics for permanent job vacancies advertised in Hertfordshire 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 October 2018 with a comparison to the same period in the previous 2 years.

Microsoft Excel
East of England > Hertfordshire
6 months to
19 Oct 2018
Same period 2017 Same period 2016
Rank 66 114 61
Rank change year-on-year +48 -53 -12
Permanent jobs citing Microsoft Excel 166 105 197
As % of all permanent IT jobs advertised in Hertfordshire 4.11% 2.50% 4.46%
As % of the Applications category 37.56% 24.53% 37.38%
Number of salaries quoted 119 87 134
Hertfordshire median annual salary £42,500 £32,500 £37,500
Median salary % change year-on-year +30.77% -13.33% +20.00%
10th Percentile £21,500 £21,250 £24,000
90th Percentile £65,000 £53,750 £56,000
East of England median annual salary £40,000 £35,000 £35,000
% change year-on-year +14.29% - +9.38%

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 Hertfordshire with a requirement for software application skills.

All Software Application Skills
Hertfordshire
Permanent vacancies with a requirement for software application skills 442 428 527
As % of all permanent IT jobs advertised in Hertfordshire 10.94% 10.18% 11.93%
Number of salaries quoted 287 345 424
Hertfordshire median annual salary £35,000 £30,000 £33,250
Median salary % change year-on-year +16.67% -9.77% -5.00%
10th Percentile £22,000 £21,250 £19,575
90th Percentile £62,500 £52,500 £60,950
East of England median annual salary £35,000 £35,000 £35,000

Microsoft Excel
Job Vacancy Trend in Hertfordshire

Job postings citing Microsoft Excel as a percentage of all IT jobs advertised in Hertfordshire.

Job vacancy trend for Microsoft Excel in Hertfordshire

Microsoft Excel
Salary Trend in Hertfordshire

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

Salary trend for Microsoft Excel in Hertfordshire

Microsoft Excel
Salary Histogram in Hertfordshire

The salary distribution of IT jobs citing Microsoft Excel in Hertfordshire over the 6 months to 19 October 2018.

Salary histogram for Microsoft Excel in Hertfordshire

Microsoft Excel
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Microsoft Excel within the Hertfordshire region over the 6 months to 19 October 2018. 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
Welwyn Garden City +18 52 £41,250 +41.03% 1
Watford +31 49 £54,500 +75.95% 2
Hatfield +2 13 £40,000 +23.08% 3
Hoddesdon +3 9 £22,500 -11.76% 1
St Albans +3 7 £25,000 -
Broxbourne -8 5 £23,000 -40.26%
Stevenage +9 4 £52,500 -4.55% 2
Rickmansworth -9 3 £50,000 +31.58%
Potters Bar - 2 £47,000 - 1
Hitchin +3 1 £62,500 +131.48% 1
Sawbridgeworth - 1 £35,000 -
Microsoft Excel
East of England

For the 6 months to 19 October 2018, 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 Hertfordshire region with a requirement for Microsoft Excel.

1 102 (61.45%) Microsoft
2 70 (42.17%) Analytical Skills
3 68 (40.96%) SQL
4 51 (30.72%) VBA
5 47 (28.31%) T-SQL
6 46 (27.71%) Microsoft PowerPoint
7 45 (27.11%) SQL Server Reporting Services
8 42 (25.30%) Agile Software Development
8 42 (25.30%) Finance
9 41 (24.70%) Microsoft Office
10 36 (21.69%) Business Intelligence
11 35 (21.08%) SQL Server
11 35 (21.08%) Problem-Solving
12 33 (19.88%) Project Management
13 30 (18.07%) Data Warehouse
13 30 (18.07%) SQL Server Integration Services
13 30 (18.07%) Degree
13 30 (18.07%) SQL Server Analysis Services
14 29 (17.47%) ETL
14 29 (17.47%) Migration
15 26 (15.66%) C#
15 26 (15.66%) Microsoft Project
15 26 (15.66%) JIRA
16 25 (15.06%) Visualisation
17 23 (13.86%) Data Migration
17 23 (13.86%) Retail
17 23 (13.86%) PRINCE2
17 23 (13.86%) Decision-Making
18 20 (12.05%) HTML
18 20 (12.05%) Business Analysis

Microsoft Excel
Co-occurring IT Skills in Hertfordshire 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 9 (5.42%) SharePoint
2 7 (4.22%) SAS
3 2 (1.20%) Skype for Business
4 1 (0.60%) MS Exchange
4 1 (0.60%) SharePoint 2013
Applications
1 46 (27.71%) Microsoft PowerPoint
2 41 (24.70%) Microsoft Office
3 26 (15.66%) Microsoft Project
4 10 (6.02%) Spreadsheet
5 5 (3.01%) MS Visio
6 1 (0.60%) SPSS
Business Applications
1 13 (7.83%) Cognos Business Intelligence
1 13 (7.83%) Cognos TM1
2 2 (1.20%) Dynamics CRM
3 1 (0.60%) SAP ERP
3 1 (0.60%) SAP HR
3 1 (0.60%) Unit4 Business World
Cloud Services
1 1 (0.60%) G Suite
1 1 (0.60%) Google Analytics
1 1 (0.60%) Google Cloud Platform
1 1 (0.60%) Microsoft Azure
1 1 (0.60%) Office 365
1 1 (0.60%) SaaS
Communications & Networking
1 3 (1.81%) DHCP
1 3 (1.81%) DNS
1 3 (1.81%) SMS
1 3 (1.81%) VoIP
1 3 (1.81%) Wireless
2 2 (1.20%) Firewall
2 2 (1.20%) Internet
2 2 (1.20%) LAN
2 2 (1.20%) Network Security
2 2 (1.20%) Skype
2 2 (1.20%) WAN
3 1 (0.60%) DSL
3 1 (0.60%) Intranet
3 1 (0.60%) VPN
Database & Business Intelligence
1 45 (27.11%) SQL Server Reporting Services
2 35 (21.08%) SQL Server
3 30 (18.07%) Data Warehouse
3 30 (18.07%) SQL Server Analysis Services
3 30 (18.07%) SQL Server Integration Services
4 20 (12.05%) Power BI
5 17 (10.24%) MS Access
6 15 (9.04%) MongoDB
7 14 (8.43%) Crystal Reports
7 14 (8.43%) Data Mining
8 13 (7.83%) Microsoft Analysis Services
9 12 (7.23%) NoSQL
9 12 (7.23%) OLAP
10 4 (2.41%) Oracle Database
11 2 (1.20%) BigQuery
11 2 (1.20%) MySQL
12 1 (0.60%) QlikView
12 1 (0.60%) Relational Database
12 1 (0.60%) SQL Server 2008
12 1 (0.60%) Sybase ASE
Development Applications
1 26 (15.66%) JIRA
General
1 42 (25.30%) Finance
2 23 (13.86%) Retail
3 13 (7.83%) Marketing
4 3 (1.81%) Back Office
5 1 (0.60%) Financial Institution
5 1 (0.60%) Legal
5 1 (0.60%) Pharmaceutical
5 1 (0.60%) Social Science
Job Titles
1 49 (29.52%) Analyst
2 34 (20.48%) Developer
3 22 (13.25%) Project Manager
4 21 (12.65%) Administrator
4 21 (12.65%) Data Analyst
5 16 (9.64%) Scrum Master
5 16 (9.64%) ScrumMaster Project Manager
6 15 (9.04%) Business Intelligence Developer
7 10 (6.02%) Software Developer
8 8 (4.82%) Help Desk Administrator
8 8 (4.82%) Senior Business Intelligence Developer
8 8 (4.82%) Senior Developer
8 8 (4.82%) Technical Administrator
9 7 (4.22%) Delivery Manager
9 7 (4.22%) Product Analyst
10 6 (3.61%) RACF Administrator
10 6 (3.61%) Systems Analyst
10 6 (3.61%) Transformation Analyst
11 5 (3.01%) Coordinator
11 5 (3.01%) Graduate
Libraries, Frameworks & Software Standards
1 20 (12.05%) HTML
2 16 (9.64%) .NET
2 16 (9.64%) CSS
3 14 (8.43%) .NET Framework
3 14 (8.43%) ADO.NET
3 14 (8.43%) Entity Framework
4 6 (3.61%) ISPF
5 3 (1.81%) Flash
6 2 (1.20%) HTML5
6 2 (1.20%) jQuery
6 2 (1.20%) JSON
7 1 (0.60%) XML
Miscellaneous
1 70 (42.17%) Analytical Skills
2 15 (9.04%) Computer Science
3 6 (3.61%) Mainframe
3 6 (3.61%) Management Information System
3 6 (3.61%) Security Operations Centre
4 3 (1.81%) Self-Motivation
5 2 (1.20%) CMDB
5 2 (1.20%) Data Centre
5 2 (1.20%) Handset
5 2 (1.20%) Video Conferencing
6 1 (0.60%) Algorithms
6 1 (0.60%) FMCG
6 1 (0.60%) Pricing Data
6 1 (0.60%) User Experience
Operating Systems
1 5 (3.01%) Windows
2 3 (1.81%) Linux
3 2 (1.20%) Ubuntu
3 2 (1.20%) Windows 7
3 2 (1.20%) Windows Server
3 2 (1.20%) Windows Server 2008
3 2 (1.20%) Windows Server 2012
4 1 (0.60%) Mac OS X
4 1 (0.60%) Windows 10
Processes & Methodologies
1 42 (25.30%) Agile Software Development
2 36 (21.69%) Business Intelligence
3 35 (21.08%) Problem-Solving
4 33 (19.88%) Project Management
5 29 (17.47%) ETL
5 29 (17.47%) Migration
6 25 (15.06%) Visualisation
7 23 (13.86%) Data Migration
7 23 (13.86%) Decision-Making
7 23 (13.86%) PRINCE2
8 20 (12.05%) Business Analysis
9 18 (10.84%) Business Development
9 18 (10.84%) Scrum
10 17 (10.24%) Dashboard Development
10 17 (10.24%) Time Management
11 16 (9.64%) Continuous Improvement
11 16 (9.64%) Data Analysis
11 16 (9.64%) Scaled Agile Framework
12 14 (8.43%) MVC
12 14 (8.43%) OOP
Programming Languages
1 68 (40.96%) SQL
2 51 (30.72%) VBA
3 47 (28.31%) T-SQL
4 26 (15.66%) C#
5 17 (10.24%) JavaScript
6 14 (8.43%) Python
7 12 (7.23%) Go
8 6 (3.61%) JCL
8 6 (3.61%) REXX
9 3 (1.81%) VB
10 1 (0.60%) Google Apps Script
10 1 (0.60%) R
Qualifications
1 30 (18.07%) Degree
2 19 (11.45%) SC Cleared
2 19 (11.45%) Security Cleared
3 6 (3.61%) PRINCE2 Certification
4 5 (3.01%) MBA
4 5 (3.01%) PMI Certification
4 5 (3.01%) PMP
5 4 (2.41%) ISEB
6 2 (1.20%) ITIL Certification
6 2 (1.20%) ITIL Foundation Certificate
6 2 (1.20%) Microsoft Certification
7 1 (0.60%) Computer Science Degree
7 1 (0.60%) ISEB Practitioner
7 1 (0.60%) Master's Degree
7 1 (0.60%) Numerate Degree
Quality Assurance & Compliance
1 10 (6.02%) PMO
2 6 (3.61%) SLA
3 3 (1.81%) GDPR
3 3 (1.81%) ISO/IEC 27001
4 1 (0.60%) 21 CFR Part 11
4 1 (0.60%) Data Quality
4 1 (0.60%) GAMP
4 1 (0.60%) GMP
4 1 (0.60%) GxP
4 1 (0.60%) QA
System Software
1 6 (3.61%) RACF
2 4 (2.41%) Active Directory
3 2 (1.20%) Firmware
3 2 (1.20%) Microsoft Virtual Server
3 2 (1.20%) Virtual Servers
3 2 (1.20%) VMware Infrastructure
Systems Management
1 6 (3.61%) zSecure
2 2 (1.20%) SCCM
3 1 (0.60%) Systems Management Server (SMS)
Vendors
1 102 (61.45%) Microsoft
2 20 (12.05%) Tableau
3 19 (11.45%) Salesforce.com
4 15 (9.04%) Cognos
5 10 (6.02%) Oracle
6 6 (3.61%) MicroStrategy
7 5 (3.01%) Google
8 3 (1.81%) Cadence
9 2 (1.20%) BMC
9 2 (1.20%) Fortinet
9 2 (1.20%) Mitel
9 2 (1.20%) SAP
9 2 (1.20%) VMware
10 1 (0.60%) Cisco
10 1 (0.60%) Planview
10 1 (0.60%) Remedy
10 1 (0.60%) Sybase