Skip to main content


CRN Code:


Start date:


End date:



Thursday, 9:30am-5:00pm


Glen Waverley



Expand your computing knowledge of excel and provide answers to more complex tasks. Topics include; formulas, complex printing, intricate charting, data sorting and filtering and working more effectively with existing worksheets and workbooks.


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


    • Use the fill operations available to fill a data series
    • Use a range of techniques to work with worksheets
    • Apply a variety of page setup techniques
    • Apply borders to cells and ranges in a worksheet
    • Use common worksheet functions
    • Create more complex formulas and functions
    • Create and use defined names in a workbook
    • Apply a range of number formatting techniques to worksheet cells
    • Apply conditional formatting to ranges in a worksheet
    • Use goal seeking to determine the values required to reach a desired result
    • Understand and use Excel's Quick Analysis tools
    • Create and work with tables
    • Use a range of elements and features to enhance charts
    • Select and change the format of objects in a chart

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