Skip to main content

Overview

CRN Code:

22168

Start date:

16/12/2019

End date:

17/12/2019

Attendance:

Monday and Tuesday, 9:30am-5:00pm

Campus:

Glen Waverley

Price:

$490

A combination course that includes MS Excel levels 1 and 2. Designed for students with limited or no prior knowledge, this course will show you how to set up charts, create formulas, sort and filter data, analyse reports as well as suggestive ways to set up effective worksheets and automate tasks using macros. Microsoft Excel - Level 3 is also available for advanced users.


Requirements

    • USB memory stick (2GB minimum)

Outcomes

    • Navigate your way around Microsoft Excel 2016
    • Create and work with a new workbook. Open and navigate within workbooks and worksheets
    • Understand, create and work with formulas and functions used to perform calculations
    • Use font formatting techniques to greatly enhance the look of a worksheet
    • Sort and filter data in a worksheet
    • Print your workbook data
    • Create effective charts and work with tables
    • Use fill operations
    • Apply borders to cells and ranges in a worksheet
    • Use popular and common worksheet functions, and learn 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

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