Skip to main content

Overview

CRN Code:

22136

Start date:

23/08/2019

End date:

23/08/2019

Attendance:

Friday, 9:30am-5:00pm

Campus:

Moorabbin

Price:

$290

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


Requirements

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

Outcomes

    • 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