Skip to main content

Microsoft Excel Adv Course

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.

1,197 Reviews
9.7/10 Satisfaction
99.2% Recommend
See reviews
Microsoft Excel Adv training course

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.

New to Excel?

Our Microsoft Excel Introduction course covers the essentials.

To automate Excel using VBA, see our Excel VBA course.

View course outline

Course Dates

Course Dates Days Location Places RRP Discount You Pay
28th Aug 26 Fri Online Available £349.00 £120.00 £229.00 + VAT
25th Sep 26 Fri London Islington Available £349.00 £100.00 £249.00 + VAT
13th Oct 26 Tue Online Available £349.00 £70.00 £279.00 + VAT
6th Nov 26 Fri London Islington Available £349.00 £50.00 £299.00 + VAT
16th Dec 26 Wed Online Available £349.00 £349.00 + VAT
15th Jan 27 Fri London Islington Available £349.00 £349.00 + VAT
8th Feb 27 Mon Online Available £349.00 £349.00 + VAT
11th Mar 27 Thu London Islington Available £349.00 £349.00 + VAT
7th Apr 27 Wed Online Available £349.00 £349.00 + VAT
5th May 27 Wed London Islington Available £349.00 £349.00 + VAT
3rd Jun 27 Thu Online Available £349.00 £349.00 + VAT
2nd Jul 27 Fri London Islington Available £349.00 £349.00 + VAT
30th Jul 27 Fri Online Available £349.00 £349.00 + VAT
No in-person dates available at the moment.
Course Dates Days Location Places RRP Discount You Pay
25th Sep 26 Fri London Islington Available £349.00 £100.00 £249.00 + VAT
6th Nov 26 Fri London Islington Available £349.00 £50.00 £299.00 + VAT
15th Jan 27 Fri London Islington Available £349.00 £349.00 + VAT
11th Mar 27 Thu London Islington Available £349.00 £349.00 + VAT
5th May 27 Wed London Islington Available £349.00 £349.00 + VAT
2nd Jul 27 Fri London Islington Available £349.00 £349.00 + VAT
Course Dates Days Location Places RRP Discount You Pay
28th Aug 26 Fri Online Available £349.00 £120.00 £229.00 + VAT
13th Oct 26 Tue Online Available £349.00 £70.00 £279.00 + VAT
16th Dec 26 Wed Online Available £349.00 £349.00 + VAT
8th Feb 27 Mon Online Available £349.00 £349.00 + VAT
7th Apr 27 Wed Online Available £349.00 £349.00 + VAT
3rd Jun 27 Thu Online Available £349.00 £349.00 + VAT
30th Jul 27 Fri Online Available £349.00 £349.00 + VAT

Private & team training

Request a quote for Microsoft Excel Adv

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.

Course dates

Swipe for more dates

28th Aug 26

Fri

Location
Online
Places
Available
RRP
£349.00
Discount
£120.00
You pay
£229.00 + VAT

25th Sep 26

Fri

Location
London Islington
Places
Available
RRP
£349.00
Discount
£100.00
You pay
£249.00 + VAT

13th Oct 26

Tue

Location
Online
Places
Available
RRP
£349.00
Discount
£70.00
You pay
£279.00 + VAT

6th Nov 26

Fri

Location
London Islington
Places
Available
RRP
£349.00
Discount
£50.00
You pay
£299.00 + VAT

16th Dec 26

Wed

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

15th Jan 27

Fri

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

8th Feb 27

Mon

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

11th Mar 27

Thu

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

7th Apr 27

Wed

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

5th May 27

Wed

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

3rd Jun 27

Thu

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

2nd Jul 27

Fri

Location
London Islington
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

30th Jul 27

Fri

Location
Online
Places
Available
RRP
£349.00
Discount
You pay
£349.00 + VAT

Course Outline

1

Expanding your functions toolbox

Using Nesting formulas

Using AND & OR

VLOOKUP

IFERROR/IFNA

INDEX & MATCH

2

Reducing your audit risk

Data validation

Using Trace Precedents

Using Trace Dependents

Removing Arrows

Error checking

Evaluate Formula

3

Effectively analysing your data

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

4

Using What If Analysis

Goal Seek

Scenarios

1,197 Reviews
9.7/10 Satisfaction
99.2% Recommend

She was incrediblty insightful andf indepth - we went over lots of things and coverfed ground thats appropriate for our work. I found today…

Lily – 15th July 26

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…

Chloe – 15th July 26

Lots of relevant, efficiencies in building spreadsheets and analysis.

Jon – 9th July 26

Training was very thorough and enjoyable. Answered all my questions and used my real life example to help me understand further.

Kelly – 9th July 26

Very thorough, helpful to have data to work with and practice. Took on board real life examples we gave and showed how we could apply it.

Heather – 9th July 26

Asking what we would like to gain. Going over things we got stuck on and explaining it thoroughly

Martha – 26th June 26

Giving information on how to do things that were specific to our job roles as well as general advanced level knowledge

Joanne – 26th June 26

Kevin was really knowledgeable and worked through any problems with us. I found the whole course really helpful and hope to use what i have…

Christine – 26th June 26

Swipe for more

Read course reviews

Who attends?

Career Progressives icon

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Career Changers icon

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Graduates icon

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Further Reading

8 Tips To Make You An Excel Expert article image

8 Tips To Make You An Excel Expert

Learning Excel is always useful whether you work with data or in finance.

Why You Should Learn Microsoft Power BI? article image

Why You Should Learn Microsoft Power BI?

Microsoft Power BI turns raw data into clear, actionable insights.

Ways To Make Your PowerPoint Presentation Stand Out article image

Ways To Make Your PowerPoint Presentation Stand Out

Looking to impress your audience with amazing Powerpoint design presentation skills?