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

Microsoft Excel
North West / Lancashire
3 months to
24 Jun 2017
Same period 2016 Same period 2015
Rank 42 36 55
Rank change year-on-year -6 +19  
Permanent jobs citing Microsoft Excel 14 26 19
As % of all permanent IT jobs advertised in Lancashire 3.21% 5.76% 3.25%
As % of the Applications category 58.33% 48.15% 36.54%
Number of salaries quoted 10 20 12
Median salary £32,000 £30,000 £25,375
Median salary % change year-on-year +6.66% +18.22%  
90% offered a salary of more than £25,550 £22,500 £21,500
10% offered a salary of more than £35,000 £35,000 £33,400
UK excluding London median salary £33,163 £32,500 £32,500
% change year-on-year +2.03% -  

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

Software Application Skills
Lancashire
Permanent job vacancies with a requirement for software application skills 24 54 52
As % of all permanent IT job vacancies advertised in Lancashire 5.50% 11.97% 8.89%
Number of salaries quoted 16 44 37
Median salary £32,500 £30,000 £22,500
Median salary % change year-on-year +8.33% +33.33%  
90% offered a salary of more than £26,500 £22,500 £18,300
10% offered a salary of more than £35,000 £37,500 £39,750
UK excluding London median salary £34,200 £33,500 £34,000
% change year-on-year +2.08% -1.47%  

Microsoft Excel
Job Vacancy Trend in Lancashire

The job posting trend of jobs advertised in Lancashire 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 Lancashire

Microsoft Excel
Salary Trend in Lancashire

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

Salary trend for Microsoft Excel in Lancashire

Microsoft Excel
Salary Histogram in Lancashire

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

Salary histogram for Microsoft Excel in Lancashire

Microsoft Excel
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Microsoft Excel within the Lancashire region over the 3 months to 24 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Preston -4 6 £27,000 +20.00%
Chorley -14 1 £32,500 +5.69% 2
Microsoft Excel
North West

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

1 15 (75.00%) SQL
2 11 (55.00%) Business Intelligence
3 10 (50.00%) Microsoft
3 10 (50.00%) SQL Server Integration Services
4 9 (45.00%) SQL Server
5 8 (40.00%) SQL Server Reporting Services
6 7 (35.00%) Microsoft PowerPoint
7 6 (30.00%) T-SQL
8 5 (25.00%) MS Visio
8 5 (25.00%) Tableau
9 4 (20.00%) Analytics
9 4 (20.00%) Power BI
9 4 (20.00%) BusinessObjects
9 4 (20.00%) Project Management
9 4 (20.00%) VBA
9 4 (20.00%) Microsoft Office
9 4 (20.00%) Data Analysis
10 3 (15.00%) WFM
10 3 (15.00%) MDX
10 3 (15.00%) Data Protection
10 3 (15.00%) Process Management
10 3 (15.00%) Management Information System
10 3 (15.00%) Stakeholder Management
10 3 (15.00%) MS Access
10 3 (15.00%) Cognos
10 3 (15.00%) Analytical Skills
10 3 (15.00%) Data Analytics
11 2 (10.00%) Degree
11 2 (10.00%) Vulnerability Management
11 2 (10.00%) Marketing

Microsoft Excel
Co-occurring IT Skills in Lancashire 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 7 (35.00%) Microsoft PowerPoint
2 5 (25.00%) MS Visio
3 4 (20.00%) Microsoft Office
Business Applications
1 2 (10.00%) Dynamics CRM
Database & Business Intelligence
1 10 (50.00%) SQL Server Integration Services
2 9 (45.00%) SQL Server
3 8 (40.00%) SQL Server Reporting Services
4 4 (20.00%) BusinessObjects
4 4 (20.00%) Power BI
5 3 (15.00%) MS Access
6 2 (10.00%) Data Mining
6 2 (10.00%) SQL Server 2005
7 1 (5.00%) Data Warehouse
7 1 (5.00%) Relational Database
7 1 (5.00%) SQL Server 2012
General
1 2 (10.00%) Finance
1 2 (10.00%) Marketing
2 1 (5.00%) Back Office
2 1 (5.00%) Telecoms
Job Titles
1 11 (55.00%) Analyst
2 6 (30.00%) Developer
3 3 (15.00%) Data Analyst
3 3 (15.00%) SQL Analyst
3 3 (15.00%) SQL Developer
4 2 (10.00%) Business Intelligence Developer
4 2 (10.00%) CRM Analyst
4 2 (10.00%) Disaster Recovery Analyst
4 2 (10.00%) Information Analyst
4 2 (10.00%) Insight Analyst
4 2 (10.00%) SQL BI Developer
4 2 (10.00%) SQL Data Analyst
4 2 (10.00%) SQL Server Analyst
4 2 (10.00%) SSIS Analyst
4 2 (10.00%) SSRS Analyst
4 2 (10.00%) Vulnerability Analyst
5 1 (5.00%) ERP Business Analyst
5 1 (5.00%) IT Administrator
5 1 (5.00%) Tableau Developer
5 1 (5.00%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 3 (15.00%) MDX
2 1 (5.00%) .NET
Miscellaneous
1 3 (15.00%) Analytical Skills
1 3 (15.00%) Management Information System
2 1 (5.00%) Driving Licence
Operating Systems
1 2 (10.00%) Linux
1 2 (10.00%) Windows
Processes & Methodologies
1 11 (55.00%) Business Intelligence
2 4 (20.00%) Analytics
2 4 (20.00%) Data Analysis
2 4 (20.00%) Project Management
3 3 (15.00%) Data Analytics
3 3 (15.00%) Data Protection
3 3 (15.00%) Process Management
3 3 (15.00%) Stakeholder Management
3 3 (15.00%) WFM
4 2 (10.00%) Business Continuity
4 2 (10.00%) CRM
4 2 (10.00%) Data Modelling
4 2 (10.00%) Disaster Recovery
4 2 (10.00%) Migration
4 2 (10.00%) PRINCE2
4 2 (10.00%) Vulnerability Management
5 1 (5.00%) Business Process Analysis
5 1 (5.00%) Dashboard Development
5 1 (5.00%) Presales
5 1 (5.00%) Task Automation
Programming Languages
1 15 (75.00%) SQL
2 6 (30.00%) T-SQL
3 4 (20.00%) VBA
4 1 (5.00%) C#
4 1 (5.00%) C++
4 1 (5.00%) Progress 4GL
4 1 (5.00%) Python
4 1 (5.00%) R
4 1 (5.00%) VB
4 1 (5.00%) VB.NET
Qualifications
1 2 (10.00%) Degree
Quality Assurance & Compliance
1 1 (5.00%) Actionable Recommendations
1 1 (5.00%) PMO
1 1 (5.00%) QA
Vendors
1 10 (50.00%) Microsoft
2 5 (25.00%) Tableau
3 3 (15.00%) Cognos
4 1 (5.00%) Oracle
Blackpool, Lancashire
D4 Digital Recruitment
Salary: Salary dependant on experience
Posted: 14 hours ago
Burnley, Lancashire
CPS Group UK
Salary: £40000 - £50000 per annum + Incredible bens
Posted: Yesterday
Chorley, Lancashire
Verticality Ltd
Salary: Salary £30-35k DOE + extensive benefits
Posted: 4 days ago
Burnley, Lancashire
Jagger Talent
Salary: From £22,000 to £26,000 per annum Dep' on experience
Posted: 3 days ago
Lancashire
Hays Specialist Recruitment Ltd
Salary: £25000.00 - £30000.00 per annum
Posted: 9 days ago
Chorley
Applause IT Ltd
Salary: £25000 - £35000 per annum
Posted: 9 days ago