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.
If 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 | |
---|---|---|---|---|---|---|---|
18th Jul 25 | Fri | London Bridge | Available | £299.00 | £120.00 | £179.00 + VAT | |
14th Aug 25 | Thu | London Bridge | Available | £299.00 | £100.00 | £199.00 + VAT | |
8th Sep 25 | Mon | London Bridge | Available | £299.00 | £70.00 | £229.00 + VAT | |
6th Oct 25 | Mon | London Bridge | Available | £299.00 | £50.00 | £249.00 + VAT | |
7th Nov 25 | Fri | London Bridge | Available | £299.00 | £299.00 + VAT | ||
4th Dec 25 | Thu | London Bridge | Available | £299.00 | £299.00 + VAT | ||
7th Jan 26 | Wed | London Bridge | Available | £299.00 | £299.00 + VAT | ||
26th Jan 26 | Mon | London Bridge | Available | £299.00 | £299.00 + VAT | ||
27th Feb 26 | Fri | London Bridge | Available | £299.00 | £299.00 + VAT | ||
26th Mar 26 | Thu | London Bridge | Available | £299.00 | £299.00 + VAT | ||
20th Apr 26 | Mon | London Bridge | Available | £299.00 | £299.00 + VAT | ||
18th May 26 | Mon | London Bridge | Available | £299.00 | £299.00 + VAT | ||
19th Jun 26 | Fri | London Bridge | Available | £299.00 | £299.00 + VAT |
Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
---|---|---|---|---|---|---|---|
1st Aug 25 | Fri | Online | Available | £299.00 | £120.00 | £179.00 + VAT | |
27th Aug 25 | Wed | Online | Available | £299.00 | £100.00 | £199.00 + VAT | |
26th Sep 25 | Fri | Online | Available | £299.00 | £70.00 | £229.00 + VAT | |
22nd Oct 25 | Wed | Online | Available | £299.00 | £50.00 | £249.00 + VAT | |
21st Nov 25 | Fri | Online | Available | £299.00 | £299.00 + VAT | ||
15th Dec 25 | Mon | Online | Available | £299.00 | £299.00 + VAT | ||
16th Jan 26 | Fri | Online | Available | £299.00 | £299.00 + VAT | ||
11th Feb 26 | Wed | Online | Available | £299.00 | £299.00 + VAT | ||
13th Mar 26 | Fri | Online | Available | £299.00 | £299.00 + VAT | ||
6th Apr 26 | Mon | Online | Available | £299.00 | £299.00 + VAT | ||
8th May 26 | Fri | Online | Available | £299.00 | £299.00 + VAT | ||
3rd Jun 26 | Wed | Online | Available | £299.00 | £299.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.