Master advanced Excel techniques for professional-level data analysis. Optimise spreadsheet management, enhance analytical skills and gain insights with our expert-led training.
1 day course 10am - 5pm Live Online or Classroom-based
What you will 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.
Related Courses
This Excel Advanced course includes
-
Authorised Certificate
-
Lifetime support after your course
-
Course materials
-
Live Instructor-led training
-
Refreshments all day
-
Latest Mac or PC ready to go
-
Authorised Trainers
-
Hands-on exercises
Course Dates
| Date | Location | Price (ex VAT) | |
|---|---|---|---|
| Wed 1 Jul 2026 | London |
£375
|
|
| Mon 3 Aug 2026 | Live Online |
£375
|
|
| Wed 2 Sep 2026 | London |
£375
|
|
| Thu 1 Oct 2026 | Live Online |
£375
|
|
| Mon 2 Nov 2026 | London |
£395
|
|
| Tue 1 Dec 2026 | Live Online |
£395
|
Video success stories
Course Outline for Excel Advanced
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
FAQs about the Excel Advanced course
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.
Excel Advanced — Team and Bespoke Training
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Book NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Book Now
Our Clients
Latest Blog Articles
10 Excel functions you might not know and how to use them
Google Guide to Generative AI: Tips for UX Designers and Content Teams
Claude Connectors: What Every Creative Professional Should KnowWhy Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact requirements.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.