Overview

Are you an experienced Excel user who wants to master the full potential of the software?

Our Microsoft Excel Advanced short course teaches you how to use Pivot Tables, the Outline function, Goal Seek, Validations, Data Linking, and Worksheet Linking.

This Microsoft Excel course includes more complex formulas and functions than the intermediate course, building on your existing knowledge.

Note: This course is taught on a Windows PC platform and is therefore suitable for Windows PC users only. This course is not suitable for Mac OS users.

Who should attend

This course is for working professionals who want to learn advanced Microsoft Excel skills that can be applied at work.

Skills you’ll learn

  • Advanced Excel
  • Computing
  • Problem solving
  • Time management 

Learning outcomes

  • Using and creating the Outline function
  • Using and creating the Goal Seek
  • Using and creating Validations
  • Using and creating Pivot Tables
  • Linking data to other Applications
  • Using and creating Group Worksheets
  • Linking data from various sheets into one
  • Creating and recording Macros

About your instructor

  • Terrence Yakub in a suit with a grey background

    Terrence Yakub

    Terrence has over 25 years of experience in training and management. He helps individuals develop competence and confidence in using software programs in a relevant, enjoyable and interactive manner. Terrence delivers courses and manages multi-national projects both overseas and in Australia for clients such as Australia Post, ANZ Bank, Telstra and realestate.com.au.
  • “This course exceeded my expectations by far. Our facilitator was so professional, a great teacher and very patient. Great examples were used during the course too.”

    Vanessa , Microsoft Office

Why Swinburne?

Delivered by facilitators who are industry experts

Participant course training manual

Live Online delivery allows you to do the course from anywhere

Access to our team of Customer Development Advisors

Upcoming dates
Day(s)
Time
Microsoft Excel Advanced
Day(s)
29 October 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
12 December 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
19 March 2025
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
24 June 2025
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
31 July 2025
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
27 August 2025
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
29 October 2025
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
11 December 2025
Time
09:15 AM - 04:30 PM

Download brochure

Download this document as a quick outline of the short course that can be printed and presented to your employer.
Live Online Delivery

Our Live Online delivery

Our Live Online delivery is a dynamic, engaging and interactive way to learn remotely. It’s just like face-to-face but with the added benefits of digital technology. Your facilitator will present in real-time, and you will be able to participate in group discussions and collaborate on exercises and group activities using our interactive platforms.

Related short courses