Microsoft Excel Adv Course
Take the ultimate deep dive into Excel. Learn advanced features such as pivot tables and VLOOKUP to help analyse and summarise large datasets.
Perform more complex data analysis to help you make informed business decisions. Discover techniques to reduce audit risk by ensuring data accuracy and integrity.
Enhance your ability to manage and manipulate data effectively, saving time and increasing productivity. This course will give you the advanced Excel skills necessary to excel in your professional career.
Use nested formulas, VLOOKUP and INDEX/MATCH
Reduce audit risk with data validation and checking
Analyse data quickly with PivotTables and slicers
Model scenarios with Goal Seek and What If tools
Work faster with advanced shortcuts and techniquesIf attending an online course you must have a licensed copy of any software required and access to a suitable computer.
You'll need to have attended our Excel Intro and Intermediate courses or have equivalent working knowledge before joining this class.
Course leader is an experienced industry expert
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 26 | Fri | Online | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 15th Jul 26 | Wed | London Islington | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 28th Aug 26 | Fri | Online | Available | £349.00 | £50.00 | £299.00 + VAT | |
| 25th Sep 26 | Fri | London Islington | Available | £349.00 | £20.00 | £329.00 + VAT | |
| 13th Oct 26 | Tue | Online | Available | £349.00 | £349.00 + VAT | ||
| 6th Nov 26 | Fri | London Islington | Available | £349.00 | £349.00 + VAT | ||
| 16th Dec 26 | Wed | Online | Available | £349.00 | £349.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 15th Jul 26 | Wed | London Islington | Available | £349.00 | £70.00 | £279.00 + VAT | |
| 25th Sep 26 | Fri | London Islington | Available | £349.00 | £20.00 | £329.00 + VAT | |
| 6th Nov 26 | Fri | London Islington | Available | £349.00 | £349.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 26th Jun 26 | Fri | Online | Available | £349.00 | £100.00 | £249.00 + VAT | |
| 28th Aug 26 | Fri | Online | Available | £349.00 | £50.00 | £299.00 + VAT | |
| 13th Oct 26 | Tue | Online | Available | £349.00 | £349.00 + VAT | ||
| 16th Dec 26 | Wed | Online | Available | £349.00 | £349.00 + VAT |
Using Nesting formulas
Using AND & OR
VLOOKUP
IFERROR/IFNA
INDEX & MATCH
Data validation
Using Trace Precedents
Using Trace Dependents
Removing Arrows
Error checking
Evaluate Formula
Creating Pivot Tables
Changing the look of your pivot
Grouping your data
Updating Pivot Tables with new data
Filtering your data with a Slicer
Linking slicers to more than one Pivot Table
Using a timeline
Creating a Pivot chart
Goal Seek
Scenarios
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Upskill your team together. Build your team and develop consistency, and collective confidence.
Define your direction with purpose, aligning your learning journey to personal and career goals.
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
Automate Excel with VBA macros, custom functions and user forms on this two-day course…
From £1,198 + VAT
Turn raw data into clear, interactive dashboards and reports with Power BI. A two-day…
From £599 + VAT
Quickly and easily create professional, engaging presentations using PowerPoint. Learn…
From £249 + VAT
Get up and running in Microsoft Excel on this practical one-day introduction course…
From £279 + VAT
