Overview

Upgrade your spreadsheet skills with our Microsoft Excel Intermediate short course to improve your efficiency and organisation at work.

You'll learn how to use shortcuts, complex functions, relative and absolute formulas. 

Approach Excel tasks with more confidence as you explore useful methodologies and learn the tools for financial and logical calculations.

We'll also teach you timesaving tools such as Auto filling and Sequential filling to reduce the time spent on manual tasks. Discover how to work with Custom Lists and gain new insights faster by learning data manipulation with VLOOKUP.

Who should attend

This course is for anyone who used Microsoft Excel at work and wants to advance their skills and knowledge beyond simple workbooks to perform more complex tasks.

Skills you’ll learn

  • Intermediate Excel
  • Computing
  • Problem solving
  • Time management 

Learning outcomes

  • Autofilling and Sequential Filling
  • Creating, editing and deleting a Custom List
  • Creating Excel Formulas using Relative and Absolute Addressing
  • Using Mathematical functions, VLOOKUP function, IF function and PMT function
  • Sorting
  • Auto Filtering
  • Calculations using an Auto Filter

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 Intermediate
Day(s)
11 July 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
23 July 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
6 August 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
22 August 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
25 September 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
16 October 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
20 November 2024
Time
09:15 AM - 04:30 PM
Microsoft Excel Intermediate
Day(s)
3 December 2024
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