Excel

Excel Advanced

Name: Excel Advanced
Availability: InStock

Build advanced Excel skills: PivotTables, VLOOKUP, conditional formatting, macros and data analysis for professional spreadsheet work.

1 day Classroom — London NW10 Live online available

Format

Live instructor-led

Hands-on, question-led sessions

Location

London NW10 or online

9 Station Terrace, NW10 5RT

Level

Advanced level

Small groups, hands-on, expert-led

Upcoming dates

Tue 1 December 2026

Live Online

£395

Book Now

Booking for a team? Want a different date?

Get team training

Invoice payment available · Prices subject to VAT

Who this course is for

This course is for experienced Excel users — such as business professionals, analysts and finance staff — who are confident with intermediate features and want to master advanced functions, automation and data analysis tools to work more efficiently with complex datasets and professional spreadsheets.

Prerequisites

You should be comfortable with Excel's intermediate features such as formulas, functions and data management, or have attended our Excel Intermediate course.

What you'll learn

Understanding Excel logical modelling, enabling you to build robust decision-based formulas that reduce errors and support confident business judgement.

How to design modern Excel formulae using dynamic arrays, XLOOKUP and spill ranges, improving speed accuracy and long-term workbook resilience.

Understanding formula auditing techniques, helping you trace dependencies identify calculation risks and explain complex Excel models to stakeholders.

How to control data entry with Excel validation rules and protection, reducing rework and improving data quality in shared team workbooks.

Understanding PivotTables for analytical reporting, enabling faster insight generation for management dashboards forecasts and operational decision making.

How to automate repetitive Excel tasks using recorded macros, saving time on routine processes and increasing personal productivity at work.

Understanding advanced Excel workflows holistically, empowering you to build maintainable scalable spreadsheets trusted across departments and projects.

Course outline

What you’ll cover

Excel Logical Modelling and Decision-Based Formulas

Building multi-condition logic using IF AND OR and structured comparisons
Handling missing values and errors cleanly using IFERROR and IFNA
Designing readable logical formulas that support long-term maintenance
Stress-testing logic to prevent silent calculation failures

Excel Dynamic Arrays and Modern Formula Design

Working confidently with dynamic array behaviour and spill ranges
Using UNIQUE SORT and SORTBY to create live analytical views
Applying XLOOKUP in flexible models without helper columns
Replacing legacy lookup patterns with modern formula structures

Excel Formula Auditing and Risk Reduction

Tracing precedents and dependents to understand complex calculation chains
Identifying circular references and unintended calculation loops
Using evaluation tools to step through formulas logically
Applying audit techniques that support review compliance and collaboration

Excel Data Validation and Controlled Data Entry

Defining validation rules to enforce structure in shared workbooks
Creating dropdown lists and custom validation messages
Highlighting invalid entries automatically for rapid correction
Combining validation with sheet protection for controlled input environments

Excel PivotTables for Analytical Reporting

Creating PivotTables from structured data models
Grouping dates values and categories for meaningful analysis
Using slicers and timelines to support interactive exploration
Designing PivotTable layouts that communicate insight clearly
Managing refresh behaviour as underlying data changes

Excel Automation with Recorded Macros

Recording macros to remove repetitive manual steps
Editing simple macro logic to improve reliability
Assigning macros to buttons and keyboard shortcuts
Understanding relative and absolute recording behaviour
Managing macro storage securely in shared files

Included

Live expert-led instruction
Practical exercises and workflow examples
Live Q and A and troubleshooting with the trainer
Follow-up support guidance

Meet your trainer

Taught by working industry experts

Nick H.

Course Trainer

Industry expert delivering this course.

Frequently asked questions

Is this Excel Advanced course suitable for me?

This course is designed for people who have experience in Excel or have already attended one of our Excel training courses or who would like to further their knowledge of best practice in the use of Excel. If you are unsure about the suitability of the course, please speak to our customer service team, who will be delighted to advise you.

How is the content taught throughout the Excel Advanced course?

Our Excel Advanced course is extremely interactive. You will be using Excel throughout the day, working through examples and live projects under the guidance of our trainer, who will be supporting you through each step.

What is the recommended number of people for the class when I attend the Excel Advanced course?

For private classes in Excel Advanced, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.

Should I attend the Excel Advanced course in person or live online?

For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.

What support is available after I attend the Excel Advanced course?

We offer ongoing support to our Excel Advanced course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.

Will I receive a certificate upon completion of my Excel Advanced course?

Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our Excel Advanced course. Our certificates note our Authorised Training Centre status.

Reviews

Just finished a bespoke course in Photoshop and AI. Learned an awful lot. My trainer was very knowledgeable and was very happy to answer lots of questions that I had throughout. Highly recommend.

Rachel P — June 2026

Gorgeous premises and lovely, knowledgeable team. I really enjoyed my course - the tutor was friendly and professional and happy to answer any questions and tailor the course.

Quadrotech — June 2026

The trainer was excellent. He kept the course interactive and engaging. The small sessions made it easy to get clarifications. The pleasant office is well situated, so easy to find and get to.

UNICEF — June 2026

Fantastic and super valuable training! Our trainer shaped the training fully to our needs, adapted, accelerated and deep diving when needed. I learned so much these past days with tangible examples.

Adobe — June 2026

The training was great, thank you. My trainer was very thorough with everything and I definitely left with new knowledge and skills. And thanks for sending the materials across.

Live Union — June 2026

Our trainer was great. Very knowledgeable and also flexible with adjusting to our very specific questions and scenarios. I learned loads and look forward to using my new Figma skills.

Adobe — June 2026

One of the better training sessions I've had in years. I highly recommend anyone who wants to learn more about Figma, but also any other Adobe Creative Cloud application, to take courses here.

Adobe — June 2026

I wish all training courses were run this well!

RPS Design — June 2026

The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

Hannah Griffiths — June 2026

First class - The trainer was extremely knowledgeable and answered all our questions.

MOD — June 2026

We found the course very useful and wished that we had more time. I was really impressed by our trainer's expertise in software that's being updated very frequently.

Baillie Gifford — May 2026

Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs.

NVIDIA — May 2026

Excellent training session with a knowledgeable instructor.

Gallagher — May 2026

Great course! Instructor went at a good pace and broke down complex functions into simple steps.

Adam W — May 2026

The trainer's knowledge was very strong and he was able to answer all my questions. Admin staff were very friendly and helpful.

VCCP — May 2026

Very helpful, informative training. Relaxed atmosphere and felt very comfortable asking questions.

The White Company — May 2026

Our trainer was very approachable and knowledgeable.

Bond Pearce — May 2026

Learnt so much - great training! Thank you

John R — May 2026

Probably the best course I have been on. Very thorough and entertaining.

Cancer Research UK — May 2026

10/10. Incredible knowledge, AMAZING hints and tips - Tony is a game changer, made everything so simple to understand but taught us so much that will really change the way we present!

Broadwick Studio — May 2026

Related courses