It’s free to join the Victorian Chamber Community!

It’s free to join the Victorian Chamber Community!

Sign up and receive the latest business news and updates, opportunities to network and shape Advocacy from Victoria’s largest and most influential partner.

It’s free to join the Victorian Chamber Community!

One Day Course

Microsoft Excel - Intermediate to Advanced

This course offers the opportunity for Excel users to expand their knowledge and raise their skill level.

Please note: Member credits available for use on this course

There is emphasis on formulas and functions along with advanced formatting and data management. The course is aimed at users who understand the basics of Excel and are ready to take the next step. 

Save more when you train together. Get tailored workplace training and save up to 60%. Find out more.

Duration

This is a one-day course delivered over two days (3.5 hours/day)

Prerequisites

Participants are required to have completed a beginner course in Excel or possess equivalent experience. They should be capable of creating, editing, and printing simple worksheets, as well as entering basic formulas and functions. They should be familiar with the use of Zoom for remote courses.

Technological Requirements

It is recommended attendees utilise two screens on the day of training, one for the facilitator’s presentation and one to complete the exercises. Attendees must have a computer or laptop with Microsoft Excel and Zoom installed. Windows software for PCs is recommended for this course. This course is suitable for all versions of Excel. An internet connection is also required.

Learning outcomes

At the completion of this course the attendee will be able to:

  • Define and use range names and labels in a workbook
  • Work with logical functions
  • Work with lookup and reference functions
  • Apply advanced formatting features
  • Set conditional formatting
  • Setup and utilise data validation features
  • Use subtotalling
  • Understand and create Pivot Tables
  • Use advanced Pivot Tables techniques
  • Create Pivot Charts
Who is this course suitable for?

This course is designed for individuals who have a foundational understanding of MS Excel and are prepared to advance their skills to the next level.

 

You will earn a Victorian Chamber Digital Credential on completion of this course. 

Credly VCCI Lockup

Training Enquiry

First Name*

*

Last Name*

*

Email*

*

Mobile Number*

*

Company Name*

*

The course I am interested in*

*

How can we help you?*

*
Form submited

Training FAQs

Can I use credits or entitlements when booking a training course online?

Yes you can and it’s as easy as selecting your chosen training course, following the payment prompts and selecting your entitlements as the payment method.

This excludes any partnership courses, find out more.

Why can't I see the member price when I try to make a booking online even though I am a member?

Kindly contact a customer service consultant who will be able to assist via Contact us.

Why am I unable to access member resources and member pricing when I log into my account?

Your membership account may be currently on suspend. If you like, we can send you through a copy of your renewal invoice. Kindly contact a customer service consultant who will be able to assist via Contact us.

Who should I contact if I am having trouble completing a registration online?

The Customer Service team would be happy to complete the registration for you. Simply advise the following: 1. The event name and session (i.e. date and time) 2. the attendees name, email address, position title (and dietary requirements if in-person) 3. how much of available credits should be applied to the registration. Kindly contact a customer service consultant who will be able to assist via Contact us.

What should I do if I am unable to log into my Victorian Chamber account?

The Customer Service team can manually reset your Victorian Chamber online account and email you further information on the login details. Kindly contact a customer service consultant who will be able to assist via Contact us and provide your membership number or trading name, your name, email address, and contact number. We will then arrange for a new password.

 

Will I earn a digital badge?

A badge is a digital way to represent your certification achievement. We are pleased to have partnered with Credly to provide you with a digital version of your credentials for some of our training courses. If the course you are registering for is eligible for a badge, you will see the Credly logo on this page. Click here for more information.

Are all courses delivered online as well as in-person?

Most of our courses are offered online as well as in-person.  However, due to the content and structure of some courses they may be offered either online or in-person. If you cannot find the course you are after, kindly contact a customer service consultant who will be able to assist via Contact us.

How are Online courses delivered?

Online courses are delivered using zoom. Details on how to log in, the zoom link and course materials will be emailed to the participant prior to the course commencement.

Does the Victorian Chamber offer WorkSafe approved courses?

Yes, the Victorian Chamber offers 4 WorkSafe approved courses.  1. HSR Initial OHS Training Course  2. HSR Refresher OHS Training Course (Plant)   3. HSR Refresher OHS Training Course (Work-related Violence)  4.HSR Refresher OHS Training Course (Work-related Stress)                                            

If an organisation has several staff that require training, can courses be delivered onsite?

Yes, all of our courses can be delivered onsite. Most courses can be tailored to suit your  requirements. For more information contact our onsite team on 03 8662 5196 or email onsitetraining@victorianchamber.com.au

Does the Chamber offer self-paced learning?

Yes, we offer self-paced learning. The details are available on our website.

Can I use credits or entitlements to pay towards a training course?

Yes you can and it’s as easy as selecting your chosen training course, following the payment prompts and selecting your entitlements as the payment method. Find out more.

Can I use credits or entitlements to pay towards onsite training?

Yes, you can use credits or entitlemets to pay towards onsite training. For more information contact our onsite team on 03 8662 5196 or email onsitetraining@victorianchamber.com.au

Microsoft Excel - Intermediate to Advanced
Member:
$495 (GST excl.)
Non-Member:
$625 (GST excl.)

15 Dec - 16 Dec 2026

Register
Facilitated by: Duane Hardie

Online Workshop

27 May - 28 May 2027

Register
Facilitated by: Duane Hardie

Online Workshop

Group bookings and corporate pricing

Booking for more than one person?
Switch to teams and save up to 60%*
Train as a team for maximum impact, minimal disruption, at a better price.
Save on group bookings - Enjoy lower per-person rates than individual fees.
Flexible delivery - We'll come to you anywhere in Victoria, host your team in Melbourne CBD, or deliver online.
Tailored training - Expert facilitators design sessions around your team’s roles, challenges, and goals.

Individual bookings for scheduled dates

Looking for our pre-scheduled dates
for this course? Switch to individual.

View our terms and conditions

View our terms and conditions

Member:
$495 (GST excl.)
Non-Member:
$625 (GST excl.)
Train as a team for maximum impact, minimal disruption, at a better price.
Team Course Enquiry

Interested in training your team?
Get a quote now.

Whether you want to upskill your team onsite at your workplace, online, or prefer a dedicated session at our modern training facilities, our workplace training options are designed to deliver maximum impact with minimal disruption, at a better price.

Interested in training your team? Get a quote now.

Ready to become a member?

Victorian Chamber membership gives you access to specialist advice and information, which allows you to reclaim your time and resources and concentrate on building a brighter future for your business.

Customised training at your workplace

We can bring our expert facilitators to you and your team, at a time and day that works for you.

Restricted Page

You are being redirected to our login page!