Private Bookings:

As a result:

This course is only available as a private booking for an individual or group.

  1. We are able to run courses on dates to suit you,
  2. We can customise the course content for you,
  3. We can offer discounts for larger group bookings.

Our private courses can run online, in-person at your offices or at one of our training centres.

Please contact us for full details.

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
1 Day Introduction Excel Training Course: CPD Accredited

Excel Introduction Course

1 Days
Online, London & Guildford
Client Site Courses Available
18th Mar

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
1 Day Intermediate Excel Training Course:         CPD accredited

Excel Intermediate Course

1 Days
Online, London & Guildford
Client Site Courses Available
19th Mar

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 Training Course: (Introduction & Intermediate)

Combined Excel Course

2 Days
Online, London & Guildford
Client Site Courses Available
18th, 19th Mar

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.

2 Day Advanced Excel Training Course: CPD Certified

Excel Advanced Course

2 Days
Online, London & Guildford
Client Site Courses Available
17th, 18th Mar

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

Excel VBA Course

2 Days
Online, London & Guildford
Client Site Courses Available
20th, 21st Mar

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 Course

2 Days
Online, London & Guildford
Client Site Courses Available
20th, 21st Mar

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:

  1. Working with spreadsheets and reports that others have created.
  2. Creating simple spreadsheets from scratch.
  3. 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.

Excel 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

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.

  1. Power BI: Great for interactive dashboards and reporting but most data imported into Power BI is gathered and cleaned in Excel.
  2. Airtable: Is a powerful tool but more difficult to learn and so mainly used by IT and data analysis professionals.
  3. 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.

  1. 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.
  2. Calculations: Use formulas like SUMIFS(), AVERAGEIFS() and INDEX-MATCH. Formulas at this level are covered in our advanced course.
  3. Pivot Tables: They are also covered during our advanced course.

To efficiently handle large datasets in Excel you should learn:

  1. Power Query: Automate data cleaning, transformation and consolidation from multiple sources.
  2. Power Pivot: Use a Data Model so that you can work with millions of rows of data without slowing Excel down.
  3. XLOOKUP: Quickly and efficiently run lookup queries across numerous tables of data.
  4. 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:

  1. VBA: This runs in Excel and is best for creating custom macros, advanced user-defined functions and automating repetitive tasks.
  2. 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.
  3. 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

Feefo logo
We’ve won the Feefo Gold award for customer service 9 years in a row
NatWest Logo
Legal & General Logo
Shell Logo
EA Games Logo
Three UK Logo
NHS Direct Logo
Mercedes Benz Logo