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

Karratha Campus - 6 November - 11 Decmeber, 2019

Overview

Units

Overview
Duration 2 days
When 6 November - 11 Decmeber, 2019
Where Karratha Campus
How Face-to-face classroom delivery
Fee

$306.85

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

Course enquiry

Page last updated July 24, 2019