Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Portsmouth with a requirement for Microsoft Office skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Microsoft Office over the 6 months to 20 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Office
Hampshire > Portsmouth
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 45 62 45
Rank change year-on-year +17 -17 +33
Permanent jobs citing Microsoft Office 43 14 46
As % of all permanent IT jobs advertised in Portsmouth 6.20% 2.12% 5.69%
As % of the Applications category 50.00% 26.92% 52.87%
Number of salaries quoted 43 13 49
Portsmouth median annual salary £23,500 £25,000 £32,500
Median salary % change year-on-year -6.00% -23.08% +8.33%
10th Percentile £22,750 £19,200 £24,000
90th Percentile £27,000 £40,250 £45,000
Hampshire median annual salary £27,000 £29,500 £29,000
% change year-on-year -8.47% +1.72% +13.73%

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

All Software Application Skills
Portsmouth
Permanent vacancies with a requirement for software application skills 86 52 87
As % of all permanent IT jobs advertised in Portsmouth 12.39% 7.87% 10.75%
Number of salaries quoted 82 51 63
Portsmouth median annual salary £25,000 £32,500 £35,000
Median salary % change year-on-year -23.08% -7.14% +27.27%
10th Percentile £22,500 £19,125 £24,000
90th Percentile £47,950 £45,000 £45,000
Hampshire median annual salary £30,000 £35,000 £35,000
% change year-on-year -14.29% - +16.67%

Microsoft Office
Job Vacancy Trend in Portsmouth

Job postings citing Microsoft Office as a percentage of all IT jobs advertised in Portsmouth.

Job vacancy trend for Microsoft Office in Portsmouth

Microsoft Office
Salary Trend in Portsmouth

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

Salary trend for Microsoft Office in Portsmouth

Microsoft Office
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing Microsoft Office in Portsmouth over the 6 months to 20 November 2017.

Salary histogram for Microsoft Office in Portsmouth

For the 6 months to 20 November 2017, IT jobs citing Microsoft Office 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 Office.

1 41 (95.35%) Microsoft
2 40 (93.02%) Windows
3 30 (69.77%) Active Directory
3 30 (69.77%) Windows 7
4 28 (65.12%) Driving Licence
4 28 (65.12%) ITIL
5 27 (62.79%) MCP
5 27 (62.79%) LAN
5 27 (62.79%) WAN
5 27 (62.79%) Microsoft Certification
5 27 (62.79%) MCDST
5 27 (62.79%) MCTS
5 27 (62.79%) MCITP
5 27 (62.79%) Security Cleared
5 27 (62.79%) SC Cleared
6 24 (55.81%) MS Exchange
7 20 (46.51%) DV Cleared
8 11 (25.58%) SLA
8 11 (25.58%) Linux
9 10 (23.26%) Windows Server
10 3 (6.98%) Windows XP
10 3 (6.98%) Degree
11 2 (4.65%) Windows 8
11 2 (4.65%) Finance
12 1 (2.33%) SOLIDWORKS
12 1 (2.33%) ANSYS
12 1 (2.33%) Service Delivery
12 1 (2.33%) Firewall
12 1 (2.33%) Wi-Fi
12 1 (2.33%) Terminal Services

Microsoft Office
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:

Application Platforms
1 24 (55.81%) MS Exchange
2 1 (2.33%) IIS
2 1 (2.33%) SharePoint
Applications
1 1 (2.33%) Abaqus
1 1 (2.33%) Microsoft Excel
1 1 (2.33%) SOLIDWORKS
Cloud Services
1 1 (2.33%) Office 365
Communications & Networking
1 27 (62.79%) LAN
1 27 (62.79%) WAN
2 1 (2.33%) DHCP
2 1 (2.33%) DNS
2 1 (2.33%) Firewall
2 1 (2.33%) Internet
2 1 (2.33%) Remote Desktop
2 1 (2.33%) TCP/IP
2 1 (2.33%) VPN
2 1 (2.33%) Wi-Fi
Database & Business Intelligence
1 1 (2.33%) SQL Server
Development Applications
1 1 (2.33%) Team Foundation Server
General
1 2 (4.65%) Finance
2 1 (2.33%) Retail
Job Titles
1 40 (93.02%) Analyst
2 30 (69.77%) Service Analyst
2 30 (69.77%) Service Desk Analyst
3 28 (65.12%) 1st Line Service Desk Analyst
4 9 (20.93%) 2nd Line Support
4 9 (20.93%) 2nd Line Support Analyst
4 9 (20.93%) Support Analyst
5 1 (2.33%) Administrator
5 1 (2.33%) Infrastructure Engineer
5 1 (2.33%) IT Administrator
5 1 (2.33%) IT Analyst
5 1 (2.33%) IT Engineer
5 1 (2.33%) IT Infrastructure Engineer
5 1 (2.33%) IT Support
5 1 (2.33%) Support Engineer
Miscellaneous
1 28 (65.12%) Driving Licence
2 1 (2.33%) Analytical Skills
Operating Systems
1 40 (93.02%) Windows
2 30 (69.77%) Windows 7
3 11 (25.58%) Linux
4 10 (23.26%) Windows Server
5 3 (6.98%) Windows XP
6 2 (4.65%) Windows 8
7 1 (2.33%) Windows 10
7 1 (2.33%) Windows Server 2008
Processes & Methodologies
1 28 (65.12%) ITIL
2 1 (2.33%) CAD
2 1 (2.33%) Data Extraction
2 1 (2.33%) E-Commerce
2 1 (2.33%) Finite Element Analysis
2 1 (2.33%) IT Audit
2 1 (2.33%) Root Cause Analysis
2 1 (2.33%) Service Delivery
2 1 (2.33%) Stress Analysis
2 1 (2.33%) Time Management
Programming Languages
1 1 (2.33%) Fortran
1 1 (2.33%) Python
1 1 (2.33%) VB
Qualifications
1 27 (62.79%) MCDST
1 27 (62.79%) MCITP
1 27 (62.79%) MCP
1 27 (62.79%) MCTS
1 27 (62.79%) Microsoft Certification
1 27 (62.79%) SC Cleared
1 27 (62.79%) Security Cleared
2 20 (46.51%) DV Cleared
3 3 (6.98%) Degree
4 1 (2.33%) AAT
4 1 (2.33%) PhD
Quality Assurance & Compliance
1 11 (25.58%) SLA
System Software
1 30 (69.77%) Active Directory
2 1 (2.33%) Hyper-V
2 1 (2.33%) Terminal Services
2 1 (2.33%) Virtual Servers
Vendors
1 41 (95.35%) Microsoft
2 1 (2.33%) ANSYS
2 1 (2.33%) Citrix