Excel - Advanced

Course Code
0417AEXC
Course Type
Short Course
Unit Code
0417MAEXC
Department
Business Services
Course Location
Morwell
Course Duration
Part Time: 1 day / 6 hours (catering provided)
1 session
Course Cost
$230.
Study Modes
On Campus; Part Time (Day)
Times
9.00am - 4.00pm
Enquiries

Contact the Short Course Hotline to express your interest in this course.
Phone: 1300 657 261
Fax: 1300 094 661
Email: shortcourses@gippstafe.edu.au

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

Date
Campus
Time
Description
5 June
Morwell
9.00am-4.00pm
Excel Adv 5/06