Excel 2016 Advanced

We provide a range of nationally recognised qualifications (local government specific) and council-specific non-accredited short courses as well as other professional development training options.

Who should Attend?

The skills and knowledge acquired in Microsoft Excel 2016 - Advanced are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

Learning Outcomes

Expand their skills and knowledge in using Microsoft Excel in order to apply more complex formulas, functions along with other more advance level uses of Microsoft Excel 2016.

Short Course details

Short Course Topics
Modify Excel options
Protect data in worksheets and workbooks
Import data into Excel and export data from Excel
Use data linking to create more efficient workbooks
Group cells and use outlines to manipulate the worksheet
Create summaries in your spreadsheets using subtotals
Use the Data Consolidation feature to combine data from several workbooks into one
Create, use and modify data tables
Create and work with scenarios and the Scenario Manager
Understand and create simple PivotTables
Construct and operate PivotTables using some of the more advanced techniques
Create and edit a PivotChart
Use advanced filters to analyse data in a list
Use a variety of data validation techniques
Create and use a range of controls in a worksheet
Share workbooks with other users
Create recorded macros in Excel
This course is delivered as a face-to-face instructor led training sessions. Our courses can be customised to suit your particular requirements.
Duration & location
Our standard structure for this course is 1 full day and can be delivered in any metropolitan or regional area of Queensland.
Fees & Inclusions
Please contact Peak Services for course fees or a proposal for onsite/in-house training.


Book Now

Upcoming Dates: