Skip to main content

Microsoft Excel Advanced 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,210 Reviews
9.7/10 Satisfaction
99.3% Recommend
See reviews
Microsoft Excel Advanced training course

Microsoft Excel Advanced 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
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
No in-person dates available at the moment.
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

Get a quote for Microsoft Excel Advanced

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

6 November 2026

Fri

Location
London Islington
Places
Available
RRP
£349
Discount
£120
You pay
£229 + VAT

16 December 2026

Wed

Location
Online
Places
Available
RRP
£349
Discount
£100
You pay
£249 + VAT

15 January 2027

Fri

Location
London Islington
Places
Available
RRP
£349
Discount
£70
You pay
£279 + VAT

8 February 2027

Mon

Location
Online
Places
Available
RRP
£349
Discount
£50
You pay
£299 + VAT

11 March 2027

Thu

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

7 April 2027

Wed

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + VAT

5 May 2027

Wed

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

3 June 2027

Thu

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + VAT

2 July 2027

Fri

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

30 July 2027

Fri

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + VAT

23 August 2027

Mon

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

24 September 2027

Fri

Location
Online
Places
Available
RRP
£349
Discount
—
You pay
£349 + 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,210 Reviews
9.7/10 Satisfaction
99.3% Recommend

Kevin knew the topic extremely well, very positive approach and helpful even with training 2 people who had a very different level of knowl…

Kieren – 13 October 2026

Great at explaining things and lots of samples given

Laura – 5 October 2026

Kevin was incredibly knowledgeable, and able to answer all questions no matter how niche. Things which previously seemed impossible to comp…

Ben – 25 September 2026

Explanation, knowledge and how to manage time.

Gustavo – 28 August 2026

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

Lily – 15 July 2026

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 – 15 July 2026

Lots of relevant, efficiencies in building spreadsheets and analysis.

Jon – 9 July 2026

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

Kelly – 9 July 2026

Swipe for more

Read course reviews

Who attends?

Getting better at your job icon

Getting better at your job

You need a skill for the role you already have, or your employer is investing in the team.

Changing career icon

Changing career

You're moving into a new field and need the practical skills it asks for.

Just graduated icon

Just graduated

You know the theory. A practical course and a certificate of attendance show employers you can do the work.

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?