Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

The intent of the Advanced Excel course is to equip employed learners with advanced Excel capabilities to design reliable data models, automate data preparation with Power Query, apply dynamic formulas, carry out scenario modelling (Goal Seek & Solver), and present insights using advanced PivotTables and Pivot Charts. Learners will be able to independently build repeatable, auditable analyses and professional reports.

Benefits to Employees
•	Repeatable, standardised reporting and dashboards built on structured tables and queries.
•	Reduced manual effort via automation (Power Query) and consistent formula patterns.
•	Faster, evidence-based decisions through clear Pivot analyses and scenario modelling.
•	Demonstrable upskilling of staff in advanced digital tools relevant to the business.

Benefits to Employers
•	Clearer, more reliable management information and reports.
•	Improved productivity through time-saving techniques and reduced data errors.
•	Consistency in spreadsheet standards across teams and functions.

Course Duration: Half a Day 
Learner Group: Employed in the workplace

Delivery: The course can be delivered either face-to-face onsite or remotely via Teams, depending on what works best for the business and learners
Session length: 
This course is designed to be approximately 4 hours
Can be delivered AM/PM delivery: 09:00 – 13:00 or 13:00 – 17:00

The course can be contextualised to the requirements of the employer to embed their own systems and processes.

Learning Objectives

Employees will be able to carry out the following functions:
•	Build PivotTables and Pivot Charts to quickly summarise and explore data.
•	Use XLOOKUP to find the information they need from spreadsheets.
•	Use INDEX/MATCH and XMATCH to look up data in more flexible ways.
•	Use IFERROR and ISERROR to fix and prevent common formula errors.
•	Use Power Query to bring data together, clean it up, and prepare it for analysis.
•	Try different scenarios to see how changes in data affect results.

Funding Option

Funding Eligibility

This course is part of our Skills Development Service.

To be eligible for this training, you must be:

•	19 years old or over 
•	Employed, volunteering or an unpaid worker.
•	Have the right to live and work in the UK. 
•	You must not already have achieved a level 2 qualification, in this subject, in the last 3 years.

This support is available for those living in Greater Manchester or one of the neighbouring areas. These include parts of Lancashire, Derbyshire, Merseyside, West Yorkshire, and Cheshire – your eligibility will be checked by one of our Skills Coaches

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

Will require access to a device with Microsoft Office Installed

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill