Period
to 17 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Wales 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
UK > Wales
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 101 111 87
Rank change year-on-year +10 -24 -18
Permanent jobs citing Microsoft Excel 36 44 64
As % of all permanent IT jobs advertised in Wales 1.86% 1.82% 2.45%
As % of the Applications category 24.16% 29.93% 24.24%
Number of salaries quoted 25 34 60
Wales median annual salary £27,000 £28,500 £28,500
Median salary % change year-on-year -5.26% - -17.39%
10th Percentile £19,550 £22,378 £18,250
90th Percentile £36,650 £38,025 £51,250
UK median annual salary £40,000 £37,500 £37,500
% change year-on-year +6.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 Wales with a requirement for software application skills.

All Software Application Skills
Wales
Permanent vacancies with a requirement for software application skills 149 147 264
As % of all permanent IT jobs advertised in Wales 7.68% 6.10% 10.09%
Number of salaries quoted 112 128 230
Wales median annual salary £30,000 £28,500 £32,500
Median salary % change year-on-year +5.26% -12.31% -
10th Percentile £19,290 £20,000 £18,500
90th Percentile £44,875 £42,075 £51,250
UK median annual salary £37,500 £37,000 £37,500
% change year-on-year +1.35% -1.33% +7.14%

Microsoft Excel
Job Vacancy Trend in Wales

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

Job vacancy trend for Microsoft Excel in Wales

Microsoft Excel
Salary Trend in Wales

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

Salary trend for Microsoft Excel in Wales

Microsoft Excel
Salary Histogram in Wales

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

Salary histogram for Microsoft Excel in Wales

Microsoft Excel
Job Locations in Wales

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

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
South Wales +13 19 £27,000 -6.90% 16
Mid Wales - 8 - - 1
West Wales +5 5 £27,000 +2.86%
North Wales -5 4 £35,000 +22.81% 4
Microsoft Excel
UK

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 Wales region with a requirement for Microsoft Excel.

1 21 (58.33%) Microsoft
2 14 (38.89%) Microsoft Office
2 14 (38.89%) Analytical Skills
3 12 (33.33%) SQL
4 11 (30.56%) Business Intelligence
5 10 (27.78%) SQL Server
5 10 (27.78%) Management Information System
5 10 (27.78%) Finance
5 10 (27.78%) Continuous Improvement
5 10 (27.78%) Power BI
6 8 (22.22%) Budgeting and Forecasting
6 8 (22.22%) Performance Monitoring
6 8 (22.22%) Trend Analysis
6 8 (22.22%) Microsoft PowerPoint
6 8 (22.22%) Financial Modelling
6 8 (22.22%) Law
6 8 (22.22%) Risk Management
7 7 (19.44%) VBA
8 6 (16.67%) Data Warehouse
8 6 (16.67%) Data Quality
9 5 (13.89%) Data Cleansing
9 5 (13.89%) Spreadsheet
9 5 (13.89%) Data Analysis
9 5 (13.89%) Degree
10 4 (11.11%) Project Management
10 4 (11.11%) T-SQL
10 4 (11.11%) Microsoft Project
10 4 (11.11%) Data Protection
10 4 (11.11%) Service Delivery
10 4 (11.11%) Analytics

Microsoft Excel
Co-occurring IT Skills in Wales 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 14 (38.89%) Microsoft Office
2 8 (22.22%) Microsoft PowerPoint
3 5 (13.89%) Spreadsheet
4 4 (11.11%) Microsoft Project
5 3 (8.33%) MS Visio
6 1 (2.78%) Adobe Creative Suite
6 1 (2.78%) Adobe Illustrator
6 1 (2.78%) InDesign
6 1 (2.78%) Photoshop
Business Applications
1 1 (2.78%) Dynamics CRM
Cloud Services
1 3 (8.33%) Microsoft Azure
Communications & Networking
1 2 (5.56%) 802.11
1 2 (5.56%) BGP
1 2 (5.56%) Broadband
1 2 (5.56%) DHCP
1 2 (5.56%) Ethernet
1 2 (5.56%) GPON
1 2 (5.56%) MPLS
1 2 (5.56%) OSPF
1 2 (5.56%) RSVP
1 2 (5.56%) SNMP
1 2 (5.56%) VRRP
2 1 (2.78%) SMS
Database & Business Intelligence
1 10 (27.78%) Power BI
1 10 (27.78%) SQL Server
2 6 (16.67%) Data Warehouse
3 3 (8.33%) MS Access
3 3 (8.33%) QlikView
3 3 (8.33%) SQL Server Reporting Services
4 2 (5.56%) SQL Server 2016
5 1 (2.78%) PowerPivot
5 1 (2.78%) SQL Server 2008
5 1 (2.78%) SQL Server Integration Services
Development Applications
1 1 (2.78%) Dreamweaver
1 1 (2.78%) SQL Server Management Studio (SSMS)
General
1 10 (27.78%) Finance
2 8 (22.22%) Law
3 2 (5.56%) Legal
3 2 (5.56%) Telecoms
4 1 (2.78%) Manufacturing
4 1 (2.78%) Marketing
Job Titles
1 18 (50.00%) Analyst
2 8 (22.22%) Data Analyst
3 6 (16.67%) Support Analyst
4 5 (13.89%) Technical Support
5 4 (11.11%) Technical Analyst
5 4 (11.11%) Technical Support Analyst
6 3 (8.33%) Junior
7 2 (5.56%) Coordinator
7 2 (5.56%) Data Migration Analyst
7 2 (5.56%) Development Analyst
7 2 (5.56%) Development Support Analyst
7 2 (5.56%) Junior Analyst
7 2 (5.56%) Migration Analyst
7 2 (5.56%) Project Coordinator
7 2 (5.56%) Project Management Officer
7 2 (5.56%) Project Officer
7 2 (5.56%) Systems Analyst
7 2 (5.56%) Systems Development Analyst
7 2 (5.56%) Systems Support
7 2 (5.56%) Systems Support Analyst
Libraries, Frameworks & Software Standards
1 3 (8.33%) .NET
2 2 (5.56%) 802.1X
3 1 (2.78%) CSS
3 1 (2.78%) HTML
Miscellaneous
1 14 (38.89%) Analytical Skills
2 10 (27.78%) Management Information System
3 3 (8.33%) Data Structures
4 2 (5.56%) Computer Science
5 1 (2.78%) Driving Licence
5 1 (2.78%) e-Learning
5 1 (2.78%) Social Media
5 1 (2.78%) User Experience
Operating Systems
1 2 (5.56%) Linux
2 1 (2.78%) Windows
2 1 (2.78%) Windows 7
2 1 (2.78%) Windows Server
2 1 (2.78%) Windows Server 2003
2 1 (2.78%) Windows Server 2008
Processes & Methodologies
1 11 (30.56%) Business Intelligence
2 10 (27.78%) Continuous Improvement
3 8 (22.22%) Budgeting and Forecasting
3 8 (22.22%) Financial Modelling
3 8 (22.22%) Performance Monitoring
3 8 (22.22%) Risk Management
3 8 (22.22%) Trend Analysis
4 5 (13.89%) Data Analysis
4 5 (13.89%) Data Cleansing
5 4 (11.11%) Analytics
5 4 (11.11%) Data Protection
5 4 (11.11%) Project Management
5 4 (11.11%) Service Delivery
6 3 (8.33%) Data Extraction
6 3 (8.33%) Data Migration
6 3 (8.33%) Database Tuning
6 3 (8.33%) Migration
6 3 (8.33%) Performance Tuning
6 3 (8.33%) Visualisation
7 2 (5.56%) Time Management
Programming Languages
1 12 (33.33%) SQL
2 7 (19.44%) VBA
3 4 (11.11%) T-SQL
4 3 (8.33%) C#
5 2 (5.56%) VB
Qualifications
1 5 (13.89%) Degree
Quality Assurance & Compliance
1 6 (16.67%) Data Quality
2 3 (8.33%) PMO
2 3 (8.33%) SLA
3 2 (5.56%) GDPR
System Software
1 2 (5.56%) Active Directory
Systems Management
1 1 (2.78%) Systems Management Server (SMS)
Vendors
1 21 (58.33%) Microsoft
2 1 (2.78%) Adobe
2 1 (2.78%) Salesforce.com
2 1 (2.78%) Tableau