6 November 2026
Fri
Go further with Excel on this advanced one-day course for experienced users.
Covering nested formulas, PivotTables, macros, Power Query and data validation.
Go further with Excel on this advanced one-day course for experienced users. Covering nested formulas, PivotTables, macros, Power Query and data validation.
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.
New to Excel?
Our Microsoft Excel Introduction course covers the essentials.
To automate Excel using VBA, see our Excel VBA course.
| Course dates | Days | Location | Places | RRP | Discount | You pay | |
|---|---|---|---|---|---|---|---|
| 6 November 2026 | Fri | London Islington | Available | £349 | £120 | £229 + VAT | |
| 16 December 2026 | Wed | Online | Available | £349 | £100 | £249 + VAT | |
| 15 January 2027 | Fri | London Islington | Available | £349 | £70 | £279 + VAT | |
| 8 February 2027 | Mon | Online | Available | £349 | £50 | £299 + VAT | |
| 11 March 2027 | Thu | London Islington | Available | £349 | £349 + VAT | ||
| 7 April 2027 | Wed | Online | Available | £349 | £349 + VAT | ||
| 5 May 2027 | Wed | London Islington | Available | £349 | £349 + VAT | ||
| 3 June 2027 | Thu | Online | Available | £349 | £349 + VAT | ||
| 2 July 2027 | Fri | London Islington | Available | £349 | £349 + VAT | ||
| 30 July 2027 | Fri | Online | Available | £349 | £349 + VAT | ||
| 23 August 2027 | Mon | London Islington | Available | £349 | £349 + VAT | ||
| 24 September 2027 | Fri | Online | Available | £349 | £349 + VAT |
| Course dates | Days | Location | Places | RRP | Discount | You pay | |
|---|---|---|---|---|---|---|---|
| 6 November 2026 | Fri | London Islington | Available | £349 | £120 | £229 + VAT | |
| 15 January 2027 | Fri | London Islington | Available | £349 | £70 | £279 + VAT | |
| 11 March 2027 | Thu | London Islington | Available | £349 | £349 + VAT | ||
| 5 May 2027 | Wed | London Islington | Available | £349 | £349 + VAT | ||
| 2 July 2027 | Fri | London Islington | Available | £349 | £349 + VAT | ||
| 23 August 2027 | Mon | London Islington | Available | £349 | £349 + VAT |
| Course dates | Days | Location | Places | RRP | Discount | You pay | |
|---|---|---|---|---|---|---|---|
| 16 December 2026 | Wed | Online | Available | £349 | £100 | £249 + VAT | |
| 8 February 2027 | Mon | Online | Available | £349 | £50 | £299 + VAT | |
| 7 April 2027 | Wed | Online | Available | £349 | £349 + VAT | ||
| 3 June 2027 | Thu | Online | Available | £349 | £349 + VAT | ||
| 30 July 2027 | Fri | Online | Available | £349 | £349 + VAT | ||
| 24 September 2027 | Fri | Online | Available | £349 | £349 + VAT |
Private & team training
Available as private, bespoke or team training at our centre, live online, or at your venue. Customise the outline, train as a group, or book a one-to-one with an expert.
Swipe for more dates
Fri
Wed
Fri
Mon
Thu
Wed
Wed
Thu
Fri
Fri
Mon
Fri
Private & team training
Available as private, bespoke or team training at our centre, live online, or at your venue. Customise the outline, train as a group, or book a one-to-one with an expert.
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
For experienced Excel users in finance, data analysis and operations who want to master advanced formulas, PivotTables and automation. Requires our Excel Intro and Intermediate courses or equivalent.
Kevin knew the topic extremely well, very positive approach and helpful even with training 2 people who had a very different level of knowl…
Great at explaining things and lots of samples given
Kevin was incredibly knowledgeable, and able to answer all questions no matter how niche. Things which previously seemed impossible to comp…
Explanation, knowledge and how to manage time.
She was incrediblty insightful andf indepth - we went over lots of things and coverfed ground thats appropriate for our work. I found today…
Very good at using examples and there was a great mixture between learning and practice which means I can effectively go back and use this…
Lots of relevant, efficiencies in building spreadsheets and analysis.
Training was very thorough and enjoyable. Answered all my questions and used my real life example to help me understand further.
Swipe for more
Read course reviews
You need a skill for the role you already have, or your employer is investing in the team.
You're moving into a new field and need the practical skills it asks for.
You know the theory. A practical course and a certificate of attendance show employers you can do the work.
Learning Excel is always useful whether you work with data or in finance.
Microsoft Power BI turns raw data into clear, actionable insights.
Looking to impress your audience with amazing Powerpoint design presentation skills?