Course Summary

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

Course Sessions

Wednesday, 25th September - 2 classes


Session ID SRAO7603C
25 Sep - 2 Oct 9:30am - 4:30pm
Location CAE
Session Fees
$345 / $328 (conc)
Teacher
Ananda Sim

Tuesday, 3rd December - 2 classes


Session ID SRAO7604C
3 Dec - 10 Dec 9:30am - 4:30pm
Location CAE
Session Fees
$345 / $328 (conc)
Teacher
Ananda Sim

At the completion of this course you should be able to:

  • 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

Microsoft Excel 2016 - Level 3 assumes some knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.

Please bring along a USB stick in order to save your work.

Last updated: August 16, 2019 04:40pm