fbpx Microsoft Excel Advanced Skill Set | North Regional TAFE

Microsoft Excel Advanced Skill Set

Share this course on your social media page

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
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 2021.

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

^ You will pay half price for the course fees on the Lower fees, local skills courses, however other fees may apply such as for resources that are specifically needed for your training.

Skill-sets

This is a targeted skill set related to the Skills Ready program, which is aimed at rebuilding our local businesses and communities with free and reduced-price training. Other skill sets can be found on our Skill sets and short courses (opens in a new tab) page.

Lower fees, local skills price

Full fee: $111.70
Concession: $43.30

Delivery locations and study options

Semester 1

Details
Duration 2 Days
When Semester 1
Where Karratha Campus
How On campus

Semester 2

Details
Duration 2 Days
When Semester 2
Where Karratha Campus
How On campus
Details
Duration 2 Days
When Semester 2
Where Karratha Campus
How On campus

Get help

Preferred contact method
Preferred delivery mode
Have you studied with us before?