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 · Advanced

Excel Advanced

Analyse, audit and automate your data

A hands-on, one-day Excel course for experienced users: analyse data with PivotTables, what-if tools and macros, at your premises or at our UK classrooms.

Length1 day
LevelAdvanced
FormatsIn-house · 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 Advanced course

This one-day instructor-led course is designed to give delegates the ability to analyse data in a variety of ways.

By the end of the course delegates will be able to use Excel’s built-in tools to compare data and create projections, and to understand and use the macro facility of Excel.

  • Analyse data using PivotTables and charts
  • Develop solutions to what-if scenarios
  • Verify calculations and trace errors with auditing
  • Automate routine tasks with macros
PivotTables & Slicers

Summarise and rearrange data with PivotTables and pivot charts.

What-If Analysis

Goal Seek, Solver and scenario tools for projections.

Auditing Tools

Trace precedents and dependents and check for errors.

Macros

Record, edit and assign macros to buttons and shortcuts.

Course outline

What the day covers

4 modules · tailored to your team on in-house courses
Advanced Formulae4 topics
  • Partial absolute cell references
  • Data validation with input & error messages
  • Nesting OR & AND within IF
  • IFERROR to tidy lookup results
Analytical Tools & Auditing4 topics
  • Goal Seek and Solver
  • Creating scenarios
  • Tracing precedents & dependents
  • Checking for errors
PivotTables & Charts4 topics
  • Creating & rearranging PivotTables
  • Adding multiple data values
  • Formatting & Slicers
  • Creating pivot charts
Macros4 topics
  • Recording a simple macro
  • Editing a macro
  • Absolute & relative macros
  • Assigning macros to shortcuts or buttons
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

£245+ 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 experienced Excel users who have completed the Excel Intermediate course or have equivalent knowledge. Delegates should already be able to create detailed worksheets using complex formulas, and be familiar with absolute cell references and conditional functions.

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
Thursday 22 October9:30am to 4:30pm Liverpool £245 + VAT per delegate Request a place
Thursday 29 October9:30am to 4:30pm Leeds £245 + VAT per delegate Request a place
Thursday 5 November9:30am to 4:30pm London £245 + VAT per delegate Request a place
Thursday 5 November9:30am to 4:30pm Manchester £245 + VAT per delegate Request a place
Thursday 12 November9:30am to 4:30pm Preston £245 + VAT per delegate Request a place
Thursday 12 November9:30am to 4:30pm Remote (Teams) £245 + VAT per delegate Request a place
Thursday 19 November9:30am to 4:30pm Liverpool £245 + VAT per delegate Request a place
Thursday 26 November9:30am to 4:30pm Leeds £245 + VAT per delegate Request a place
Wednesday 6 January9:30am to 4:30pm Manchester £245 + VAT per delegate Request a place
Friday 8 January9:30am to 4:30pm London £245 + 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