Period
to 15 August 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 15 August 2018 with a comparison to the same period in the previous 2 years.

Microsoft Excel
Cambridgeshire > Peterborough
6 months to
15 Aug 2018
Same period 2017 Same period 2016
Rank 29 52 45
Rank change year-on-year +23 -7 +10
Permanent jobs citing Microsoft Excel 80 16 29
As % of all permanent IT jobs advertised in Peterborough 7.98% 2.95% 4.37%
As % of the Applications category 61.07% 23.53% 56.86%
Number of salaries quoted 45 11 16
Peterborough median annual salary £45,000 £28,000 £38,000
Median salary % change year-on-year +60.71% -26.32% +68.89%
10th Percentile £21,500 £24,250 £20,125
90th Percentile £60,000 £35,000 £44,125
Cambridgeshire median annual salary £40,000 £26,500 £37,250
% change year-on-year +50.94% -28.86% +24.17%

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 131 68 51
As % of all permanent IT jobs advertised in Peterborough 13.07% 12.52% 7.69%
Number of salaries quoted 74 44 28
Peterborough median annual salary £40,000 £41,250 £27,750
Median salary % change year-on-year -3.03% +48.65% -7.50%
10th Percentile £20,650 £24,400 £19,000
90th Percentile £60,000 £59,450 £43,775
Cambridgeshire median annual salary £41,050 £35,000 £32,500
% change year-on-year +17.29% +7.69% -

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 15 August 2018.

Salary histogram for Microsoft Excel in Peterborough

For the 6 months to 15 August 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 49 (61.25%) Microsoft
2 31 (38.75%) Business Intelligence
3 29 (36.25%) Finance
4 27 (33.75%) CRM
5 25 (31.25%) Analytics
6 24 (30.00%) Marketing
7 22 (27.50%) Data Warehouse
8 20 (25.00%) Microsoft PowerPoint
9 19 (23.75%) SQL Server
10 18 (22.50%) Oracle
10 18 (22.50%) Hyperion
10 18 (22.50%) SQL Server Integration Services
11 17 (21.25%) SQL Server Reporting Services
12 16 (20.00%) Project Management
12 16 (20.00%) Power BI
13 15 (18.75%) Microsoft Power View
13 15 (18.75%) Data Modelling
13 15 (18.75%) PRINCE2
13 15 (18.75%) PowerPivot
13 15 (18.75%) Office 365
13 15 (18.75%) SQL Server Analysis Services
14 14 (17.50%) SQL
14 14 (17.50%) ETL
14 14 (17.50%) Problem-Solving
15 13 (16.25%) Analytical Skills
15 13 (16.25%) Contract Management
15 13 (16.25%) Microsoft Office
16 12 (15.00%) Cognos
16 12 (15.00%) Telecoms
17 11 (13.75%) BizTalk Server

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 11 (13.75%) BizTalk Server
2 9 (11.25%) Oracle SOA Suite
2 9 (11.25%) SharePoint
Applications
1 20 (25.00%) Microsoft PowerPoint
2 13 (16.25%) Microsoft Office
3 4 (5.00%) Microsoft Project
3 4 (5.00%) Spreadsheet
Business Applications
1 11 (13.75%) Cognos Business Intelligence
2 9 (11.25%) Cognos TM1
2 9 (11.25%) HFM
2 9 (11.25%) NetSuite
2 9 (11.25%) SAP Business One
Cloud Services
1 15 (18.75%) Office 365
2 6 (7.50%) Azure Data Factory
2 6 (7.50%) Microsoft Azure
3 1 (1.25%) Amazon AWS
Communications & Networking
1 10 (12.50%) Intranet
Database & Business Intelligence
1 22 (27.50%) Data Warehouse
2 19 (23.75%) SQL Server
3 18 (22.50%) SQL Server Integration Services
4 17 (21.25%) SQL Server Reporting Services
5 16 (20.00%) Power BI
6 15 (18.75%) Microsoft Power View
6 15 (18.75%) PowerPivot
6 15 (18.75%) SQL Server Analysis Services
7 8 (10.00%) GIS
8 2 (2.50%) SQL Server 2012
8 2 (2.50%) SQL Server 2016
9 1 (1.25%) Amazon Redshift
9 1 (1.25%) BusinessObjects
9 1 (1.25%) MS Access
9 1 (1.25%) OLAP
9 1 (1.25%) QlikView
9 1 (1.25%) Relational Database
9 1 (1.25%) WebFOCUS
General
1 29 (36.25%) Finance
2 24 (30.00%) Marketing
3 12 (15.00%) Telecoms
4 9 (11.25%) Advertising
4 9 (11.25%) Manufacturing
5 6 (7.50%) Retail
6 3 (3.75%) Games
7 1 (1.25%) Billing
7 1 (1.25%) Brand Awareness
7 1 (1.25%) Legal
Job Titles
1 28 (35.00%) Analyst
2 15 (18.75%) Architect
2 15 (18.75%) Business Intelligence Architect
3 11 (13.75%) Business Intelligence Developer
3 11 (13.75%) Developer
4 9 (11.25%) NetSuite Analyst
4 9 (11.25%) Report Developer
4 9 (11.25%) Systems Analyst
5 8 (10.00%) Service Desk Team Leader
5 8 (10.00%) Team Leader
6 7 (8.75%) Business Intelligence Analyst
6 7 (8.75%) Project Manager
7 6 (7.50%) Data Analyst
8 5 (6.25%) Coordinator
9 4 (5.00%) Marketing Assistant
10 3 (3.75%) Administrator
10 3 (3.75%) Delivery Manager
10 3 (3.75%) IT Administrator
10 3 (3.75%) Research Analyst
11 2 (2.50%) Delivery Project Manager
Libraries, Frameworks & Software Standards
1 11 (13.75%) Middleware
2 1 (1.25%) COM
2 1 (1.25%) XML
Miscellaneous
1 13 (16.25%) Analytical Skills
2 11 (13.75%) Driving Licence
3 8 (10.00%) Management Information System
4 3 (3.75%) Data Centre
4 3 (3.75%) Data Structures
5 1 (1.25%) Algorithms
5 1 (1.25%) Computer Science
5 1 (1.25%) Enterprise Software
5 1 (1.25%) Foreign Exchange (FX)
5 1 (1.25%) Robotics
Operating Systems
1 4 (5.00%) Windows
Processes & Methodologies
1 31 (38.75%) Business Intelligence
2 27 (33.75%) CRM
3 25 (31.25%) Analytics
4 16 (20.00%) Project Management
5 15 (18.75%) Data Modelling
5 15 (18.75%) PRINCE2
6 14 (17.50%) ETL
6 14 (17.50%) Problem-Solving
7 13 (16.25%) Contract Management
8 11 (13.75%) ERP
9 10 (12.50%) Network Planning
9 10 (12.50%) Service Delivery
10 9 (11.25%) Data Integration
10 9 (11.25%) Document Management
10 9 (11.25%) E-Commerce
10 9 (11.25%) SOA
11 8 (10.00%) Commercial Awareness
11 8 (10.00%) Incident Management
11 8 (10.00%) ITIL
11 8 (10.00%) Quality Management
Programming Languages
1 14 (17.50%) SQL
2 3 (3.75%) T-SQL
3 1 (1.25%) C
3 1 (1.25%) R
3 1 (1.25%) VB
3 1 (1.25%) VBA
Qualifications
1 11 (13.75%) PRINCE2 Practitioner
2 9 (11.25%) Degree
3 1 (1.25%) Computer Science Degree
3 1 (1.25%) Numerate Degree
Quality Assurance & Compliance
1 9 (11.25%) SLA
2 6 (7.50%) GDPR
2 6 (7.50%) QA
3 2 (2.50%) PMO
Vendors
1 49 (61.25%) Microsoft
2 18 (22.50%) Hyperion
2 18 (22.50%) Oracle
3 12 (15.00%) Cognos
4 11 (13.75%) Informatica
4 11 (13.75%) Salesforce.com
4 11 (13.75%) Talend
5 9 (11.25%) Epicor
5 9 (11.25%) Infor
5 9 (11.25%) Sage
5 9 (11.25%) SAP
5 9 (11.25%) Xero
6 1 (1.25%) Facebook
6 1 (1.25%) Tableau