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: 22 Mar; 24 May 16 Aug; 11 Oct; 15 Nov
DURATION: 5 hours
LOCATION: West Perth
DATES: Contact Albany for course details.
DATES: Contact Bunbury for course details
DATES: Contact Geraldton for course details.