Microsoft Excel Training

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 to be sure that you understand it.

The exercises also ensure that there is plenty of time for you to ask questions if there is anything you are unsure of as our instructors are on-hand throughout.

Yes.  We offer post-course support for 6 months after your course.

If you get stuck on anything relating to our course simply get in touch and explain the issue that you are having clearly. We will make sure your trainer contacts you as soon as possible to help you out.

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.