Excel Training & Courses

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.

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.

Some articles that we have written that you might find useful.

1. The SEO’s Guide To Excel
2. The Beginner’s Guide To Excel PowerPivot and PowerBI
3. An Introduction To Microsoft Excel

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 remains popular because of its combination of ease of use, flexibility and because it is already popular!

The fact that it’s bundled with the MS Office which is so widely used means that Excel spreadsheets can easily be shared without facing any issues.

As it has been developed it has also become increasingly easy to use and flexible, meaning that it can be used in a huge variety of different ways.