Become a faster, more confident Excel user. Learn to:

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

Excel Courses

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

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 Excel VBA course will lead you step-by-step through creating your own program.

We cover things in easily digestible sections which all build straightforwardly on the previous section so that we don’t leave anyone behind.

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.

Creating and editing macros is cover as the final section of our advanced Excel course. We cover both recording macros and the basics of editing them.

More advanced macro editing requires a good knowledge of VBA and so is part of our VBA training 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.

 

The most efficient way to do this type of comparison in Excel will depend on your exact data structure and type.

We cover all of the most common ways that you might do this in our course for advanced Excel users. Generally, a Vlookup or Hlookup or a consolidation function like SUMIFS offers the best solution.

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

 

 

PivotTables are one of the more advanced sections of our advanced users Excel training 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.

PivotTables are also part of our course on Excel PowerBI which covers all aspects of the Business Intelligence suit that is now available through Excel.

Adding to your spreadsheets and and making sure that the titles appear when you print your work is part of our Excel basics training 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.

Selecting a specific part of a one or more of your  worksheets to print is covered on our beginners training 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.

Our introduction to Excel course covers how to get your spreadsheet to fit onto one page in more detail.

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.

Our Excel combined course is designed for Excel novices who want to improve their skills quickly.

It is made up of our Excel Introduction and Excel Intermediate courses which run on subsequent days.

We find that, if your diary permits, doing these two courses back-to-back offers the most effective way for people to boost their Excel skills rapidly.

If you would like to build your Excel skills beyond the level of our intermediate Excel course we would recommend giving yourself before coming on our advanced course. This will give you time to practice the new techniques that you have learned.

Yes. Our Business Intelligence course covers all of these.

If you are an advanced Excel user over 2 days it will show you how to make full use of Excel’s powerful BI tools.

Day 1 shows you how to import data from a number of sources, edit it and create relationships between your data. You also cover inserting calculated columns into your data using Data Analysis Expression (DAX).

Day 2 builds on your knowledge and covers all aspects of PivotTables and PivotCharts, creating dashboards using slicers, timelines and KPIs and using the PowerView, PowerMap and PowerQuery tools.

Our intermediate course covers creating graphs and charts.

It also covers some of the other methods of visualising your data that Excel offers.