Microsoft Excel Training

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.

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