Microsoft Excel Introduction
This basic Microsoft Excel 2016 course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.
Microsoft Excel Intermediate
Uutilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.
Microsoft Excel Advanced
Learn to utilise Microsoft Excel to perform complex calculations, represent data as a chart, and manipulate database lists.
Microsoft Excel Advanced Data Analysis
Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course, including working with named ranges. Basic knowledge of a PivotTable is advantageous.
Microsoft Excel Advanced Formulas
This course has been developed for users who need to clean up imported data, or build models for other users.
Microsoft Excel Advanced Pivot Tables
This course has been developed for people wanting to use more complex functionality of PivotTables within Microsoft Excel, including the PowerPivot add-in which allows you to analyse multiple files.