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

Microsoft Excel Advanced Skill Set

State ID: IAA34

Your health and safety is important to us.

Spaces are limited in face-to-face classes to adhere to social distancing guidelines. Additional hygiene protocols will be implemented and other controls may apply. Students must follow the directions of the lecturer to ensure the health and safety of all students and teaching staff.

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

 

lower fees local skills logo_0_0_0.png

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 2, 2020

Broome Campus - 12 - 13 October, 2020

Overview

Units

Overview
Duration 2 days
When 12 - 13 October, 2020
Where Broome Campus
How Face to face
Fee

Lower fees, local skills price
Full fee: $111.70
Concession: $43.30

Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.
Karratha Campus - 5 - 6 November, 2020

Overview

Units

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

Lower fees, local skills price
Full fee: $111.70
Concession: $43.30

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

Course enquiry

Page last updated September 21, 2020