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

This course is currently undergoing delivery planning and information will be available on our website shortly. Check back later, or use the course enquiry form below to have our Client Contact Centre contact you with further information about the next course start, delivery locations and study modes.

Course enquiry

Page last updated July 24, 2019