Training advisors available Mon–Fri, 9am to 5pm train@keystraining.com Public course dates
Speak to an advisor0345 450 0051 Build a quote
Microsoft 365 & Copilot · Intermediate

Excel Intermediate

Take your Excel skills further

A hands-on, one-day Excel course for existing users: delivered at your premises, remotely or at our UK classrooms, and tailored to how your team works.

Length1 day
LevelIntermediate
FormatsIn-house · Live online · Public
Group sizeUp to 4 per group
Get a quote for your team See 20 public dates
Level 1IntroductionLevel 2IntermediateLevel 3AdvancedLevel 3VBA
Overview

About the Excel Intermediate course

This one-day instructor-led course is designed to develop the practical skills of existing Excel users.

By the end of the course delegates will be able to use a much greater range of Excel functions and tools to produce more effective spreadsheets, and to work confidently with large sets of data.

  • Use advanced formulas and functions
  • Define names for cells and ranges
  • Use Excel’s database tools
  • Work effectively with large spreadsheets
IF & XLOOKUP

Master IF functions, XLOOKUP and nested functions.

Sorting & Filtering

Sort, filter and subtotal large sets of data.

Linking & Protecting

Link workbooks and apps, name ranges and protect cells.

Smart Formatting

Conditional formatting, grouping and hiding data.

Course outline

What the day covers

4 modules · tailored to your team on in-house courses
Functions4 topics
  • IF functions
  • XLOOKUP (replaces VLOOKUP & HLOOKUP)
  • Combining data from multiple cells
  • Data & nested functions
Tools4 topics
  • Naming cells and ranges
  • Protecting cells
  • Linking workbooks
  • Linking Excel with Word or PowerPoint
Database Tools4 topics
  • Sorting, including custom sequences
  • AutoFilter & advanced filters
  • Data forms to enter, delete & search
  • Subtotals for sub sets of data
Formatting3 topics
  • Hiding columns, rows and formulas
  • Grouping columns and rows
  • Conditional number formatting
Courses & fees

Ways to book this course

Most popularIn-House

At Your Premises

£545+ VAT
One-day onsite · up to 4 people
  • Instructor-led at your location
  • Additional attendees £35 + VAT each
  • Printed materials & trainer travel included
  • About £75 + VAT per person when 10 attend
Request a quote
Public Course

Classroom Place

£225+ VAT
One-day classroom · per delegate
  • Preston, Liverpool, Manchester & London
  • Small groups with 1-to-1 support
  • Reference manual & certificate included
View dates

Public course prices are per delegate. Book 2 or more delegates on the same course and receive significant discounts. Course tailoring for onsite courses is available for a small additional fee.

Is it right for you?

Who the course is for

Before you attend

This course is designed for delegates who have completed the Excel Introduction course or have equivalent knowledge. Attendees should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT, and know the difference between relative and absolute references.

Public course dates

Join a scheduled course

One-day courses, 9:30am to 4:30pm, with refreshments, lunch, reference materials and a certificate. Book 2 or more places for a discount.

DateVenuePriceBook
Wednesday 21 October9:30am to 4:30pm Liverpool £225 + VAT per delegate Request a place
Wednesday 28 October9:30am to 4:30pm Leeds £225 + VAT per delegate Request a place
Wednesday 4 November9:30am to 4:30pm London £225 + VAT per delegate Request a place
Wednesday 4 November9:30am to 4:30pm Manchester £225 + VAT per delegate Request a place
Wednesday 11 November9:30am to 4:30pm Preston £225 + VAT per delegate Request a place
Wednesday 11 November9:30am to 4:30pm Remote (Teams) £225 + VAT per delegate Request a place
Wednesday 18 November9:30am to 4:30pm Liverpool £225 + VAT per delegate Request a place
Wednesday 25 November9:30am to 4:30pm Leeds £225 + VAT per delegate Request a place
Tuesday 5 January9:30am to 4:30pm Manchester £225 + VAT per delegate Request a place
Thursday 7 January9:30am to 4:30pm London £225 + VAT per delegate Request a place

All 20 dates for this course

Every course includes

More than just a training day

Dedicated account managerOne named contact who knows your organisation and your history with us.
Pre-course evaluationFree skills check forms so every delegate lands on the right level.
Course tailoringWe plan and customise closed courses around your roles, systems and files.
CertificatesA Keys Training certificate for every attendee, for training records and ESR.
Management feedbackPost-course feedback reviews so you can see what landed.
Free aftercareTelephone and email support for every delegate after the course.
Good to know

Frequently asked questions

Not sure this is the right level?

Download our free pre-course evaluation form (PDF) and a member of our team will recommend the right level for each attendee, or explore the other levels below.

Level 1: IntroductionLevel 2: IntermediateLevel 3: AdvancedAll Excel Training

Ready to get your team Excel-confident?

View upcoming scheduled dates, or speak with a training advisor to arrange a tailored course for your team.

View Scheduled DatesEmail an Enquiry

Or call us on 0345 450 0051 to speak with a training advisor today.

Keep going

Courses that pair well with this one

All microsoft 365 courses

Get your team trained properly.

Tell us the course, rough numbers and where you are. A training advisor will reply within one working day with options and a fixed fee.

Build your quote or call a training advisor0345 450 0051
From£545 + VAT per group of up to 4Get a quote
View quote