Microsoft Excel is an incredibly powerful spreadsheet program used by businesses in every industry.

Speed up your work by learning how to:

  • Use formulas to automate calculations.
  • Visualise your data by creating stunning graphs.
  • Use Pivot Tables to ‘slice and dice’ your data.
  • Automate repetitive tasks using Excel VBA.

Why Trust Us?

100% Money Back Guarantee

100% Money Back Guarantee

We’re so confident that you’ll love our courses that we offer a 100% money back guarantee (See details).

Multi Award-Winning

Multi Award-Winning

We’ve won the Feefo Gold award for customer service 6 years in a row. You can be sure things will go smoothly.

Small Classes (Average= 4) Small Classes (Average= 4)

You’ll get plenty of personal attention and time to ask questions.

Lots Of Hands-On Practice Lots Of Hands-On Practice

You’ll return to work a much faster, more confident Excel user.

Convenient & Comfortable Convenient & Comfortable

Modern, easily accessible London and Guildford training centres.

Professional Training Professional Training

Certified Microsoft Excel trainers mean you receive gold-standard training

Excel Courses

London & Surrey Locations

Guildford Training Courses
Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

Directions


London Training Courses
Fleet House
8-12 New Bridge St, EC4V 6AL
Tel: 0203 603 0150

Directions

Private Courses

Looking for private group training or a 1-2-1 session?

Our custom courses are organised on dates to suit you, either at your office or ours whichever you’d prefer.

Our free pre-course reviews ensure that custom courses focus on the exact topics that you need to cover.

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.25
Training Session 3
14.25 - 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 manual to take home with you A full-colour manual to take home with you
A USB stick so that you can take the exercises you've been working on home with you A USB stick so that you can take the exercises you've been working on home with you
Pens, pads and everything you'll need  to take notes Pens, pads and everything you'll need to take notes
A delicious lunch A delicious lunch
Plenty of tea, coffee and biscuits Plenty of tea, coffee and biscuits
6 months of support post the course in case you get stuck on anything 6 months of support post the course in case you get stuck on anything
A modern comfortable air-conditioned  training room A modern comfortable air-conditioned training room
bp logo
clancy docwra logo
EA logo
legal & general logo
nhs direct logo
rentokil initial logo
shell logo
Logo For Three Mobile
Logo For UK Home Office
Barclaycard Logo
Mercedes Benz logo
bhpbilliton logo

FAQs

We provide everything that you will need for a fun, productive day of training.

Everyone has their own computer to work on in a comfortable, bright, air conditioned room.

We provide plenty of tea, coffee & biscuits, a delicious, freshly prepared lunch and a USB stick so that you can take files home with you.

We provide 6 months of post course support as well.

If you get stuck on anything relating to the course simply get in touch and explain the issue.

We will make sure your trainer contacts you as soon as possible to help you out.

We don’t want to be the biggest training company but we are trying to be the best.

We have now won the Feefo Gold Award for customer service for 6 years in a row.

We always limit our classes to a maximum of 8 delegates but try to keep them smaller. During 2018 our average class size was 4 people.

To back up our promise of great training we offer a 100% money back guarantee.

Our focus is on you being a faster, more capable Excel user when you return to work.

Our courses combine traditional teaching to explain new concepts and tools with hands-on exercises.

The exercises ensure that you get plenty of time to try out what you have just been taught and make sure that you really understand it.

We also make sure that there is plenty of time for you to ask questions in case there is anything you are unsure of.

Please come wearing whatever you are most comfortable in, we do not have a dress code.

Most people come wearing casual clothes.

VBA is a programming language contained within the Microsoft Office suite.

It allows you to take complete control of Excel (and other Office applications like PowerPoint etc) and create programs and routines that will automate repetitive tasks for you.

Our training computers use Office 2016 (2019 update).

If you use Office 365 or Excel 2016, 2013 or 2010 don’t worry. The look and functionality of Excel has changed very little between recent versions. This means that all of our training is just as relevant for users of these versions.

Our trainers have lived and breathed Excel for many years. If you have any questions relating to other versions that’s no problem they’ll be very happy to answer them for you.

Yes. We provide all attendees on our course with certificates.

This means that in future you can prove to people that you have received professional training on Excel.

We teach the recording of macros in our advanced Excel course.

A macro (short for macroinstruction) is a small program which automatically runs Excel through a pre-recorded set of steps.

They are extremely useful and allow you to completely automate repetitive tasks.

You can quickly and simply record your own macros in Excel. Excel will create these macros in VBA. This means that you can then edit your macros if you are confident working with VBA.

 

We cover the types of functions used to do this in our advanced Excel course.

This is a very common question. As an example, people would like to compare last month’s payroll with this month’s payroll, or last year’s accounts to this year’s.

There are a number of ways to do this using Lookup functions in Excel.

Generally, a Vlookup or Hlookup or a consolidation function like SUMIFS offers the best solution.

 

PivotTables are covered on our Excel Advanced Course.

PivotTables are extremely useful and provde customised summaries of a data set in Excel.

It can be created in Excel by selecting a cell in the data first before selecting Tables and PivotTable from the Insert ribbon. Excel will then automatically define the data set for you.

A PivotTable can now be created on the same sheet or a  different one. Data headers will appear as objects on the right.  The objects can be dropped into the rows or columns of the PivotTable.  This provides a specific summary based upon the data which is being moved.

Printing titles is covered on our Excel Essentials Course

Data headings do not automatically appear or print on other pages.  The feature to show and print data headings is on the Page Layout Ribbon in the Page Setup group.

The command is Print Titles.  In the Rows to repeat at top feature, the specific row number for the data headings is highlighted from the sheet.

Printing a specific area of a work sheet is covered on our Excel Essentials course.

To print a specific area of an Excel worksheet, the area you want to print should be highlighted.

Then you need to access Print Preview by using the short cut Control + P.  Under Settings, Print     Selection can be selected. If you now print this sheet only the area selected will br printed.

Getting your work to fit on a sheet is covered on our Excel Essentials course.

The easiest way to get a data set to fit onto a worksheet is to use the Scale feature on the Page Layout Ribbon in the Scale to Fit group.

Use the spin arrows to increase or decrease the size of the data set as required, to fit on the sheet.