Period
to 21 July 2018

The following table provides summary statistics for contract job vacancies advertised in Hertfordshire with a requirement for Microsoft Excel skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Microsoft Excel over the 6 months to 21 July 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Microsoft Excel
East of England > Hertfordshire
6 months to
21 Jul 2018
Same period 2017 Same period 2016
Rank 29 35 28
Rank change year-on-year +6 -7 +7
Contract jobs citing Microsoft Excel 90 61 71
As % of all contract IT jobs advertised in Hertfordshire 5.70% 4.75% 5.08%
As % of the Applications category 42.86% 38.13% 35.50%
Number of daily rates quoted 52 31 36
Hertfordshire median daily rate £240 £225 £400
Median daily rate % change year-on-year +6.67% -43.75% +33.33%
10th Percentile £131 £113 £153
90th Percentile £456 £375 £476
East of England median daily rate £323 £300 £350
% change year-on-year +7.50% -14.29% +38.61%
Number of hourly rates quoted 16 5 6
Hertfordshire median hourly rate £26.25 £16.84 £9.50
Median hourly rate % change year-on-year +55.93% +77.21% -5.33%
10th Percentile £10.38 £11.35 £9.00
90th Percentile £46.25 £25.15 £14.65
East of England median hourly rate £22.50 £17.42 £18.00
% change year-on-year +29.18% -3.24% +46.94%

Microsoft Excel is in the Software Applications category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Hertfordshire with a requirement for software application skills.

All Software Application Skills
Hertfordshire
Contract vacancies with a requirement for software application skills 210 160 200
As % of all contract IT jobs advertised in Hertfordshire 13.30% 12.46% 14.30%
Number of daily rates quoted 101 78 80
Hertfordshire median daily rate £242 £325 £370
Median daily rate % change year-on-year -25.46% -12.23% +18.49%
10th Percentile £123 £140 £129
90th Percentile £469 £486 £488
East of England median daily rate £310 £325 £325
% change year-on-year -4.62% - +18.18%
Number of hourly rates quoted 43 27 29
Hertfordshire median hourly rate £13.00 £15.50 £17.00
Median hourly rate % change year-on-year -16.13% -8.82% +19.30%
10th Percentile £11.16 £10.23 £9.20
90th Percentile £35.00 £53.23 £52.75
East of England median hourly rate £15.25 £16.84 £16.50
% change year-on-year -9.41% +2.03% +13.79%

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
Contractor Daily Rate Trend in Hertfordshire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Microsoft Excel in Hertfordshire.

Contractor daily rate trend for Microsoft Excel in Hertfordshire

Microsoft Excel
Contractor Daily Rate Histogram in Hertfordshire

The daily rate distribution of IT jobs citing Microsoft Excel in Hertfordshire over the 6 months to 21 July 2018.

Contractor daily rate histogram for Microsoft Excel in Hertfordshire

Microsoft Excel
Contractor Hourly Rate Trend in Hertfordshire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Microsoft Excel in Hertfordshire.

Contractor hourly rate trend for Microsoft Excel in Hertfordshire

Microsoft Excel
Contractor Hourly Rate Histogram in Hertfordshire

The hourly rate distribution of IT jobs citing Microsoft Excel in Hertfordshire over the 6 months to 21 July 2018.

Contractor hourly rate histogram for Microsoft Excel in Hertfordshire

Microsoft Excel
Contract Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Microsoft Excel within the Hertfordshire region over the 6 months to 21 July 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Welwyn Garden City +3 23 £140 -56.92% 4
Watford +3 20 £400 +45.45% 1
Hemel Hempstead -2 10 £215 - 1
Hatfield -2 10 £200 - 4
Royston -3 7 £463 +42.31% 2
Stevenage -7 7 £138 -57.63% 2
Rickmansworth -8 2 - - 2
Ware - 1 £415 -
St Albans - 1 - - 1
Hitchin - 1 £500 -
Microsoft Excel
East of England

For the 6 months to 21 July 2018, IT contractor 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 contract job ads across the Hertfordshire region with a requirement for Microsoft Excel.

1 41 (45.56%) Microsoft
2 28 (31.11%) Microsoft Office
3 21 (23.33%) Project Management
3 21 (23.33%) Microsoft PowerPoint
4 17 (18.89%) Finance
4 17 (18.89%) SQL
5 15 (16.67%) Agile Software Development
6 13 (14.44%) MS Visio
7 12 (13.33%) Spreadsheet
8 10 (11.11%) SAP
8 10 (11.11%) ETL
8 10 (11.11%) Manufacturing
9 9 (10.00%) Migration
9 9 (10.00%) ERP
9 9 (10.00%) Data Migration
9 9 (10.00%) Data Analysis
9 9 (10.00%) Analytical Skills
9 9 (10.00%) Problem-Solving
10 8 (8.89%) Logistics
10 8 (8.89%) Data Protection
10 8 (8.89%) Data Entry
10 8 (8.89%) PRINCE2
10 8 (8.89%) Windows
10 8 (8.89%) SQL Server
11 7 (7.78%) Stakeholder Management
11 7 (7.78%) Microsoft Project
11 7 (7.78%) VBA
11 7 (7.78%) Continuous Improvement
11 7 (7.78%) Degree
12 6 (6.67%) Test Scripting

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 6 (6.67%) SharePoint
2 2 (2.22%) Jupyter
3 1 (1.11%) MS Exchange
Applications
1 28 (31.11%) Microsoft Office
2 21 (23.33%) Microsoft PowerPoint
3 13 (14.44%) MS Visio
4 12 (13.33%) Spreadsheet
5 7 (7.78%) Microsoft Project
6 2 (2.22%) AutoCAD
Business Applications
1 4 (4.44%) Dynamics AX
2 3 (3.33%) Sage 50
3 2 (2.22%) BPCS
3 2 (2.22%) Movex
3 2 (2.22%) Oracle EBS
3 2 (2.22%) Oracle Financials
3 2 (2.22%) Oracle Procure-to-Pay
4 1 (1.11%) CA PPM
4 1 (1.11%) Oracle 11i
4 1 (1.11%) Oracle EBS R12
4 1 (1.11%) Oracle ERP
4 1 (1.11%) Teamcenter
Cloud Services
1 6 (6.67%) Microsoft Azure
2 3 (3.33%) SaaS
3 1 (1.11%) Trello
Communications & Networking
1 5 (5.56%) Skype
2 4 (4.44%) Internet
2 4 (4.44%) VPN
3 1 (1.11%) ATM
3 1 (1.11%) FlexRay
3 1 (1.11%) Wireless
Database & Business Intelligence
1 8 (8.89%) SQL Server
2 5 (5.56%) SQL Server Analysis Services
2 5 (5.56%) SQL Server Integration Services
3 4 (4.44%) BusinessObjects
4 3 (3.33%) Data Warehouse
4 3 (3.33%) MS Access
4 3 (3.33%) NoSQL
4 3 (3.33%) Relational Database
4 3 (3.33%) SQL Server 2012
4 3 (3.33%) SQL Server 2016
4 3 (3.33%) SQL Server Reporting Services
5 2 (2.22%) Looker
5 2 (2.22%) MongoDB
5 2 (2.22%) OLAP
6 1 (1.11%) Apache Hive
6 1 (1.11%) dBASE
6 1 (1.11%) Hadoop
6 1 (1.11%) Oracle Reports
Development Applications
1 3 (3.33%) JIRA
1 3 (3.33%) JMeter
1 3 (3.33%) Selenium
2 1 (1.11%) LoadRunner
2 1 (1.11%) Rational DOORS
2 1 (1.11%) Rational Rhapsody
General
1 17 (18.89%) Finance
2 10 (11.11%) Manufacturing
3 4 (4.44%) Retail
4 3 (3.33%) Banking
4 3 (3.33%) Marketing
5 2 (2.22%) Billing
6 1 (1.11%) Automotive
6 1 (1.11%) Electronics
6 1 (1.11%) French Language
6 1 (1.11%) Law
6 1 (1.11%) Legal
6 1 (1.11%) Pharmaceutical
6 1 (1.11%) Polish Language
Job Titles
1 24 (26.67%) Analyst
2 16 (17.78%) Project Manager
3 13 (14.44%) Administrator
3 13 (14.44%) Data Analyst
4 9 (10.00%) Coordinator
5 8 (8.89%) Project Coordinator
6 6 (6.67%) Azure Consultant
6 6 (6.67%) Consultant
6 6 (6.67%) Developer
7 5 (5.56%) Data Administrator
7 5 (5.56%) IT Manager
7 5 (5.56%) IT Project Manager
7 5 (5.56%) Project Administrator
8 4 (4.44%) Senior IT Manager
8 4 (4.44%) Senior IT Project Manager
8 4 (4.44%) Senior Manager
8 4 (4.44%) Senior Project Manager
8 4 (4.44%) SQL Developer
9 3 (3.33%) Agile Tester
9 3 (3.33%) Identity Management Consultant
Libraries, Frameworks & Software Standards
1 3 (3.33%) Oracle Fusion
2 2 (2.22%) CSS
2 2 (2.22%) HTML
3 1 (1.11%) .NET
3 1 (1.11%) 802.1X
3 1 (1.11%) Middleware
3 1 (1.11%) REST
3 1 (1.11%) SOAP
3 1 (1.11%) Web Services
Miscellaneous
1 9 (10.00%) Analytical Skills
2 4 (4.44%) NHS
3 3 (3.33%) FMCG
4 2 (2.22%) CMDB
4 2 (2.22%) Driving Licence
4 2 (2.22%) Management Information System
4 2 (2.22%) PMI
4 2 (2.22%) Virtual Team
5 1 (1.11%) Computer Science
5 1 (1.11%) iPad
5 1 (1.11%) Public Cloud
Operating Systems
1 8 (8.89%) Windows
2 3 (3.33%) Windows 7
3 2 (2.22%) Windows 10
3 2 (2.22%) Windows XP
Processes & Methodologies
1 21 (23.33%) Project Management
2 15 (16.67%) Agile Software Development
3 10 (11.11%) ETL
4 9 (10.00%) Data Analysis
4 9 (10.00%) Data Migration
4 9 (10.00%) ERP
4 9 (10.00%) Migration
4 9 (10.00%) Problem-Solving
5 8 (8.89%) Data Entry
5 8 (8.89%) Data Protection
5 8 (8.89%) Logistics
5 8 (8.89%) PRINCE2
6 7 (7.78%) Continuous Improvement
6 7 (7.78%) Stakeholder Management
7 6 (6.67%) Business Intelligence
7 6 (6.67%) Change Control
7 6 (6.67%) Data Loss Prevention
7 6 (6.67%) Scrum
7 6 (6.67%) Test Scripting
8 5 (5.56%) Data Management
Programming Languages
1 17 (18.89%) SQL
2 7 (7.78%) VBA
3 6 (6.67%) Java
3 6 (6.67%) Python
4 5 (5.56%) T-SQL
5 4 (4.44%) C
5 4 (4.44%) PL/SQL
6 3 (3.33%) VB
7 2 (2.22%) C#
7 2 (2.22%) MATLAB
7 2 (2.22%) R
8 1 (1.11%) FoxPro (VFP)
8 1 (1.11%) Go
Qualifications
1 7 (7.78%) Degree
2 4 (4.44%) Security Cleared
3 2 (2.22%) Microsoft Certification
3 2 (2.22%) PMI Certification
3 2 (2.22%) SC Cleared
4 1 (1.11%) ISTQB
4 1 (1.11%) ISTQB Foundation Certification
4 1 (1.11%) Master's Degree
4 1 (1.11%) MCP
4 1 (1.11%) MCSE
4 1 (1.11%) OCP
4 1 (1.11%) Oracle Certification
4 1 (1.11%) PMP
Quality Assurance & Compliance
1 5 (5.56%) Data Quality
1 5 (5.56%) SLA
2 2 (2.22%) GDPR
3 1 (1.11%) PMO
System Software
1 3 (3.33%) Active Directory
Systems Management
1 2 (2.22%) OpenView
1 2 (2.22%) OVSD
1 2 (2.22%) SCCM
2 1 (1.11%) NetBackup
Vendors
1 41 (45.56%) Microsoft
2 10 (11.11%) SAP
3 5 (5.56%) Oracle
4 4 (4.44%) Informatica
4 4 (4.44%) Tableau
5 3 (3.33%) Cognos
5 3 (3.33%) Embarcadero
5 3 (3.33%) HP
5 3 (3.33%) IBM
5 3 (3.33%) Remedy
5 3 (3.33%) Sage
6 2 (2.22%) BMC
6 2 (2.22%) Citrix
6 2 (2.22%) Google
6 2 (2.22%) Jaspersoft
6 2 (2.22%) Salesforce.com
6 2 (2.22%) Sun
7 1 (1.11%) ATG
7 1 (1.11%) Mentor Graphics
7 1 (1.11%) ServiceNow