Microsoft Excel Adv

Gain the confidence to tackle complex challenges and scenarios in Excel.

Learn time-saving hints and tips from professional Microsoft Excel experts.

572

Reviews

9.6

Satisfaction

98.6%

Recommend
Communal3

Microsoft Excel Adv

Microsoft Excel Adv

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.

Duration icon

One Day

Timings icon

10:00 - 16:30 GMT

  • Key Learning Points

  • icon Expanded functions for advanced calculations
  • icon Minimise audit risk with data validation
  • icon Analyse data efficiently with Pivot Tables
  • icon What If Analysis with Goal Seek and Scenarios
  • icon Clever time saving techniques

You'll need to have attended our Excel Intro and Intermediate courses or have equivalent working knowledge before joining this class.

Our Expert Team
Expert Trainers

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
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
Media Training

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

18th Jul 25 (Fri)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £120.00

You Pay: £179.00 + VAT
1st Aug 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount: £120.00

You Pay: £179.00 + VAT
14th Aug 25 (Thu)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £100.00

You Pay: £199.00 + VAT
27th Aug 25 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount: £100.00

You Pay: £199.00 + VAT
8th Sep 25 (Mon)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £70.00

You Pay: £229.00 + VAT
26th Sep 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount: £70.00

You Pay: £229.00 + VAT
6th Oct 25 (Mon)

Location:London Bridge

Places: Available

RRP: £299.00

Discount: £50.00

You Pay: £249.00 + VAT
22nd Oct 25 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount: £50.00

You Pay: £249.00 + VAT
7th Nov 25 (Fri)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
21st Nov 25 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
4th Dec 25 (Thu)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
15th Dec 25 (Mon)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
7th Jan 26 (Wed)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
16th Jan 26 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
26th Jan 26 (Mon)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
11th Feb 26 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
27th Feb 26 (Fri)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
13th Mar 26 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
26th Mar 26 (Thu)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
6th Apr 26 (Mon)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
20th Apr 26 (Mon)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
8th May 26 (Fri)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
18th May 26 (Mon)

Location:London Bridge

Places: Available

RRP: £299.00

Discount:

You Pay: £299.00 + VAT
3rd Jun 26 (Wed)

Location:Online

Places: Available

RRP: £299.00

Discount:

You Pay: £299.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

5

Questions and answers

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.