top of page
Computer with Graph

DATA ANALYSIS
SKILLS BOOTCAMP

- 8/9 Sessions Delivered Online Via Guided Trainer

- Covering Excel Intermediate & Advanced, VBA, Excel Dashboards, Power Pivots, Power Query & Power BI

- Support To Grow Your Career or Business

- For Cheshire/Warrington or Liverpool City Region inc Wirral, St Helens etc

- Department for Education Funded

- FREE for unemployed/self-employed*

- 90% or 70% funded for businesses (subject to business size)*

*Full eligibility below.

ECW_Logo_Primary_Navy_500w_RGB.png

Harness The Power of Data Analysis

With this funded training, you will access extensive courses that will put you at the forefront of a rapidly growing industry of data analysis. This interactive session will show you the power of Excel to design and manipulate data, be able to create formulas that not only tidy data but alert you of trends and pull information from other sources such as Database (SQL) or other Excel Spreadsheets. By the end you will know how to work with every formula, create interactive Dashboards, learn how Macros and Power Query can be used to stop repetitive commands and learn the power of Power BI to let your data come to life.

 

Our Skills Bootcamps are funded by the Department For Education, for businesses and individuals in the Cheshire/Warrington or Liverpool City Region to help up-skill in vital Digital areas. Training is FREE for unemployed/self-employed individuals and is 90% or 70% funded for existing business staff, subject to eligibility. 

At a Glance

Funded training for those looking to standout and develop their career.

Business/learner must be based in Cheshire/Warrington or Liverpool City Region and aged 19+.

Covering Excel Intermediate & Advanced, VBA, Excel Dashboards, Power Pivots, Power Query & Power BI.

8/9 sessions, delivered online over multiple weeks.

Upcoming Dates:

Cohort 1 - 3, 10, 17, 24, 31 July, 7, 8, 14 August 

Cohort 2 - 31 July, 1, 14, 21, 28 August, 4, 11, 12 Sept

Cohort 3 - 10, 17, 24 September, 1, 8, 15, 22, 23 Oct

Cohort 4 - 24, 31 October, 7, 14, 21, 28 November, 4, 5 Dec

FREE for unemployed/self-employed. 90% funded for SME employees, 70% funded for businesses with 250+ staff.

Training Duration: 8 Days

Week 1
Introduction to Data Analysis, Excel Recap and Overview of everyday features of Excel, Range Names, Introduction to Analysis Formulas, Date Functions, Formatting and working with data, Formulas for tidying up data.

Week 2

Excel Advanced Functions, Lookup and Information Functions, SubTotals, General Analysis Tools, Formulae Auditing, Pivot Tables.

Week 3

Excel VBA, Recording Macros, Visual Basic Editor, Understanding VBA, Procedures, Using Excel Objects, Creating Custom Forms, Creating Error Handling Procedures.

Week 4

Excel Dashboards, Collecting Information, Presenting Information.

Week 5

Power Query in Excel, Connection Types, Data Preparation.

Week 6

Power Pivot, Working with Multiple Table Data Sources, Key Performance Indicators, Working With Slicers, The Diagram View, Working with DAX.

Week 7 & 8 

Basic Reports, Data Sources, Query Editor, Advanced Query Editor, Multiple Tables, Parameters, Filtering Data 'Slicers', Formatting Visualisations, Maps, Calculated Columns, Measures, Calendars, Date Functions, Advanced Measures, Roles and Security, Publishing Reports, Power BI Service Overview, Using Power BI Service, Overview of Excel Tools, Overview of Other Tools.

Extra Support

Unemployed learners will receive additional employability support to kick-start their career using the skills they have learnt on the bootcamp. Upon completion, you will also receive a guaranteed interview with an employer looking for someone with your skills. 

Self-employed learners will receive support to write a business action plan to help grow their business. 

Employed learners will receive support to take on new responsibilities or a new job role within their existing employer.

analysis anchor

READY TO REGISTER YOUR INTEREST?

Whether you are looking to kick-start your career, transform your skillset or develop your workforce, our Skills Bootcamps are here to support you.

 

To register your interest, please complete our pre-enrolment form below. 

Listen to one of our incredible case studies!

bottom of page