Period
to 17 January 2018

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

Microsoft Excel
Lancashire > Preston
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 28 35 25
Rank change year-on-year +7 -10 +17
Permanent jobs citing Microsoft Excel 16 9 6
As % of all permanent IT jobs advertised in Preston 8.08% 3.63% 3.68%
As % of the Applications category 76.19% 69.23% 30.00%
Number of salaries quoted 13 8 6
Preston median annual salary £40,000 £24,000 £27,500
Median salary % change year-on-year +66.67% -12.73% -15.38%
10th Percentile £20,450 £17,700 £20,750
90th Percentile £47,750 £50,500 £35,375
Lancashire median annual salary £40,000 £33,000 £29,000
% change year-on-year +21.21% +13.79% -22.67%

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

All Software Application Skills
Preston
Permanent vacancies with a requirement for software application skills 21 13 20
As % of all permanent IT jobs advertised in Preston 10.61% 5.24% 12.27%
Number of salaries quoted 16 12 20
Preston median annual salary £40,000 £26,000 £30,750
Median salary % change year-on-year +53.85% -15.45% -3.15%
10th Percentile £26,375 £18,200 £16,950
90th Percentile £46,250 £46,863 £40,675
Lancashire median annual salary £40,000 £33,000 £30,000
% change year-on-year +21.21% +10.00% +9.09%

Microsoft Excel
Job Vacancy Trend in Preston

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

Job vacancy trend for Microsoft Excel in Preston

Microsoft Excel
Salary Trend in Preston

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

Salary trend for Microsoft Excel in Preston

Microsoft Excel
Salary Histogram in Preston

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

Salary histogram for Microsoft Excel in Preston

For the 6 months to 17 January 2018, 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 Preston region with a requirement for Microsoft Excel.

1 10 (62.50%) Project Management
1 10 (62.50%) Finance
2 9 (56.25%) PRINCE2
3 8 (50.00%) Microsoft Project
3 8 (50.00%) Change Management
3 8 (50.00%) Risk Management
3 8 (50.00%) PRINCE2 Certification
3 8 (50.00%) Strategic Planning
3 8 (50.00%) Budget Control
3 8 (50.00%) People Management
3 8 (50.00%) Translating Business Requirements
4 4 (25.00%) Mathematics
4 4 (25.00%) Data Analysis
5 3 (18.75%) Capita
5 3 (18.75%) Telecoms
5 3 (18.75%) Microsoft Office
5 3 (18.75%) Business Intelligence
5 3 (18.75%) SQL
5 3 (18.75%) VBA
5 3 (18.75%) SQL Server
5 3 (18.75%) Business Development
5 3 (18.75%) SQL Server 2005
5 3 (18.75%) SQL Server Integration Services
5 3 (18.75%) SQL Server Reporting Services
5 3 (18.75%) Analytical Skills
5 3 (18.75%) Task Automation
6 2 (12.50%) Statistics
6 2 (12.50%) Web Development
6 2 (12.50%) Degree
6 2 (12.50%) Microsoft PowerPoint

Microsoft Excel
Co-occurring IT Skills in Preston 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 8 (50.00%) Microsoft Project
2 3 (18.75%) Microsoft Office
3 2 (12.50%) Microsoft PowerPoint
4 1 (6.25%) MS Visio
Database & Business Intelligence
1 3 (18.75%) SQL Server
1 3 (18.75%) SQL Server 2005
1 3 (18.75%) SQL Server Integration Services
1 3 (18.75%) SQL Server Reporting Services
2 1 (6.25%) Data Mining
General
1 10 (62.50%) Finance
2 3 (18.75%) Telecoms
Job Titles
1 9 (56.25%) Project Manager
2 3 (18.75%) Business Intelligence Developer
2 3 (18.75%) Developer
2 3 (18.75%) Senior Business Intelligence Developer
2 3 (18.75%) Senior Developer
3 2 (12.50%) Analyst
4 1 (6.25%) Data Analyst
4 1 (6.25%) Excel Analyst
4 1 (6.25%) Help Desk Analyst
4 1 (6.25%) Junior
4 1 (6.25%) Junior Project Manager
4 1 (6.25%) Senior Manager
4 1 (6.25%) Senior Test Manager
4 1 (6.25%) Statistical Data Analyst
4 1 (6.25%) Support Officer
4 1 (6.25%) Telecoms Manager
4 1 (6.25%) Test Manager
Libraries, Frameworks & Software Standards
1 2 (12.50%) .NET
Miscellaneous
1 3 (18.75%) Analytical Skills
2 2 (12.50%) N-Tier
3 1 (6.25%) CMDB
3 1 (6.25%) Smart Meter
Operating Systems
1 1 (6.25%) Windows
1 1 (6.25%) Windows 10
1 1 (6.25%) Windows 7
1 1 (6.25%) Windows Server
1 1 (6.25%) Windows Server 2008
1 1 (6.25%) Windows Server 2012
Processes & Methodologies
1 10 (62.50%) Project Management
2 9 (56.25%) PRINCE2
3 8 (50.00%) Budget Control
3 8 (50.00%) Change Management
3 8 (50.00%) People Management
3 8 (50.00%) Risk Management
3 8 (50.00%) Strategic Planning
3 8 (50.00%) Translating Business Requirements
4 4 (25.00%) Data Analysis
4 4 (25.00%) Mathematics
5 3 (18.75%) Business Development
5 3 (18.75%) Business Intelligence
5 3 (18.75%) Task Automation
6 2 (12.50%) Process Management
6 2 (12.50%) Statistics
6 2 (12.50%) Web Development
7 1 (6.25%) Data Protection
7 1 (6.25%) Process Improvement
7 1 (6.25%) Programme Governance
7 1 (6.25%) Remote Testing
Programming Languages
1 3 (18.75%) SQL
1 3 (18.75%) VBA
2 2 (12.50%) C#
3 1 (6.25%) Python
Qualifications
1 8 (50.00%) PRINCE2 Certification
2 2 (12.50%) Degree
Quality Assurance & Compliance
1 1 (6.25%) PMO
1 1 (6.25%) QA
System Software
1 1 (6.25%) Active Directory
Vendors
1 3 (18.75%) Capita
2 2 (12.50%) Microsoft
3 1 (6.25%) Cognos