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.

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, 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.

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.

VBA (Visual Basic For Applications) is a programming language that allows you to take full control of Excel (and other Office applications).

You can use it to automate tasks and create small applications to run in Excel.

If you don’t know how to use VBA, or don’t have time to learn it, then you should look at Excel macros.

A macro (short for macroinstruction) is a small program that automatically runs Excel through a pre-recorded set of steps that you have shown it.

Then each time that you run that macro, Excel will mechanically follow the steps that you’ve shown it.

They can be very useful and allow you to completely automate standard, repetitive tasks. Once you know how recording a macro can be done very quickly.

We offer three courses that cover Excel macros & Excel VBA.

1. For a quick introduction to macros, creating and editing macros is covered as the final section of our advanced Excel course. We cover the basics of recording macros and editing macros.
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.

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 assumes that you already have some limited experience with Excel.

The main topics that it covers are:

• creating graphs and charts.
• using quick data analysis tools.
• basic formulas.
• using Excel’s list sorting and management tools

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

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 develop their Excel skills.

Our introduction to Excel course is for complete beginners.

It does not assume any prior knowledge and shows you the basics.

Beyond showing you how to navigate Excel it also covers using Excel for tasks like:

• Selecting a specific part of your spreadsheet to print.
• How to make your spreadsheet fit onto one page.
• Adding headings onto your spreadsheets when you print them out.

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

Pivot tables are very useful. They allow you to very quickly produce 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.

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 Microsoft Excel training courses.

Most people come wearing casual clothes.

Our London training centre is 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