Home | Short courses | MICROSOFT EXCEL ADVANCED

MICROSOFT EXCEL ADVANCED

State ID: P178

 

Develop skills in advanced analysis and automation tools using Microsoft Excel.

This course teaches participants how to successfully produce spread sheets for their business management and information analysis needs.

Topics covered:

  • Lookup and reference functions
  • Modifying Excel options
  • Customised formatting of charts
  • Labels and names in a workbook
  • Data protection
  • Summaries using subtotals
  • Data linking and consolidation
  • Pivot tables, group cells and outlines
  • Using the solver tool
  • Using macro recorder

Units covered: 
BSBITU402 Develop and use complex spreadsheets

Pre-requisites

Study pathway

Job opportunities

Pre-requisites
Study pathway
Job opportunities

Delivery location, important dates and study options

Overview

Outline

Fees and charges

About the lecturer

Other requirements

Overview

Course Overview

Where Tom Price
Duration 2 days, 8.30am - 4.30pm

HowFace To Face
When

Tom Price

8 - 9 August

Outline
Fees and charges

$306.85

About the lecturer
Other requirements
Enquire now
Call us
Email us

Course enquiry

You can enrol over the phone by calling 1300 996 573, or in-person at your nearest North Regional TAFE campus.

Once you have enrolled, you have the option to withdraw or transfer your registration for up to five days prior to delivery of the course. Customer cancellation or rescheduling within five business days of the course commencement will be subject to the full course fee unless bookings exceed minimum numbers. In the event of rescheduling or cancellation of a course, North Regional TAFE will endeavour to transfer your booking across to the next available course but no guarantee can be given. In this event you will be eligible for a full refund.

Entrance Requirements

School Leaver Non-School Leaver AQF

You can enrol over the phone by calling 1300 996 573, or in-person at your nearest North Regional TAFE campus.

Once you have enrolled, you have the option to withdraw or transfer your registration for up to five days prior to delivery of the course. Customer cancellation or rescheduling within five business days of the course commencement will be subject to the full course fee unless bookings exceed minimum numbers. In the event of rescheduling or cancellation of a course, North Regional TAFE will endeavour to transfer your booking across to the next available course but no guarantee can be given. In this event you will be eligible for a full refund.

Entrance Requirements

School Leaver Non-School Leaver AQF

Qualification level

Clean up clone

Link to photo for PDF:

Photo override if needed:

Course title:

National and state ID:

About this course:

Overview:

Entrance requirements:

Entrance requirements additional text:

Prerequisites

Study pathway

Job opportunities

Important information

Fees and charges

How to apply

Print units tab

Units

Generic info:

Page last updated June 26, 2019