[{"newItem":true,"link":"Wherever you are in business","url":"/wherever-you-are-in-business","new_tab":"_self","description":"What ever you need, at any stage, we have you covered.","child_links":[{"newItem":true,"link":"Connect and Grow","url":"/wherever-you-are-in-business/connect-and-grow","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Support","url":"/wherever-you-are-in-business/support","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Peace of mind","url":"/wherever-you-are-in-business/peace-of-mind","new_tab":"_self","top_header_divider":false}]},{"newItem":true,"link":"Become a member","url":"/membership-overview","new_tab":"_self","description":"Membership types for every business stage.","child_links":[{"newItem":true,"link":"Employer","url":"/membership-product/employer","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Entrepreneur","url":"/membership-product/entrepreneur","new_tab":"_self","top_header_divider":false}]},{"newItem":true,"link":"Member-exclusive resources","url":"/services#member-exclusive-resources","new_tab":"_self","description":"Access to exclusive benefits and member-only programs.","child_links":[{"link":"Business Directory and Offers","url":"https://my.victorianchamber.com.au/business-directory"},{"newItem":true,"link":"Grant Finder","url":"/services/programs-and-grants/grant-finder","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Member benefit redemption","url":"/services/member-exclusive-resources/member-benefit-redemption","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Tools & templates","url":"/services/workplace-relations-and-hr/tools-and-templates","new_tab":"_self","top_header_divider":false},{"link":"Using MyPortal","url":"/myportal-help/using-my-portal","new_tab":"_self"}]},{"link":"175 years supporting Victorian Business","url":"/175-years","new_tab":"_self","description":"Take a look at how industries, society and the Chamber’s advocacy has continued to evolve since 1851."}]

[{"link":"Our courses","url":"/training-courses","description":"Explore our range of training courses designed for business success.","child_links":[{"link":"Business, Finance and Microsoft Applications","url":"/training-courses/categories:business-finance-and-microsoft-applications","new_tab":"_self"},{"link":"Cyber and AI","url":"/training-courses/categories:cyber-and-AI"},{"link":"Human Resources and Equal Opportunity","url":"/training-courses/categories:human-resources-and-equal-opportunity","new_tab":"_self"},{"link":"Leadership and Management","url":"/training-courses/categories:leadership-and-management","new_tab":"_self"},{"link":"Marketing, Sales and Customer Service","url":"/training-courses/categories:marketing-sales-and-customer-service","new_tab":"_self"},{"link":"Mental Health and Workplace Safety","url":"/training-courses/categories:mental-health-and-workplace-safety","new_tab":"_self"},{"link":"Professional and Personal Skill Development","url":"/training-courses/categories:professional-and-personal-skill-development","new_tab":"_self"},{"link":"Bundled Learning Programs","url":"/training-courses/categories:bundled-learning-programs"}]},{"link":"Our training delivery","url":"/training-courses-overview","description":"Partner with us to create a tailored training solution for your business - held at our training locations, online, or we can bring our expert facilitators and coaches to you.","child_links":[{"link":"Training your workforce","url":"/services/training-services/workplace-training","new_tab":"_self"},{"link":"Our training locations","url":"/services/training-services/our-training-locations","new_tab":"_self"},{"link":"Meet our facilitators","url":"/profiles/category/training-facilitators","new_tab":"_self"},{"link":"Vocational training","url":"/services/training-services/nationally-recognised-vocational-training","new_tab":"_self"},{"link":"Coaching","url":"/services/training-services/workplace-training/coaching","new_tab":"_self"}]},{"link":"Your future development","url":"/training-course/future-leaders-program","description":"Our flagship learning and development programs to support staff retention and career growth.","child_links":[{"link":"Future Leaders Program","url":"/training-course/future-leaders-program","new_tab":"_self"},{"link":"Chamber Change","url":"/services/programs-and-grants/chamber-change","new_tab":"_self"}]}]

[{"newItem":true,"link":"Workplace Relations, HR & Legal","url":"/services/workplace-relations-and-hr/workplace-relations-and-hr-support","description":"Support, advice and representation for all workplace matters.","child_links":[{"newItem":true,"link":"Workplace Relations and HR Support","url":"/services/workplace-relations-and-hr/workplace-relations-and-hr-support","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Workplace Relations Advice Line","url":"/services/workplace-relations-and-hr/advice-line","new_tab":"_self","top_header_divider":false},{"link":"Business Legal Support Line","url":"/services/workplace-relations-and-hr/business-legal-support-line","new_tab":"_self"},{"newItem":true,"link":"Tools and Templates","url":"/services/workplace-relations-and-hr/tools-and-templates","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Awards and wages","url":"/services/workplace-relations-and-hr/awards-and-wages","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Modern Awards Directory","url":"https://my.victorianchamber.com.au/tools-and-templates?tab=0&filter=Awards_and_Wages","new_tab":"_self"}]},{"newItem":true,"link":"Health, safety and wellbeing","url":"/services/health-safety-and-wellbeing/mental-health-and-safety-support","new_tab":"_self","description":"Support for you and your business on your workplace safety.","child_links":[{"newItem":true,"link":"Occupational Health & Safety (OHS)","url":"/services/health-safety-and-wellbeing/occupational-health-and-safety","new_tab":"_self"},{"newItem":true,"link":"Workers' compensation","url":"/services/health-safety-and-wellbeing/workers-compensation","new_tab":"_self"},{"newItem":true,"link":"Mental health","url":"/services/health-safety-and-wellbeing/mental-health","new_tab":"_self"},{"link":"Psychosocial Health Hub","url":"/services/health-safety-and-wellbeing/psychosocial-health-hub"},{"link":"Mentally Healthy Workplaces Program","url":"/services/health-safety-and-wellbeing/mental-health/mentally-healthy-workplaces-program"}]},{"newItem":true,"link":"International services","url":"/services#international-services","description":"Essential knowledge and industry contacts for doing business overseas.","child_links":[{"newItem":true,"link":"International support","url":"/services/international-services/international-support","new_tab":"_self"},{"newItem":true,"link":"ATA Carnets","url":"/services/international-services/ata-carnets","new_tab":"_self"},{"newItem":true,"link":"Export documents","url":"/services/international-services/export-documents","new_tab":"_self"},{"newItem":true,"link":"Certificates of Free Sale, Health and Manufacture","url":"/services/international-services/export-documents/trade-certificates","new_tab":"_self","top_header_divider":false},{"link":"ChamberCERTIFY®","url":"/services/international-services/chambercertify-platform","top_header_divider":false}]},{"newItem":true,"link":"Programs and grants","url":"/services#programs-and-grants","new_tab":"_self","description":"Additional services to support our members. ","child_links":[{"newItem":true,"link":"Apprenticeships and traineeships","url":"/services/programs-and-grants/apprenticeships-and-traineeships","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Chamber Change","url":"/services/programs-and-grants/chamber-change","new_tab":"_self","top_header_divider":false},{"link":"Lead the Change program","url":"/services/programs-and-grants/lead-the-change-program","new_tab":"_self"},{"link":"Unlock the value of ESG","url":"/services/programs-and-grants/unlock-the-value-of-esg","new_tab":"_self"},{"link":"Using the Australian Made logo","url":"/services/programs-and-grants/australian-made"}]},{"link":"THRIVE","url":"/services/thrive","child_links":[{"link":"THRIVE Hub","url":"/services/thrive"},{"link":"CyberSimple","url":"/services/thrive/cybersimple"}],"description":"Empowering growth and enablement for small and medium businesses."},{"link":"Support for businesses impacted by January 2026 Victorian bushfires","url":"/crisis-information/bushfires/bushfire-support-2026","child_links":null}]

Become a member

Two Day Course

Microsoft Excel - Formulas and Functions

Want to grow your Excel skills and master formulas and functions?

200 reviews

Please note: Member credits available for use on this course

Our Formulas and Functions course covers a range of Excel functions selected from the extensive Excel function library, raising your skills to intermediate and advanced levels.

Learn the skills most commonly used and required in the modern workplace including Information Functions, Rounding Functions, Mathematical Functions, Statistical Functions, Date and Time Functions, String Functions, Logical Functions, Financial Functions and Lookup Functions.

Customised options available on site at your office for groups

Remote online study

Upskill quickly with a one day session

Progress your study into other Microsoft Office programs

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 half days

Prerequisites

Participants are required to have some experience in Excel and a basic understanding of formulas and functions. They should be familiar with the use of Zoom for remote courses. Knowledge of absolute and relative references would be helpful.

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

In this workshop you will learn how to:

Use logical functions and lookup functions
Work with mathematical functions
Build complex formulas that will incorporate statistical and other functions
Manipulate and clean data with string functions
Perform calculations with date and time functions
Retrieve data on content with information functions
Perform calculations on loans and investments using financial functions

The course is presented online with a facilitator to take participants through the course content.

Learning pathway

Participants may wish to further their learning across our Microsoft Office course offering.

How to enrol

Click the ‘Register’ button on this page to register online.

Alternatively, contact the Victorian Chamber on 8662 5333 for more information.

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

You may also be interested in

Microsoft Excel – Introductory

Find out more

Microsoft Excel – Intermediate to Advanced

Find out more

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