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

  • Professional looking man in a suit and tie smiling at the camera.

    Terrence Yakub

    Terrence develops software training programs tailored to individuals who want to become more competent and confident.
  • “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)
30 May 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
31 July 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Advanced
Day(s)
27 August 2024
Time
09:15 AM - 04:30 PM
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
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