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.

1178

Reviews

9.7

Satisfaction

99.2%

Recommend

Microsoft Excel Adv course

Microsoft Excel Adv 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.

One Day

10:00 - 16:30 UK Time

Key Learning Points

  • Key Learning Points

  • Master VLOOKUP, INDEX, MATCH and nested formulas
  • Reduce audit risk with data validation techniques
  • Build and manage PivotTables with slicers
  • Create interactive charts linked to PivotTables
  • Automate tasks with macros and Power Query

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.

Who is this course for?

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.

Course Dates

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
No in-person dates available at the moment.
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
Media Training Ltd

Request a quote for Microsoft Excel : Advanced

All our courses are available as private, bespoke or team training.

You can customise the outline, have a group where it's just your team or enjoy a one to one session with an expert.

We can deliver the course at our centre, live online or at your choice of venue.

Fill in the form below and our team will get in touch with pricing and helpful advice to get the conversation started.

Course Dates

26th Jun 26 (Fri)


Location:Online

Places: Available

RRP: £349.00

Discount: £100.00

You Pay: £249.00 + VAT

15th Jul 26 (Wed)


Location:London Islington

Places: Available

RRP: £349.00

Discount: £70.00

You Pay: £279.00 + VAT

28th Aug 26 (Fri)


Location:Online

Places: Available

RRP: £349.00

Discount: £50.00

You Pay: £299.00 + VAT

25th Sep 26 (Fri)


Location:London Islington

Places: Available

RRP: £349.00

Discount: £20.00

You Pay: £329.00 + VAT

13th Oct 26 (Tue)


Location:Online

Places: Available

RRP: £349.00

Discount:

You Pay: £349.00 + VAT

6th Nov 26 (Fri)


Location:London Islington

Places: Available

RRP: £349.00

Discount:

You Pay: £349.00 + VAT

16th Dec 26 (Wed)


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

Career paths

Roles this course supports

People training on Microsoft Excel Adv often work in the careers below.

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.

Learn Your Way

Face to Face

Face To Face

Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.

Live Online

Live Online

Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.

Team Training

Team Training

Upskill your team together. Build your team and develop consistency, and collective confidence.

Three Steps To Success

1

Identify Your Path

Define your direction with purpose, aligning your learning journey to personal and career goals.

2

Learn With Experts

Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.

3

Earn Certification

Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.

Further Reading

Why You Should Learn Microsoft Power BI?

Microsoft Power BI turns raw data into clear, actionable insights. Find out what it can do, how businesses use it and…

8 Tips To Make You An Excel Expert

Learning Excel is always useful whether you work with data or in finance. Here are 8 tips to help you master…

How Learning Power BI can help your Career

Power BI is one of the most in-demand data skills in business. Find out what it can do, who uses it and how learning…