Microsoft Excel Advanced Training
One-day Instructor Advanced Microsoft Excel Training.svg/250px-Microsoft_Office_Excel_(2025%E2%80%93present).svg.png)
Instructor-Led Excel Training
Excel Advanced
Training with an expert
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.
20+ yearsTraining experience
Level 3 of 3Advanced users
UK-wideOn-site, remote or classroom
Meet Aedan, a member of the Marketing Team
Analyse, audit and automate your data
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.
Courses & Fees
One day, two ways to book
Have our trainer visit your premises, or book individual places on a scheduled public course.
Most Popular
In-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
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
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 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.
What’s covered
A practical day, step by step
The day starts with a review of Excel’s day-to-day features, then moves through four practical modules.
1. Advanced Formulae
- Partial absolute cell references
- Data validation with input & error messages
- Nesting OR & AND within IF
- IFERROR to tidy lookup results
2. Analytical Tools & Auditing
- Goal Seek and Solver
- Creating scenarios
- Tracing precedents & dependents
- Checking for errors
3. PivotTables & Charts
- Creating & rearranging PivotTables
- Adding multiple data values
- Formatting & Slicers
- Creating pivot charts
4. Macros
- Recording a simple macro
- Editing a macro
- Absolute & relative macros
- Assigning macros to shortcuts or buttons
Every course includes
More than just a training day
Tailored Content
Built around your team’s real workplace scenarios
Expert Trainers
Instructor-led, at the pace of your attendees
Reference Materials
Handouts and supporting materials for every attendee
Certificates
Course completion certificate for each attendee
Free Aftercare
Post-course telephone & email support
Course levels
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.
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.
Or call us on 0345 450 0051 to speak with a training advisor today.