Microsoft Excel Training in London, UK & Online [All Courses Live] (2024)

Microsoft Excel Training in London, UK & Online [All Courses Live] (1)

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

Microsoft Excel Training in London, UK & Online [All Courses Live] (2)

Microsoft Excel Training in London, UK & Online [All Courses Live] (3)

Microsoft Excel Training in London, UK & Online [All Courses Live] (4)

Award Winning

9 years in a row

Microsoft Excel Training in London, UK & Online [All Courses Live] (5)

Expert Trainers

Average experience: 12 years

Microsoft Excel Training in London, UK & Online [All Courses Live] (6)

Small Classes

Average 4 people per class

Microsoft Excel Training in London, UK & Online [All Courses Live] (7)

Moneyback Guarantee

100% money-back guarantee

  • Home
  • Courses
  • Microsoft
  • Excel

Excel Courses

Excel Introduction Course

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

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

Combined Excel Course

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.

Excel Advanced Course

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

Excel VBA Course

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

Excel Power Tools Course

2 Days

Online, London & Guildford

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

Excel Dynamic Array Formulas Course

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)

Excel Financial Modelling Course

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:

  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.

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

Microsoft Excel Training in London, UK & Online [All Courses Live] (2024)
Top Articles
Latest Posts
Article information

Author: Errol Quitzon

Last Updated:

Views: 6125

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Errol Quitzon

Birthday: 1993-04-02

Address: 70604 Haley Lane, Port Weldonside, TN 99233-0942

Phone: +9665282866296

Job: Product Retail Agent

Hobby: Computer programming, Horseback riding, Hooping, Dance, Ice skating, Backpacking, Rafting

Introduction: My name is Errol Quitzon, I am a fair, cute, fancy, clean, attractive, sparkling, kind person who loves writing and wants to share my knowledge and understanding with you.