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
Courses
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
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
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.
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
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
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
Choosing The Right Excel Training Course
If you are unsure which Excel 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: Microsoft Excel Assessment Tool.
Our introduction course is for complete beginners.
You do not need any previous experience with Microsoft Excel to attend.
It is designed for people who will be:
- Working with spreadsheets and reports that others have created.
- Creating simple spreadsheets from scratch.
- Going on to attend our Intermediate and Advanced Excel courses and need to master the basics.
Our intermediate course is for people looking to further develop their Microsoft Excel skills.
It assumes that you are already a basic Microsoft Excel user.
It is designed for people who will be:
- Editing complex spreadsheets and charts and graphs created by others.
- Carrying out simple data analysis by filtering data and using formulas.
- Going on to attend our Advanced Excel course and need to master the basics.
Our advanced course teaches you how to use all Microsoft Excel’s most complex formulas and built-in Excel functions.
This is to develop advanced Excel skills.
It is designed for people who will be:
- Creating complex spreadsheets and financial forecasts from scratch.
- Creating simple macros to automate repetitive work and data analysis.
- Going on to attend our Excel VBA course.
Our combined course is designed for Microsoft 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.
Go from no experience to carrying out data analysis in just two days!
Doing these two Excel 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 Microsoft 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 HubPaul 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 HubCourse material was excellent and the trainer knew everything, very slick and informative
Young and Co Brewery PLCThe trainer was very knowledgeable even outside the course material.
Young and Co Brewery PLCThere was a relaxed atmosphere.
AQA"Lovely Trainer Formulas explained nicely
Workforce and Information Analyst – Royal Surrey HospitalDiscovering 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 HospitalVery good overview and detail and was very well presented. The trainer had very expert knowladge and shared that
Delegate from Novartis PharmaceuticalsI 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 HealthThe teacher was excellent - able to explain everything very clearly, and enable all members of the group whatever their skill level
Delegate from Nuffield HealthExcel Course Overview
Lucinda, one of our Microsoft Excel trainers, introduces her Excel courses.
She has been a Microsoft 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.
London Training Centre
London Training Venue & Course Details
St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150
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 Microsoft Excel course?
Our custom Excel 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 course manual.
Your course exercises to practice at home.
Pens, pads and everything you'll need to take notes.
Plenty of tea, coffee and biscuits.
6 months of support after the course.
A comfortable, modern air-conditioned training room.
FAQs
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 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.