MS Excel ® 2016 Advanced
In this Microsoft Excel® course you will learn the skills necessary to use pivot tables, audit and analyse worksheet data, utilise data tools, how to manipulate data using advanced sort and filter functions. Also covers working with multiple large spreadsheets and how to link data to create summary sheets.
WHAT WILL YOU LEARN?
This course will provide you with a better understanding on:
- Create pivot tables
- Create, use, edit and manage macros
- Formulas/functions nesting
- Working on large spreadsheets
- Advanced sort and filter
- Import and export data
- Protecting data and; Microsoft Excel shortcut keys
A Master Builders Certificate of Attendance will be awarded.
DATES: Please contact your local office for upcoming dates.
DURATION: 4 hours
The CTF provides funding support for training of eligible workers in the construction industry. We acknowledge the support of the CTF in reducing the costs of training for eligible workers.
*Prices subject to change. ^Construction Training Fund (CTF) subsidy available for eligible course participants.