Course Overview

This course will take current Microsoft Excel users to the next level by extending their knowledge and skills in the more advanced areas of Excel such as goal seeking, linking, macros, web publishing and PivotTables.

Course structure

In this course you will learn about:

• Nesting functions
• Advanced filters
• Validations
• Goal seeking
• Data tables
• Scenarios
• Pivot tables
• Linking workbooks
• Consolidation
• Excel on the web
• Summarising data
• Macros virus control
• Recorded macros
• Recorder workshop.

Is this course right for me?

This course is designed for current Microsoft Excel users who wish to extend their knowledge and skills in the more advanced areas of Excel.

Qualifications And Recognition

Upon completion of this course students will receive a Statement of Participation.

Recognition of Prior Learning (RPL)

Many GippsTAFE courses offer Recognition of Prior Learning (RPL). Click to learn more about RPL and how it can benefit you.

Entry Requirements

Participants should be current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and use a variety of functions and formulas, have a basic understanding of absolute and relative referencing, be able to use names and labels and sort lists.

How To Apply

Direct to Institute

Assessment

There is no assessment for this course.

Course Times

CAMPUS	TIME	DATE	SESSION
Warragul	9.00am-4.00pm	4th June	WBUS0EXCA1
Morwell	9.00am-4.00pm	27th June	MIT0EXCA2