Private Bookings:

As a result:

This course is only available as a private booking for an individual or group.

  1. We are able to run courses on dates to suit you,
  2. We can customise the course content for you,
  3. We can offer discounts for larger group bookings.

Our private courses can run online, in-person at your offices or at one of our training centres.

Please contact us for full details.

Award Winning
9 years in a row
Expert Trainers
Average experience: 12 years
Small Classes
Average 4 people per class
Moneyback Guarantee
100% money-back guarantee

Excel Courses

Excel Training: Introduction Course

Excel Introduction Course

1 Day
Online & London
Onsite Courses Available
4th Apr

For complete beginners, this course covers all the basics of Excel.

  • Navigating Excel & workbooks
  • Inputting data & using dates
  • Cell referencing & formulas
  • Using fonts, colours & borders
  • Printing your spreadsheet
Excel Training: Intermediate Course

Excel Intermediate Course

1 Day
Online & London
Onsite Courses Available
20th Mar

Develop your Excel skills & learn to use more advanced features.

  • Creating & formatting charts.
  • Using conditional formatting
  • Intermediate-level formulas
  • Using quick analysis tools
  • Creating & filtering data tables
Excel Training: Combined (Introduction & Intermediate) Course

Combined Excel Course

2 Days
Online & London
Onsite Courses Available
4th, 5th Apr

Our combined Excel course is the fastest way to go from complete beginner to confident Excel user.

Save £55 when you book our Introduction and Intermediate Excel courses at the same time.

Excel Training: Advanced Course

Excel Advanced Course

2 Days
Online & London
Onsite Courses Available
25th, 26th Mar

Become a poweruser mastering Excel’s most powerful tools & functions.

  • Using logical functions
  • VLOOKUP, HLOOKUP & INDEX
  • Creating & editing Pivot Tables
  • Importing & exporting data
  • Automating with macros
Excel Training: VBA Course

Excel VBA Course

2 Days
Online & London
Onsite Courses Available
25th, 26th Mar

Take complete control of Excel using VBA to create your own code and procedures.

  • The object model & key concepts
  • Programming techniques
  • Procedures & user-defined functions
  • Custom forms including controls
  • Starting procedures automatically
Excel BI Training: Power Query & Power Tools Course

Excel Power Tools Course

2 Days
Online & London
Onsite Courses Available
25th, 26th Mar

Learn to use Excel’s Power Tools for business intelligence and data analysis.

  • Power Tools: Query, Pivot & Maps
  • Importing data
  • Transforming & preparing data
  • Data models, measures, fields
  • Slicers, Pivot Charts & visualisation
Dynamic Array Formulas

Excel Dynamic Array Formulas Course

1 Day
Live Online & Client Site
Onsite Courses Available

Learn how to use Excel 365’s new dynamic array formulas.

  • How these formulas work
  • Using dynamic array formulas
  • Correcting a #SPILL error
  • Referencing ranges using #
  • Practical examples (Eg FILTER)
Excel: 2 Day Financial Modelling Training Course

Excel Financial Modelling Course

2 Days
Online & London
Onsite Courses Available
15th, 16th Apr

Learn to create your own financial models in Excel step-by-step.

  • Best practice set up and layout
  • Errors & circular references
  • Specialist functions: NPV, XIRR
  • Scenario analysis with Goal seek
  • Using user-defined functions

Choosing The Right Excel Course

If you are unsure which course is appropriate for you please don’t hesitate to get in touch.

Alternatively, we have an assessment tool that will advise you in less than 30 seconds!

Check it out here: Excel Assessment Tool.

Our Excel introduction course is for complete beginners. You do not need any previous experience with Excel to attend.

It is designed for people who will be:

  1. Using complex spreadsheets and reports that have been prepared by other analysts
  2. Creating simple spreadsheets from scratch.
  3. Going on to attend our Intermediate and Advanced courses and need to master the basics.

By the end of this beginner-level course, you will be able to:

  1.  Create and navigate Excel spreadsheets.
  2.  Input and format data with fonts and colours.
  3.  Use absolute and relative cell references.
  4.  Set up simple formulas.
  5.  Print your Excel sheet.

Our Excel intermediate course is for people looking to develop their Excel knowledge and skills. It assumes that you are already an Excel user but not to an advanced level. 

It is designed for people who will be:

  • Editing complex spreadsheets and charts and graphs.
  • Carrying out simple data analysis by filtering data and using formulas.
  • Going on to attend our Advanced course and need to master the basics.

By the end of this course, you will be able to:

  • Creating charts and graphs.
  • Filtering and sorting data.
  • Use conditional formatting to highlight specific data.
  • Use more complex formulas like SUMIF.

Our advanced Excel course teaches you how to use all of Excel most complex formulas and built in functions.

It is designed for people who will be:

  • Creating complex spreadsheets and financial forecasts from scratch.
  • Creating simple macros to automate repetitive work.
  • Going on to attend our Excel VBA course.

By the end of this course, you will be able to:

  • Use all of Excel’s logical functions.
  • Use Excel’s lookup and reference functions.
  • Create PivotTables.
  • Use Data Consolidation to combine data from several workbooks.
  • Use Solver to solve complex scenario problems.

Our combined course is designed for Excel novices who want to improve their skills rapidly.

It is made up of our Excel Introduction and Excel Intermediate courses, which run on subsequent days.

Doing these two courses back-to-back offers the most effective way for people to develop their Excel skills.

The Combined Course also comes with a £55 discount!

Our Excel courses can run at your offices, at one of our training centres in London or online in a virtual classroom.

Our online Excel courses can be run using either Zoom or Microsoft Teams.

Course Overview

 

Lucinda, one of our Microsoft Excel trainers, introduces her Excel courses. She has been an Excel trainer for over 20 years.

Find out what it is like to be on one of her courses and also about her background as a trainer.

Online Excel Courses

We offer all of our Excel training courses remotely, as well as in-person.

Our remote Excel courses cover the same content as our in-person courses and run over Zoom or Microsoft Teams.

Our trainers have plenty of experience online and in-person.

So whichever option is best for you, we will ensure you get the best training possible.

Excel Training Locations: London

London Training Venue & Course Details
St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150

Directions

Private Courses & Corporate Training

Looking for private group training or a 1-2-1 Excel course?

Our custom courses are organised on dates to suit you, either at your office or ours or online whichever you’d prefer.

The Training Day

Course Times

9.15 - 9.30
Arrival
9.30 - 11.00
Training Session 1
11.00 - 11.15
Break
11.15 - 12.30
Training Session 2
12.30 - 13.30
Lunch
13.30 - 14.45
Training Session 3
14.45 - 15.00
Break
15.00 - 16.30
Training Session 4

What's Included?

Everything you need for a great day's training

A full-colour manual to take home with you A full-colour manual to take home with you
A USB stick so that you can take the exercises home A USB stick so that you can take the exercises home
Pens, pads and everything you'll need to take notes Pens, pads and everything you'll need to take notes
Plenty of tea, coffee and biscuits Plenty of tea, coffee and biscuits
6 months of support after the course 6 months of support after the course
A comfortable, modern air-conditioned training room A comfortable, modern air-conditioned training room

Training FAQs

 

Our online training is designed to re-create the classroom Excel training experience as closely as possible.

It is a live training session using Zoom or Microsoft Teams as a virtual classroom. Your trainer is there throughout.

The training is still hands-on, so you need to have the software installed on your own computer.

The trainer will share their screen to demonstrate Excel techniques and there is also the option of being able to share your screen if you are really stuck!

Our focus is on you being a faster, more capable Excel user when you return to work.

Our Microsoft Excel courses combine traditional teaching to explain new concepts and tools with hands-on exercises.

The exercises ensure that you get plenty of time to try out what you have just been taught and ask questions if there is anything you’re unsure of.

Our training computers use Office 2016 (2020 update).

If you use Office 365 or MS Excel 2016, 2013 or 2010 don’t worry.

The look and functionality of Excel has changed very little between recent versions.

This means that all of our training is just as relevant for users of these versions.

Our trainers have lived and breathed Excel for many years.

If you have any questions relating to other versions of Excel, that’s no problem, they’ll be very happy to answer them for you.

Yes. We provide all attendees on our course with certificates.

Please come wearing whatever you are most comfortable in, we do not have a dress code for our training courses.

Most people come wearing casual clothes.

Our London training centre is centrally located in the City of London.

It is a 3-minute walk from both Blackfriars tube station and Thameslink station.

For full details on our London centre see this link: London location

Our public Excel courses use Windows computers, not Excel for Mac.

However, this is not an issue if you use Excel for Mac.

Excel for Mac and Windows Excel are identical, with only a couple of very small differences, and so our courses will still be highly relevant for you.

It is helpful for us to know that you are an Excel for Mac user, so please let us know when booking.

Excel FAQs

 

Microsoft Excel is the most widely used spreadsheet program in the world. It is part of Microsoft’s Office suite of applications.

It is a very powerful program, with functions offering simple calculations, but extending right up to data modelling, data visualisations, programming, financial calculations, advanced formulas and manipulations, and business analytics.

It can import data from a variety of places, including by accessing external databases.

Good Excel knowledge will help you advance in almost any career, and is a key part of personal development.

Learning Excel shortcuts and advanced functions will allow you to quickly obtain actionable insights from your data.

Adding new skills and capabilities to your CV will make you more employable for your next role, or improve your chances of promotion.

It is possible to become an advanced Excel user in 4 days on our courses.

We believe our classroom training is the fastest way to learn Excel as they are highly interactive, meaning that you progress as quickly as possible.

They can take you from Excel basics through to an advanced level that quickly because our tutors are on hand to offer help and advice throughout.

 

Excel is very widely used in the corporate world.

In almost every job you will be expected to read and review spreadsheets.

The skills learnt in our training programmes will be very useful for accounting and analysis, statistics, business and finance, marketing, and sales.

Financial analysts and business analysts are well known for having advanced Excel skills and using it for more complex tasks like data visualization.

Excel Course Use Cases

Still not sure which course is best for you? Check out some of the use cases here:

Our advanced Excel course covers the basics of handling large datasets with things like pivot tables, lookup functions and data validation.

If you’d like to take things beyond that then our Excel Power Tools course would be right for you as it covers more dedicated ‘Big Data’ tools like data modelling and also introduces Power BI.

We offer a dedicated financial modeling course which covers this in detail.

If you are not already an advanced Excel user, you would need to attend our advanced Excel course prior to attending this course.

Our advanced Excel course covers macros which are a very effective way to create simple automations.

For more advanced automations you would need to learn how to write VBA code which is covered on our Excel VBA course.

Our intermediate Excel course covers charts and graphs in detail and so would be the appropriate course for you.