MS Excel ® 2016 Advanced
4 hours
Course Duration
Perth
Locations
Please contact your local office for upcoming dates.
Course Start date
About this Course
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.
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.
Course Structure
Course Duration: 4 hours
How to Apply