Search our courses

Course Summary

Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant. Courses can be delivered on your premises on dates that suit you or you can complete the course at one of our public courses in London or Bristol.

clock symbol
Workshop Duration:-
1 Day
target student icon
Target Students:-
Users who wish to gain a comprehensive, in-depth knowledge of this application and improve their skills within Functions
Delegates must have attended an Excel Intro/Inter course, or have an equivalent working knowledge of Excel

Course format

Classroom based learning delivered by highly experienced Microsoft Certified Trainers. Very interactive session with plenty of hands on, applying new learnt skills throughout the day with exercises.

Manual provided and unlimited support after the training, backed up with a Certified Certificate at the end of the session.

Private course:

  • On your premises – anywhere throughout the UK or Europe
  • Dates to suit you
  • Maximum number of delegates 8 to ensure dedicated individual attention when required

Public Course Dates (Bristol & London):

  • Tuesday 2nd April
  • Wednesday 3rd July
  • Thursday 7th November
  • Thursday 19th December

Laptops can be provided, or you can bring your own, refreshments provided throughout the day and a lunch.

Course content – overview

  • Short overview of intermediate topics
  • Named Ranges
  • Lookup Functions – VLOOKUP, MATCH, INDEX, INDIRECT
  • Advanced Functions – OFFSET
  • Date and Text
  • Data Validation
  • File Linking
  • Protection
  • Consolidation
  • Macros
  • Goal Seek, Using Solver and Goal See


On successful completion of the course, delegates will be able to create and apply names ranges, understand Lookups, solve problems by using Goal Seek, record macros and assign to buttons and link objects between different applications.

What our delegates have to say

"Very Informative." - Owen

"Kam was friendly, really helpful and informative." - Denise

"Well done to Caroline, brilliant course, learnt loads." - Angus

"Great course - informative and engaging." - James

"Very good and useful. Refreshed my knowledge on excel and gained new skills."

How to book your space

Interested in booking a space on one of our Microsoft Excel Advanced courses or want to find out more details? Fill out our “Register Interest” form we’ll get back to you as soon as we can with further information. Or call us today on 01454 203 355.