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
For complete beginners, this course covers all the basics of Excel.
- CPD certified
- Navigating Excel & workbooks
- Inputting data & using dates
- Cell referencing & formulas
- Using fonts, colours & borders
Develop your Excel skills & learn to use more advanced features.
- CPD certified
- Creating & formatting charts
- Using conditional formatting
- Intermediate-level formulas
- Creating & filtering data tables
Combined Excel Course
2 Days
Online, London & Guildford
Client Site Courses Available
22nd, 23rd Apr
Our CPD-certified 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 Advanced Course
2 Days
Online, London & Guildford
Client Site Courses Available
24th, 25th Apr
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
Excel Power Tools Course
2 Days
Online, London & Guildford
Client Site Courses Available
28th, 29th Apr
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.
I learned loads of simple tricks I had never heard of, the little details from the course have a big impact!
Julie McPherson, Accounts Recievables Manager, Greenacres Portfolio ManagementThe trainer was great at explaining and made the course relevant to my day-to-day work.
Hannah Dickinson, Customer Relationship Team Leader, Multi Packaging Solution UK LtdThe whole course was useful and enjoyable.
Allan McPhie, Estimator, Maguire Bros LtdThe workbooks and practical aspects of the training made it easy for all types of learners.
Neve Heavens, Restaurant Administrator, Seasons KitchensIt felt very easy to ask questions and the trainer was happy to recap any areas for us.
Sue Lefevre-Smith, Finance Analyst, HMRCOur instructor was very friendly, approachable, and always there to answer questions.
Eva Andersen, Office Administrator, SCIRIS GroupI felt comfortable to ask questions, and the takeaway materials are really useful.
Linda Job, Entertainments Accountant, Casarotto Ramsay & AssociatesThe 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 PLCExcel 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
Excel FAQ
Yes although inevitably it works far better with other Microsoft products.
OneDrive and SharePoint allow real-time co-authoring so that teams can work on the same spreadsheet simultaneously. It also works very well with Microsoft Teams – see next question.
Google Workspace can automatically convert Excel files to Sheets and vice-versa.
Project management tools like Asana allow data transfer into / from Excel using CSV files. Two-way synchronisation requires add-ins.
Excel works particularly well with Teams.
Excel tab in Teams: You can pin important spreadsheets in a Teams channel, allowing team members to view and edit Excel files directly within Teams without switching apps.
Co-authoring in Teams: Multiple users can edit the same Excel file simultaneously, with real-time updates. This is ideal for collaborative budgeting or project planning.
Excel Live in Teams meetings: Presenters can share interactive Excel workbooks which participants can scroll, filter, and interact with, without taking control of the screen.
Power Automate workflows: Automate Excel updates in Teams, such as posting daily reports, inventory updates, or financial summaries to a channel.
Loop components (limited integration): While you can’t embed full live Excel tables in Teams chat, Loop tables allow collaborative data editing within a Teams message, though with limited formatting.
Data visualisation sharing: Charts, PivotTables, and conditional formatting work well when shared in Teams, improving data-driven discussions during meetings.
We would recommend learning both over time.
Learning Excel will give you lots of foundational data skills before you move to Power BI for more advanced data analysis, visualisation and reporting.
Excel and Google Sheets are similar but have different strengths and weaknesses.
Excel is best for advanced data analysis, large datasets, and automation with VBA. It offers superior performance for financial modelling and reporting. Excel is also far more widely used in corporate environments.
Google Sheets is cloud-based making it great for real-time collaboration (although Excel is catching up fast) but lacks advanced features like Power Query and VBA.
Excel, Power BI and Tableau are all excellent tools but designed for different tasks.
Excel is a general use tool and best for data analysis, reporting, and financial modelling.
Power BI is a more specialist tool. It is best for creating interactive dashboards, real-time data visualisation, and large-scale data processing. It integrates well with databases.
Similarly, Tableau is designed for large-scale data processing, advanced data visualisation and storytelling. It also offers powerful drag-and-drop analytics.
Many businesses use Excel alongside Power BI or Tableau for a complete business intelligence workflow. Excel is great for data preparation, while Power BI and Tableau provide deeper insights, visualisation and automation.
Course 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 almost 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.
Yes, all students receive digital course materials including practice exercises where appropriate.
Yes we offer unlimited support for 6 months.
Simply email us your question in as much detail and the trainer will come back to you as soon as they are able to.
Yes in addition to our scheduled courses we regularly organise private courses for groups and individuals both at our training centres and their offices.
Excel Course Use Cases
No, Excel is still very widely used. Some newer tools are carrying out some functions that used to be carried out in Excel but no tools are replacing Excel.
- Power BI: Great for interactive dashboards and reporting but most data imported into Power BI is gathered and cleaned in Excel.
- Airtable: Is a powerful tool but more difficult to learn and so mainly used by IT and data analysis professionals.
- Notion: Is great for organising and gather data but has very limited analysis and reporting capabilities.
Data cleaning, calculations, and PivotTables will be your key set.
- Data Cleaning: Requires formulas like TRIM(), CLEAN() and SUBSTITUTE() to ensure your data is in a standardised format. Formulas at this level are covered in our intermediate Excel course.
- Calculations: Use formulas like SUMIFS(), AVERAGEIFS() and INDEX-MATCH. Formulas at this level are covered in our advanced course.
- Pivot Tables: They are also covered during our advanced course.
To efficiently handle large datasets in Excel you should learn:
- Power Query: Automate data cleaning, transformation and consolidation from multiple sources.
- Power Pivot: Use a Data Model so that you can work with millions of rows of data without slowing Excel down.
- XLOOKUP: Quickly and efficiently run lookup queries across numerous tables of data.
- Dynamic Arrays: Create scalable reports which do not require manual updates.
These functions are covered in our advanced course and our Power Tools course.
There are a number of ways to automate Excel work:
- VBA: This runs in Excel and is best for creating custom macros, advanced user-defined functions and automating repetitive tasks.
- Power Automate: This is a Microsoft product but separate from Excel. This is best for automating tasks that involve other Microsoft apps like Teams, Outlook and SharePoint.
- ChatGPT and other AI tools: These are separate from Excel and best for generating formulas and VBA scripts to be used in Excel and also Power Automate workflows.
Reviews
We’ve won the Feefo Gold award for customer service 9 years in a row
