Award Winning
Award-winning 7 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

Microsoft Excel Training: Introduction Course

Excel Introduction

Length :
1 Day
Where :
Online, London & Guildford + Client Site
Next Date :
August 18th

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
Microsoft Excel Training: Intermediate Course

Excel Intermediate

Length :
1 Day
Where :
Online, London & Guildford + Client Site
Next Date :
August 19th

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 Combined (Introduction & Intermediate)

Excel Combined £55 Off

Length :
2 Days
Where :
Online, London & Guildford + Client Site
Next Date :
August 18th, 19th

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.

Microsoft Excel Training: Advanced Course

Excel Advanced

Length :
2 Days
Where :
Online, London & Guildford + Client Site
Next Date :
August 24th, 25th

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
Microsoft Excel Training: VBA Course

Excel VBA

Length :
2 Days
Where :
Online, London & Guildford + Client Site
Next Date :
August 16th, 17th

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

Length :
2 Days
Where :
Online, London & Guildford + Client Site
Next Date :
August 25th, 26th

Learn to use Excel’s Power Tools for business intelligence and advanced 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

Length :
1 Day
Where :
Online, London & Guildford + Client Site

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)
Financial Modelling in Excel

Excel Financial Modelling

Length :
2 Days
Where :
Online, London & Guildford + Client Site

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 which can be found 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.

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

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

Your Excel Trainer

 

Meet Lucinda one of our Microsoft Excel trainers.

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.

London Location

London Training Courses
Fleet House, 8-12 New Bridge St
London, EC4V 6AL
Tel: 0203 603 0150

Directions


Bristol Training Courses
One Temple Quay
Temple Back East, BS1 6DZ
Tel: 0117 299 3990
Guildford Training Courses
Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

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.

Our free pre-course reviews ensure that our custom Excel courses are focused on the topics you need.

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 you've been working on home with you A USB stick so that you can take the exercises you've been working on home with you
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 post the course in case you get stuck on anything 6 months of support post the course in case you get stuck on anything
A modern comfortable air-conditioned training room A modern comfortable air-conditioned training room
Clancy Docwra Logo
EA Games Logo
Legal & General Logo
NHS Direct Logo
Rentokil Initial Logo
Shell Logo
NatWest Logo
Mercedes Benz Logo
Three UK Logo
BHPBilliton logo

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.

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