COVID-19 updates
,
Home | Courses | Microsoft Excel Advanced Skill Set

Microsoft Excel Advanced Skill Set

State ID: IAA34

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

Entrance Requirements

How to apply

Entrance Requirements

Microsoft Excel Intermediate, or equivalent experience

How to apply

To apply please contact North Regional TAFE on 1300 996 573, email info@nrtafe.wa.edu.au, drop into your local campus, or complete the online Course enquiry form at the bottom of the page.

Delivery location, important dates and study options

Semester 1, 2020

Broome Campus - 16 April, 2020

Overview

Units

Overview
Duration 2 days
When 16 April, 2020
Where Broome Campus
How Face-to-face classroom delivery
Fee

$307.30

Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Karratha Campus - 2 - 3 April, 2020

Overview

Units

Overview
Duration 2 days
When 2 - 3 April, 2020
Where Karratha Campus
How Face-to-face classroom delivery
Fee

$307.30

Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Pundulmurra (South Hedland) Campus - 30 June - 1 July, 2020

Overview

Units

Overview
Duration 2 days
When 30 June - 1 July, 2020
Where Pundulmurra (South Hedland) Campus
How Face-to-face classroom delivery
Fee

$307.30

Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Pundulmurra (South Hedland) Campus - 5 - 6 May, 2020

Overview

Units

Overview
Duration 2 days
When 5 - 6 May, 2020
Where Pundulmurra (South Hedland) Campus
How Face-to-face classroom delivery
Fee

$307.30

Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.

Semester 2, 2020

Karratha Campus - 5 - 6 November, 2020

Overview

Units

Overview
Duration 2 days
When 5 - 6 November, 2020
Where Karratha Campus
How Face-to-face classroom delivery
Fee

$307.30

Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.

Course enquiry

Page last updated February 07, 2020