Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

The Intermediate Excel course equips employed learners with practical, workplace-focused skills beyond the basics. Learners develop competence with structured data tables, intermediate formulas (IF, SUMIFS/COUNTIFS, lookup techniques), conditional formatting, data validation, PivotTables, and charts. The course emphasises accuracy, efficiency, and clear reporting.

Benefits to Employees
•	Increased confidence to manage and analyse spreadsheets independently.
•	Ability to use intermediate formulas and tools to speed up tasks and improve accuracy.
•	Competence creating clear, professional reports with tables, PivotTables and charts.
•	Transferable digital skills that support career progression.

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:
•	Organise and clean data using Excel Tables and Named Ranges
•	Find data quickly using VLOOKUP/XLOOKUP and INDEX–MATCH
•	Use common formulas like IF, SUMIFS, and COUNTIFS
•	Summarise data with PivotTables and create simple charts
•	Work faster using time-saving Excel tools
•	Highlight important data with Conditional Formatting
•	Control data entry using drop-down lists and rules

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