Skip to main content


CRN Code:


Start date:


End date:



Thursday, 9:30am-5:00pm





Advance your excel computing skills to include advanced analysis tools, pivot tables, outlining and summarising and some key automation features such as macros.


    • USB memory stick (2GB minimum)
    • Prior experience with MS Excel 2013 or completion of MS Excel 2016 � Level 2 is required


    • Modify Excel options
    • Protect date 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
    • Use outlines to manipulate the worksheet
    • Create summaries in your spreadsheets using subtotals
    • Consolidate data from several worksheets. Create, use and modify data tables
    • Create and work with scenarios and the Scenario Manager
    • Understand and create simple PivotTables. Construct and operate advanced PivotTables
    • Create and edit 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
    • Create recorded macros in Excel

Enquire Now

Contact details

All information is correct at the time of printing but subject to change.

Copyright © 2019 Holmesglen CRICOS Provider Code: 00012G RTO-0416 ABN: 40 096 756 729