Period
to 17 November 2017

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

Microsoft Visual Basic for Applications (VBA)
Lancashire > Preston
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 45 35 34
Rank change year-on-year -10 -1 +8
Permanent jobs citing VBA 4 5 5
As % of all permanent IT jobs advertised in Preston 1.60% 2.17% 2.39%
As % of the Programming Languages category 2.40% 3.76% 3.88%
Number of salaries quoted 4 5 5
Preston median annual salary £40,000 £23,500 £31,500
Median salary % change year-on-year +70.21% -25.40% -3.08%
10th Percentile £29,325 £18,200 £24,175
90th Percentile £47,875 £35,250 £35,800
Lancashire median annual salary £32,500 £37,500 £32,500
% change year-on-year -13.33% +15.38% -

VBA is in the Programming Languages 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 coding skills.

All Programming Languages
Preston
Permanent vacancies with a requirement for coding skills 167 133 129
As % of all permanent IT jobs advertised in Preston 66.80% 57.83% 61.72%
Number of salaries quoted 135 123 113
Preston median annual salary £35,000 £32,500 £37,500
Median salary % change year-on-year +7.69% -13.33% +15.38%
10th Percentile £27,875 £22,550 £24,400
90th Percentile £48,250 £43,750 £45,000
Lancashire median annual salary £35,000 £36,500 £35,000
% change year-on-year -4.11% +4.29% -

VBA
Job Vacancy Trend in Preston

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

Job vacancy trend for VBA in Preston

VBA
Salary Trend in Preston

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

Salary trend for VBA in Preston

VBA
Salary Histogram in Preston

The salary distribution of IT jobs citing VBA in Preston over the 6 months to 17 November 2017.

Salary histogram for VBA in Preston

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

1 4 (100.00%) SQL
1 4 (100.00%) Microsoft Excel
1 4 (100.00%) Data Analysis
1 4 (100.00%) SQL Server Integration Services
1 4 (100.00%) Mathematics
1 4 (100.00%) Analytical Skills
1 4 (100.00%) Task Automation
2 3 (75.00%) Business Development
2 3 (75.00%) Telecoms
2 3 (75.00%) SQL Server Reporting Services
2 3 (75.00%) SQL Server 2005
2 3 (75.00%) Business Intelligence
2 3 (75.00%) SQL Server
3 2 (50.00%) C#
3 2 (50.00%) .NET
3 2 (50.00%) N-Tier
3 2 (50.00%) Process Management
3 2 (50.00%) Capita
3 2 (50.00%) Degree
3 2 (50.00%) Web Development
4 1 (25.00%) Finance
4 1 (25.00%) Customer-Centricity
4 1 (25.00%) Actionable Insight
4 1 (25.00%) Actionable Recommendations
4 1 (25.00%) Data Protection
4 1 (25.00%) Analytics
4 1 (25.00%) Microsoft PowerPoint
4 1 (25.00%) Back Office
4 1 (25.00%) BusinessObjects

VBA
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 4 (100.00%) Microsoft Excel
2 1 (25.00%) Microsoft PowerPoint
Database & Business Intelligence
1 4 (100.00%) SQL Server Integration Services
2 3 (75.00%) SQL Server
2 3 (75.00%) SQL Server 2005
2 3 (75.00%) SQL Server Reporting Services
3 1 (25.00%) BusinessObjects
General
1 3 (75.00%) Telecoms
2 1 (25.00%) Back Office
2 1 (25.00%) Finance
Job Titles
1 3 (75.00%) Business Intelligence Developer
1 3 (75.00%) Developer
1 3 (75.00%) Senior Business Intelligence Developer
1 3 (75.00%) Senior Developer
2 1 (25.00%) Analyst
2 1 (25.00%) Insight Analyst
Libraries, Frameworks & Software Standards
1 2 (50.00%) .NET
Miscellaneous
1 4 (100.00%) Analytical Skills
2 2 (50.00%) N-Tier
Processes & Methodologies
1 4 (100.00%) Data Analysis
1 4 (100.00%) Mathematics
1 4 (100.00%) Task Automation
2 3 (75.00%) Business Development
2 3 (75.00%) Business Intelligence
3 2 (50.00%) Process Management
3 2 (50.00%) Web Development
4 1 (25.00%) Actionable Insight
4 1 (25.00%) Analytics
4 1 (25.00%) Customer-Centricity
4 1 (25.00%) Data Protection
Programming Languages
1 4 (100.00%) SQL
2 2 (50.00%) C#
Qualifications
1 2 (50.00%) Degree
Quality Assurance & Compliance
1 1 (25.00%) Actionable Recommendations
Vendors
1 2 (50.00%) Capita