The following table provides summary statistics for permanent job vacancies advertised in Portsmouth 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 3 months to 27 June 2017 with a comparison to the same period in the previous 2 years.

Microsoft Excel
Hampshire / Portsmouth
3 months to
27 Jun 2017
Same period 2016 Same period 2015
Rank 49 42 42
Rank change year-on-year -7 0  
Permanent jobs citing Microsoft Excel 7 6 9
As % of all permanent IT jobs advertised in Portsmouth 1.96% 2.42% 3.09%
As % of the Applications category 17.95% 23.08% 40.91%
Number of salaries quoted 6 6 7
Median salary £34,750 £37,500 £35,000
Median salary % change year-on-year -7.33% +7.14%  
90% offered a salary of more than £22,500 £22,500 £30,600
10% offered a salary of more than £42,250 £45,000 £55,000
UK excluding London median salary £33,000 £32,500 £32,500
% change year-on-year +1.53% -  

Microsoft Excel is in the software application skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for software application skills.

Software Application Skills
Portsmouth
Permanent job vacancies with a requirement for software application skills 39 26 22
As % of all permanent IT job vacancies advertised in Portsmouth 10.92% 10.48% 7.56%
Number of salaries quoted 32 26 14
Median salary £25,000 £32,500 £23,500
Median salary % change year-on-year -23.07% +38.29%  
90% offered a salary of more than £22,500 £25,000 £23,000
10% offered a salary of more than £47,500 £55,000 £40,000
UK excluding London median salary £34,000 £33,500 £34,000
% change year-on-year +1.49% -1.47%  

Microsoft Excel
Job Vacancy Trend in Portsmouth

The job posting trend of jobs advertised in Portsmouth citing Microsoft Excel as a proportion of all permanent or contract IT jobs with a match in the Applications category.

Job vacancy trend for Microsoft Excel in Portsmouth

Microsoft Excel
Salary Trend in Portsmouth

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

Salary trend for Microsoft Excel in Portsmouth

Microsoft Excel
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing Microsoft Excel in Portsmouth over the 3 months to 27 June 2017.

Salary histogram for Microsoft Excel in Portsmouth

For the 6 months to 27 June 2017, IT jobs citing Microsoft Excel also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Portsmouth region with a requirement for Microsoft Excel.

1 8 (61.54%) SQL
2 6 (46.15%) Business Intelligence
2 6 (46.15%) Agile Software Development
3 5 (38.46%) Finance
4 4 (30.77%) Microsoft
4 4 (30.77%) Oracle
4 4 (30.77%) Degree
4 4 (30.77%) Oracle BI EE
5 3 (23.08%) MS Access
6 2 (15.38%) Migration
6 2 (15.38%) Citrix
6 2 (15.38%) Terminal Services
6 2 (15.38%) Microsoft Office
6 2 (15.38%) Data Analysis
6 2 (15.38%) Business Analysis
6 2 (15.38%) Microsoft PowerPoint
6 2 (15.38%) Data Migration
6 2 (15.38%) SC Cleared
6 2 (15.38%) Security Cleared
6 2 (15.38%) Process Improvement
6 2 (15.38%) Data Quality
6 2 (15.38%) AAT
7 1 (7.69%) Power BI
7 1 (7.69%) HMG Security Policy Framework
7 1 (7.69%) IDoc
7 1 (7.69%) Data Architecture
7 1 (7.69%) Spreadsheet
7 1 (7.69%) SQL Server 2008
7 1 (7.69%) Visualisation
7 1 (7.69%) SAP Data Services

Microsoft Excel
Co-occurring IT Skills in Portsmouth 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:

Applications
1 2 (15.38%) Microsoft Office
1 2 (15.38%) Microsoft PowerPoint
2 1 (7.69%) MS Visio
2 1 (7.69%) Spreadsheet
Business Applications
1 1 (7.69%) Dynamics NAV
Database & Business Intelligence
1 4 (30.77%) Oracle BI EE
2 3 (23.08%) MS Access
3 1 (7.69%) BusinessObjects
3 1 (7.69%) DataStage
3 1 (7.69%) Power BI
3 1 (7.69%) QlikView
3 1 (7.69%) SAP Data Services
3 1 (7.69%) Spotfire
3 1 (7.69%) SQL Server
3 1 (7.69%) SQL Server 2008
General
1 5 (38.46%) Finance
Job Titles
1 8 (61.54%) Analyst
2 4 (30.77%) Developer
3 3 (23.08%) Analyst Developer
3 3 (23.08%) Business Analyst
3 3 (23.08%) OBIEE Developer
4 2 (15.38%) Business Systems Analyst
4 2 (15.38%) Data Business Analyst
4 2 (15.38%) Support Engineer
5 1 (7.69%) Administrator
5 1 (7.69%) Business Intelligence Analyst
5 1 (7.69%) Consultant
5 1 (7.69%) Data Analyst
5 1 (7.69%) Data Migration Developer
5 1 (7.69%) ERP Consultant
5 1 (7.69%) Excel Analyst
5 1 (7.69%) Integration Consultant
5 1 (7.69%) Oracle Analyst
5 1 (7.69%) Security Administrator
5 1 (7.69%) Software Consultant
Libraries, Frameworks & Software Standards
1 1 (7.69%) BAPI
1 1 (7.69%) HTML
1 1 (7.69%) IDoc
Processes & Methodologies
1 6 (46.15%) Agile Software Development
1 6 (46.15%) Business Intelligence
2 2 (15.38%) Business Analysis
2 2 (15.38%) Data Analysis
2 2 (15.38%) Data Migration
2 2 (15.38%) Migration
2 2 (15.38%) Process Improvement
3 1 (7.69%) Change Management
3 1 (7.69%) Data Cleansing
3 1 (7.69%) Data Extraction
3 1 (7.69%) Data Governance
3 1 (7.69%) Data Integration
3 1 (7.69%) Data Modelling
3 1 (7.69%) Data Visualisation
3 1 (7.69%) ERP
3 1 (7.69%) Information Security
3 1 (7.69%) Project Management
3 1 (7.69%) Stakeholder Management
3 1 (7.69%) Statistics
3 1 (7.69%) Visualisation
Programming Languages
1 8 (61.54%) SQL
2 1 (7.69%) ABAP
2 1 (7.69%) C
2 1 (7.69%) VBA
Qualifications
1 4 (30.77%) Degree
2 2 (15.38%) AAT
2 2 (15.38%) SC Cleared
2 2 (15.38%) Security Cleared
Quality Assurance & Compliance
1 2 (15.38%) Data Quality
2 1 (7.69%) HMG Security Policy Framework
2 1 (7.69%) JSP 440
System Software
1 2 (15.38%) Terminal Services
Vendors
1 4 (30.77%) Microsoft
1 4 (30.77%) Oracle
2 2 (15.38%) Citrix
3 1 (7.69%) Cognos
3 1 (7.69%) Google
3 1 (7.69%) SAP
3 1 (7.69%) Tableau
Portsmouth, Hampshire
Colston Consulting
Salary: £30000 - £40000 per annum
Posted: 6 days ago