Microsoft Excel Training Courses

• Maximum number of delegates reduced to 4 for MS Excel courses in London.
• Temperature checks on arrival
• Desk distancing complies with Government guidelines
• Hand sanitiser availabl on arrival
• Facemasks available
• All training equipment and furniture is cleaned thoroughly after use
• Communal areas in the building are regularly disinfected.
• During this time lunch is not provided

Our online training is designed to re-create the classroom Excel training experience as closely as possible.

It is a live training session using Zoom or Microsoft Teams and the trainer is there throughout.

The training is still hands-on so you need to have the software installed on your own computer.

The trainer will share their screen to demonstrate Excel techniques and there is also the option of being able to share your screen if you are really stuck!

We still keep our Excel classes to a maximum of 8 so that you can ask questions at any time during the day.

The trainers like to see you! They much prefer it if you have a camera on so they can see you as well as you being able to see them.

We provide everything that you will need for a fun, productive day of MS Excel 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 Excel training classes to a maximum of 8 delegates but try to keep them smaller. During 2020 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 Microsoft Excel 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.

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.

If you are looking for a quicker introduction to VBA and macros you may find our 1 day Excel macros training course a better fit.

Our training computers use Office 2016 (2019 update).

If you use Office 365 or MS 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.

Our London Excel courses use Hewlett Packard computers.

We offer three courses that cover Excel macros.

1. For a quick introduction to macros, creating and editing macros is covered as the final section of our advanced Excel course. We cover both recording macros and the basics of editing them.
2. For a detailed look at Excel macros, we offer a one day Excel course focused on Excel macros. By the end of this you will be a master of recording and creating macros and routines.
3. For a detailed look at macros and how to edit them, the best course would be our VBA course. This will allow you to both create them and also show you VBA which can be used to edit them.

A macro (short for macroinstruction) is a small program that 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 MS Excel. Excel will create these macros in VBA. This means that you can then edit your macros if you are confident working with VBA.

Acuity Articles

1. The SEO’s Guide To Excel
2. The Beginner’s Guide To Excel PowerPivot and PowerBI
3. An Introduction To Microsoft Excel

Other Articles

• Excel Exposure
• Excel Easy

Our intermediate course covers creating graphs and charts.

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

Yes. These are covered in our Power BI training courses during our 2 day Power BI introduction and intermediate. 

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 pivot tables and pivot charts, creating dashboards using slicers, timelines and KPIs and using the power view, power map and power query tools.

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.

It covers all of the basics like cell references, setting up and formatting your spreadsheet etc.

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.

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.

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 be printed.

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.

Pivot tables are one of the more advanced sections of our advanced users Excel training course.

Pivot tables are extremely useful and provide 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 pivot table 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 pivot table.  This provides a specific summary based upon the data which is being moved.

As this is part of our advanced Excel training course which also covers vlookup functions we discuss when using each is appropriate as well.

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

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.

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.

Please come wearing whatever you are most comfortable in, we do not have a dress code for our Microsoft Excel training courses.

Most people come wearing casual clothes.

Our London training centre is very centrally located in the City of London. We run courses weekly for Excel training London.

It is a 3-minute walk from both Blackfriars tube station and Thameslink station.

For full details on our London centre see this link: Excel Training in London