MS Excel 2016 - Level 2

This course has no current classes. Please the waiting list.

This short course is for students who have Excel skills and would like to expand their knowledge. You will learn how to use spreadsheet enhancements such as simultaneous data entry, linking worksheets, relative and absolute cell referencing, named ranges and advanced functions such as IF, SUMIF, ROUND and VLOOKUP.This class also covers how to create complex spreadsheets using data validation, cell protection and templates and analyse large amounts of data using Filters, Sub Totals and Pivot Tables.


The content of this learning experience is focused on Microsoft Excel spreadsheet enhancements.

Outcomes/ Benefits

As a result of this learning you will be able to apply Microsoft Excel spreadsheet enhancements in a range of situations..

What To Bring

  • Pen and paper.

Please Note

If you have supplied us with a mobile phone number, we may contact you via SMS if there are any last minute course changes or class cancellations. Please check your phone during the few days prior to the class start date in case there are any changes to your class. If you are sent an SMS please do not reply as these are sent via our computer system and we are unable to receive replies. Please contact one of our offices to confirm you have received any SMS messages.
Thank you.

Related Courses