Small, expert-led Excel courses in London, UK-wide, Online or at your offices.
Master Excel with one of the UK's most experienced Excel training providers.
4.97
245 reviews
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
- Home
- Courses
- Microsoft
- Excel
Excel Courses
1 Day
Online, London & Guildford
Onsite Courses Available
7th Mar
See all dates
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
1 Day
Online, London & Guildford
Onsite Courses Available
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
2 Days
Online, London & Guildford
Onsite Courses Available
7th, 8th Mar
See all dates
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.
2 Days
Online, London & Guildford
Onsite Courses Available
26th, 27th Feb
See all dates
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
2 Days
Online, London & Guildford
Onsite Courses Available
6th, 7th Mar
See all dates
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
2 Days
Online, London & Guildford
Onsite Courses Available
26th, 27th Feb
See all dates
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
1 Day
Live Online & Client Site
Onsite Courses Available
Private bookings only
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)
2 Days
Live Online & Client Site
Onsite Courses Available
11th, 12th Mar
See all dates
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:
- Using complex spreadsheets and reports that have been prepared by other analysts
- Creating simple spreadsheets from scratch.
- 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:
- Create and navigate Excel spreadsheets.
- Input and format data with fonts and colours.
- Use absolute and relative cell references.
- Set up simple formulas.
- 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 and Guildford or online in a virtual classroom.
Our online Excel courses can be run using either Zoom or Microsoft Teams.
The core excel skills required for financial model were great as were the tips to improve efficiency
Finance, Property Hub
Paul was amazing and patient and gave really good fundamentals of financial modelling which I can incorporate immediately in to my job. He has helped to change my mindset in order to streamline and automate processes
Caitlin May, Property Hub
Course material was excellent and the trainer knew everything, very slick and informative
Young and Co Brewery PLC
The trainer was very knowledgeable even outside the course material.
Young and Co Brewery PLC
There was a relaxed atmosphere.
AQA
"Lovely Trainer Formulas explained nicely
Workforce and Information Analyst – Royal Surrey Hospital
Discovering easier ways to carry out tasks I've already been doing. The trainer was very good at explaining and was good fun.
Administrator – Royal Surrey Hospital
Very good overview and detail and was very well presented. The trainer had very expert knowladge and shared that
Delegate from Novartis Pharmaceuticals
I have understood where and how to find simple tools to make it easier and quicker to do stats relevant to my job
Delegate from Nuffield Health
The teacher was excellent - able to explain everything very clearly, and enable all members of the group whatever their skill level
Delegate from Nuffield Health
Course Overview
Watch Lucinda, one of our Microsoft Excel trainers, introduce her Excel courses.
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 & Guildford
London Training Venue & Course Details
St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150
Directions
Guildford Training Venue & Course Details
Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488
Directions