Skip to main content

Overview

CRN Code:

22132

Start date:

21/09/2019

End date:

21/09/2019

Attendance:

Saturday, 9:30am-5:00pm

Campus:

Moorabbin

Price:

$290

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.


Requirements

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

Outcomes

    • 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