Period
to 17 November 2018

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

Microsoft Excel
Cambridgeshire > Peterborough
6 months to
17 Nov 2018
Same period 2017 Same period 2016
Rank 68 54 38
Rank change year-on-year -14 -16 +9
Permanent jobs citing Microsoft Excel 39 21 26
As % of all permanent IT jobs advertised in Peterborough 4.38% 3.71% 4.44%
As % of the Applications category 58.21% 23.08% 49.06%
Number of salaries quoted 29 12 15
Peterborough median annual salary £35,000 £28,500 £28,000
Median salary % change year-on-year +22.81% +1.79% +5.66%
10th Percentile £19,650 £26,250 £21,250
90th Percentile £58,000 £41,175 £42,500
Cambridgeshire median annual salary £40,000 £30,000 £37,500
% change year-on-year +33.33% -20.00% +25.00%

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

All Software Application Skills
Peterborough
Permanent vacancies with a requirement for software application skills 67 91 53
As % of all permanent IT jobs advertised in Peterborough 7.53% 16.08% 9.04%
Number of salaries quoted 50 60 36
Peterborough median annual salary £35,000 £43,500 £27,500
Median salary % change year-on-year -19.54% +58.18% -8.33%
10th Percentile £19,750 £23,400 £18,750
90th Percentile £54,125 £58,750 £43,125
Cambridgeshire median annual salary £36,000 £35,000 £32,500
% change year-on-year +2.86% +7.69% -8.45%

Microsoft Excel
Job Vacancy Trend in Peterborough

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

Job vacancy trend for Microsoft Excel in Peterborough

Microsoft Excel
Salary Trend in Peterborough

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

Salary trend for Microsoft Excel in Peterborough

Microsoft Excel
Salary Histogram in Peterborough

The salary distribution of IT jobs citing Microsoft Excel in Peterborough over the 6 months to 17 November 2018.

Salary histogram for Microsoft Excel in Peterborough

For the 6 months to 17 November 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 Peterborough region with a requirement for Microsoft Excel.

1 27 (69.23%) Microsoft
2 16 (41.03%) Finance
3 15 (38.46%) Business Intelligence
4 13 (33.33%) Microsoft Office
4 13 (33.33%) Problem-Solving
5 12 (30.77%) SQL Server Integration Services
6 11 (28.21%) SQL Server Reporting Services
6 11 (28.21%) Microsoft PowerPoint
6 11 (28.21%) SQL Server
7 10 (25.64%) ETL
7 10 (25.64%) Analytics
7 10 (25.64%) Power BI
8 9 (23.08%) Degree
8 9 (23.08%) Project Management
8 9 (23.08%) CRM
8 9 (23.08%) Data Warehouse
9 8 (20.51%) Data Modelling
9 8 (20.51%) SQL Server Analysis Services
9 8 (20.51%) Analytical Skills
9 8 (20.51%) Contract Management
9 8 (20.51%) PowerPivot
10 7 (17.95%) Microsoft Power View
10 7 (17.95%) Driving Licence
10 7 (17.95%) Time Management
10 7 (17.95%) Marketing
10 7 (17.95%) Telecoms
10 7 (17.95%) Salesforce.com
10 7 (17.95%) Cognos
10 7 (17.95%) PRINCE2
11 6 (15.38%) Windows

Microsoft Excel
Co-occurring IT Skills in Peterborough 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 (15.38%) BizTalk Server
2 4 (10.26%) Oracle SOA Suite
3 3 (7.69%) SharePoint
Applications
1 13 (33.33%) Microsoft Office
2 11 (28.21%) Microsoft PowerPoint
3 1 (2.56%) Spreadsheet
Business Applications
1 6 (15.38%) Cognos Business Intelligence
2 4 (10.26%) Cognos TM1
3 2 (5.13%) HFM
3 2 (5.13%) NetSuite
3 2 (5.13%) SAP Business One
4 1 (2.56%) Dynamics AX
4 1 (2.56%) Dynamics NAV
Cloud Services
1 5 (12.82%) Office 365
2 3 (7.69%) Azure Data Factory
2 3 (7.69%) Microsoft Azure
3 1 (2.56%) Amazon AWS
Communications & Networking
1 2 (5.13%) Intranet
2 1 (2.56%) Internet
Database & Business Intelligence
1 12 (30.77%) SQL Server Integration Services
2 11 (28.21%) SQL Server
2 11 (28.21%) SQL Server Reporting Services
3 10 (25.64%) Power BI
4 9 (23.08%) Data Warehouse
5 8 (20.51%) PowerPivot
5 8 (20.51%) SQL Server Analysis Services
6 7 (17.95%) Microsoft Power View
7 5 (12.82%) GIS
8 2 (5.13%) SQL Server 2012
8 2 (5.13%) SQL Server 2016
9 1 (2.56%) Amazon Redshift
9 1 (2.56%) Microsoft Analysis Services
9 1 (2.56%) MS Access
9 1 (2.56%) OLAP
9 1 (2.56%) QlikView
9 1 (2.56%) SQL Server 2008
Development Applications
1 2 (5.13%) SQL Server Management Studio (SSMS)
General
1 16 (41.03%) Finance
2 7 (17.95%) Marketing
2 7 (17.95%) Telecoms
3 6 (15.38%) Advertising
4 4 (10.26%) Legal
4 4 (10.26%) Manufacturing
5 3 (7.69%) Billing
6 1 (2.56%) Games
Job Titles
1 8 (20.51%) Analyst
2 7 (17.95%) Architect
2 7 (17.95%) Business Intelligence Architect
3 6 (15.38%) Business Intelligence Developer
3 6 (15.38%) Developer
4 5 (12.82%) Administrator
4 5 (12.82%) IT Administrator
5 4 (10.26%) Coordinator
5 4 (10.26%) HR Manager
5 4 (10.26%) Report Developer
5 4 (10.26%) Transition Manager
6 3 (7.69%) Service Desk Team Leader
6 3 (7.69%) Team Leader
7 2 (5.13%) Business Architect
7 2 (5.13%) Business Intelligence Analyst
7 2 (5.13%) Delivery Manager
7 2 (5.13%) NetSuite Analyst
7 2 (5.13%) Service Manager
7 2 (5.13%) Systems Analyst
8 1 (2.56%) Sales Support
Libraries, Frameworks & Software Standards
1 6 (15.38%) Middleware
2 1 (2.56%) COM
Miscellaneous
1 8 (20.51%) Analytical Skills
2 7 (17.95%) Driving Licence
3 5 (12.82%) Management Information System
4 3 (7.69%) Data Structures
5 2 (5.13%) Self-Motivation
Operating Systems
1 6 (15.38%) Windows
Processes & Methodologies
1 15 (38.46%) Business Intelligence
2 13 (33.33%) Problem-Solving
3 10 (25.64%) Analytics
3 10 (25.64%) ETL
4 9 (23.08%) CRM
4 9 (23.08%) Project Management
5 8 (20.51%) Contract Management
5 8 (20.51%) Data Modelling
6 7 (17.95%) PRINCE2
6 7 (17.95%) Time Management
7 6 (15.38%) Network Planning
8 5 (12.82%) Commercial Awareness
8 5 (12.82%) ERP
8 5 (12.82%) Matrix Management
8 5 (12.82%) Quality Management
9 4 (10.26%) Data Integration
9 4 (10.26%) Process Improvement
9 4 (10.26%) SOA
10 3 (7.69%) Business Analysis
10 3 (7.69%) Line Management
Programming Languages
1 4 (10.26%) SQL
2 3 (7.69%) T-SQL
3 1 (2.56%) C
Qualifications
1 9 (23.08%) Degree
2 5 (12.82%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 5 (12.82%) SLA
2 1 (2.56%) Data Quality
2 1 (2.56%) GDPR
2 1 (2.56%) PMO
2 1 (2.56%) QA
Vendors
1 27 (69.23%) Microsoft
2 7 (17.95%) Cognos
2 7 (17.95%) Salesforce.com
3 6 (15.38%) Hyperion
3 6 (15.38%) Informatica
3 6 (15.38%) Oracle
3 6 (15.38%) Talend
4 2 (5.13%) Epicor
4 2 (5.13%) Infor
4 2 (5.13%) Sage
4 2 (5.13%) SAP
4 2 (5.13%) Tableau
4 2 (5.13%) Xero
5 1 (2.56%) JD Edwards