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.

Currently, we have no dates scheduled for this course. Please contact us via email enquiries@cae.edu.au to register your interest.

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: May 29, 2020 04:38pm