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

Half price*

This course is part of the Lower fees, local skills initiative, allowing you to pay just half of the standard course fees for training in 2020-21.

The following people will be eligible for the $400 annual course fees cap under Lower fees, local skills

  • Persons aged 15—24 years at the time of enrolment (excluding students enrolled at school)
  • Persons and dependents of persons receiving JobKeeper payment
  • Persons and dependents of persons in receipt of services from one of the following Commonwealth support or employment services programs:
    • Jobactive
    • Online Employment Services
    • ParentsNext
  • Persons and dependents of persons receiving the Youth Allowance, AUSTUDY or ABSTUDY
  • Persons and dependents of persons holding:
    • a pensioner concession card or  Health Care Card; or
    • Repatriation Health Benefits Card issued by the Department of Veterans' Affairs
  • Dependents of persons who are inmates of a custodial institution

Please note that only course fees are half price for the Lower fees, local skills qualifications. You may be required to pay other fees that apply to your course. For more details about how the half price course fees and annual fees cap work, please read our FAQs or contact us.

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, 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 - 7 - 8 December, 2020



Duration 2 days
When 7 - 8 December, 2020
Where Broome Campus
How Face to face

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 November 26, 2020