Microsoft Excel

A range of Microsoft Excel course is available from beginners to advanced. Please see the course options listed below.

We can also create a customised course outline to address any specific requirements you might have – please contact us for more information.

Microsoft Excel Basics – Essential Skills

This course is suitable for anyone new to Microsoft Excel.

Over one day, we will cover all of the essential topics required to use Excel effectively on a day-to-day basis including: data entry, formatting, changing page settings & writing formulas. We will also look at shortcuts and quicker ways of performing everyday tasks and concentrate on common problem areas such as working with longer lists, error checking etc.

Please click on the link below to download the full course outline.

Download PDF

Mastering Microsoft Excel

This course is suitable for those who are currently using MS Excel on a regular basis but may not have attended formal training recently or may never have attended training. It is also the next step for those who have already completed Microsoft Excel Basics and would like to explore further functionality available within MS Excel. Prior to attending this training, you should have a basic working knowledge of Excel and be using it on a fairly regular basis (although previous training is not required).

We will begin the day with an overview of some of the more basic topics. This will act as a recap for those who have already attended Microsoft Excel Basics – Essential Skills, and will ensure that the experienced users who have not attended formal training will become more aware of the use of Speed Keys etc. We will then move on to more intermediate topics such as working with and linking multiple worksheets, creating charts, managing lists (Sorting & AutoFilter) among some others.

Please click on the link below to download the full course outline.

Download PDF

Microsoft Excel Expert

This course is designed to follow-on from Mastering MS Excel. If you are already familiar with the fastest way of performing everyday tasks, and you have already intermediate topics, it is now time to build on that knowledge.

A large proportion of the course is dedicated to using the Database Features in MS Excel. This is a very powerful side to Excel that not many people utilise to its full potential. In addition, more advanced and useful functions such as IF and Lookups are covered in along with automating tasks using Macros etc.

It is highly recommended that you firstly attend Mastering MS Excel prior to attending Microsoft Excel Expert (Advanced) as some of the topics covered in Mastering MS Excel are essential for successful completion of this course. If you have not attended Excel training at an Intermediate level prior to attening this course, you will be required to complete the MS Excel pre-course questionnaire

Please click on the link below to download the full course outline.

Download PDF