Excel 2016 / 2019 Advance


Designed for those who are geared up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to learn advanced formulas, creating macros, using What If Analysis tools, create Pivot Tables and Pivot Charts, subtotaling and securing your data.


Participants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Windows 2003 / Windows 7 and Microsoft Excel 2016 Basic and Microsoft Excel 2016 Intermediate.


Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.