[{"newItem":true,"link":"Workplace Relations & HR","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},{"newItem":true,"link":"HR Tools and Templates","url":"/services/workplace-relations-and-hr/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":"/services/workplace-relations-and-hr/awards-and-wages/modern-awards-directory","new_tab":"_self"}]},{"newItem":true,"link":"Training and development","url":"/training-courses-overview","description":"Enhance the skills of employees spanning all sectors.","child_links":[{"newItem":true,"link":"Workplace training","url":"/services/training-services/workplace-training","new_tab":"_self"},{"newItem":true,"link":"Vocational training","url":"/services/training-services/nationally-recognised-vocational-training","new_tab":"_self"},{"newItem":true,"link":"Self-paced learning","url":"/training-courses/types:self-paced","new_tab":"_self"},{"newItem":true,"link":"Our training locations","url":"/services/training-services/our-training-locations","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Upcoming training courses","url":"/training-courses/","new_tab":"_self"}]},{"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":"Trade certificates","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":"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":"Mental health","url":"/services/health-safety-and-wellbeing/mental-health","new_tab":"_self"},{"newItem":true,"link":"Workers' compensation","url":"/services/health-safety-and-wellbeing/workers-compensation","new_tab":"_self"}]},{"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},{"newItem":true,"link":"SummerTech LIVE","url":"/services/programs-and-grants/summertech-live","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"YAY Placement Program","url":"/services/programs-and-grants/youth-activating-youth","new_tab":"_self","top_header_divider":false}]},{"newItem":true,"link":"Think Beyond","url":"/services/think-beyond","new_tab":"_self","description":"Get that business edge by being ahead of the curve.","child_links":[{"newItem":true,"link":"Unlock the value of ESG","url":"/services/think-beyond/unlock-the-value-of-esg","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Get the workforce edge","url":"/services/think-beyond/get-the-workforce-edge","new_tab":"_self","top_header_divider":false}]}]

[{"newItem":true,"link":"Key policy areas","url":"/policy-and-advocacy","new_tab":"_self","description":"The Victorian Chamber is a trusted advocate at all levels of government. We work closely with our members, stakeholders and government officials to create a better business environment.","child_links":[{"newItem":true,"link":"Energy","url":"/policy-and-advocacy/energy","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Industrial relations","url":"/policy-and-advocacy/industrial-relations","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Industry, innovation and commercialisation","url":"/policy-and-advocacy/industry-innovation-and-commercialisation","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Infrastructure","url":"/policy-and-advocacy/infrastructure","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Regional development","url":"/policy-and-advocacy/regional-development","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Skills and training","url":"/policy-and-advocacy/skills-and-training","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Tax and regulatory reform  ","url":"/policy-and-advocacy/tax-and-regulatory-reform","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Visitor economy","url":"/policy-and-advocacy/visitor-economy","new_tab":"_self","top_header_divider":false}]},{"newItem":true,"link":"Initiatives","url":"/policy-and-advocacy/initiatives","new_tab":"_self","child_links":[{"newItem":true,"link":"Career Services Policy Paper","url":"/policy-and-advocacy/initiatives/career-services-policy","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Cyber Security and Scams","url":"/policy-and-advocacy/initiatives/cyber-security-and-scams","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Achieving a Net-Zero Economy: Roadmap for Victorian Businesses","url":"/policy-and-advocacy/initiatives/netzero","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Regulatory Reform Policy Paper","url":"/policy-and-advocacy/initiatives/regulatory-reform-policy-paper","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"State and Federal budgets","url":"/policy-and-advocacy/initiatives/state-and-federal-budgets","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"State and Federal elections","url":"https://www.victorianchamber.com.au/policy-and-advocacy/initiatives/state-and-federal-elections","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Policy and Advocacy news","url":"/news-filter/categories:policy-and-advocacy","new_tab":"_self","top_header_divider":false}],"description":"View our recent policy & advocacy submissions and priority initiatives."},{"newItem":true,"link":"Taskforces","url":"/policy-and-advocacy/taskforces","new_tab":"_self","child_links":[{"newItem":true,"link":"Housing Taskforce","url":"/policy-and-advocacy/taskforces/housing-taskforce","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Agribusiness Taskforce","url":"/policy-and-advocacy/taskforces/agribusiness-taskforce","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Cost and Ease of Doing Business in Victoria Taskforce","url":"/policy-and-advocacy/taskforces/cost-and-ease-of-doing-business-in-victoria-taskforce","new_tab":"_self","top_header_divider":""},{"newItem":true,"link":"Health Industry Taskforce","url":"/policy-and-advocacy/taskforces/health-industry-taskforce","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Higher Education Taskforce","url":"/policy-and-advocacy/taskforces/higher-education-taskforce","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"International Engagement Taskforce","url":"/policy-and-advocacy/taskforces/international-engagement-taskforce","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Small Business Taskforce","url":"/policy-and-advocacy/taskforces/small-business-taskforce","new_tab":"_self","top_header_divider":false},{"newItem":true,"link":"Transport Taskforce","url":"/policy-and-advocacy/taskforces/transport-taskforce","new_tab":"_self","top_header_divider":false}],"description":"Our taskforces draw on the expertise of our members and industry leaders to explore specific issues relevant to the business community in Victoria."}]

Become a member

Want to grow your Excel skills and become and whiz with formulas and functions? 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.

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

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.

Need training for more than 5 people? Save up to 60% with workplace training. Find out more.

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

Duration

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

What will I learn in this course?

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.

Who is this course suitable for?

This workshop is suitable for participants with some experience in Excel and a basic understanding of formulas and functions.

Attendees should be familiar with the use of Zoom for remote courses.

Technology requirements

Access to a computer or laptop with Microsoft Excel 2016 installed and an internet connection. Two screens are recommended – one screen for the facilitator’s presentation and one to complete the exercises.

Attendees should be familiar with the use of Zoom for remote courses.

Your learning journey

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

How do I register for this course?

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

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

You may also be interested in

Microsoft Excel 2016 – Introductory Get acquainted and comfortable with all things Excel in our introductory course, suitable for beginners and experienced users seeking skill advancement. Learn more... Attend a course	Microsoft Project Introduction Master project management essentials: navigate, format, create tasks, assign resources, track progress, and generate reports with our comprehensive course. Learn more... Attend a course
Microsoft Excel 2016 - Formulas and Functions Gain a deeper understanding of formulas and functions with our course, empowering users at intermediate to advanced levels. Learn more... Attend a course	Microsoft Excel 2016 Intermediate to Advanced Boost your Excel skills with a focus on advanced formatting, effective data management techniques and formulas. Learn more... Attend a course

Training Enquiry

First Name*

Last Name*

Email*

Mobile*

Company Name

The course I am interested in*

Optional message

Please enter the code below*

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 on 03 8662 5211, or email customerservice@victorianchamber.com.au A login & password can be set up for you to access your member account.

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 call a customer service consultant to assist you on 03 8662 5211, or email customerservice@victorianchamber.com.au

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. Email your response to Customerservice@victorianchamber.com.au or via phone on 03 8662 5211

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. Please email Customerservice@victorianchamber.com.au or via phone on 03 8662 5211 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, please email Customerservice@victorianchamber.com.au or call the Cutomer Service Team on 03 8662 5211

How are Online courses delivered?

Online courses ae 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 Office Application Consultants

Duane Hardie

Software Applications Trainer and Facilitator

View bio

Show all

View pricing and register below:

Online | 9 May 2024 - 10 May 2024

Limited tickets remaining

Online | 8 Aug 2024 - 9 Aug 2024

View our terms and conditions

It’s free to join the Victorian Chamber Community!

It’s free to join the Victorian Chamber Community!

MyPortal Login

Fair Work Act Closing the Loopholes – what employers need to know.

Grant Finder Webinar

ASA secures apprentice and trainee support contract

Victorian Chamber welcomes respectful outcome for CBD businesses

Fair Work Act Closing the Loopholes – what employers need to know.

Grant Finder Webinar

Microsoft Excel 2016 - Formulas and Functions

Microsoft Excel 2016 - Formulas and Functions

View pricing and register below:

Duration

What will I learn in this course?

Who is this course suitable for?

Technology requirements

Your learning journey

How do I register for this course?

You may also be interested in

Microsoft Excel 2016 – Introductory

Microsoft Project Introduction

Microsoft Excel 2016 - Formulas and Functions

Microsoft Excel 2016 Intermediate to Advanced

Training Enquiry

Training FAQs

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

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

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

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

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

Will I earn a digital badge?

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

How are Online courses delivered?

Does the Victorian Chamber offer WorkSafe approved courses?

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

Does the Chamber offer self-paced learning?

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

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

Microsoft Office Application Consultants

Duane Hardie

Share:

View pricing and register below:

DATE AND TIME

Location

Cost

$495.00 (GST excl.)

$625.00 (GST excl.)

Cost

DATE AND TIME

Location

Cost

$495.00 (GST excl.)

$625.00 (GST excl.)

Cost

Related training courses

Microsoft Excel 2016 - Formulas and Functions

Microsoft Excel 2016 - Introductory

Finance for Non-Finance People

Microsoft Excel 2016 - Intermediate to Advanced

Privacy for Business

Microsoft Excel 2016 - Advanced

Introduction to Exporting - Self-paced Learning

Exporting: Documentation - Self-paced Learning

Exporting: Money Matters - Self-paced Learning

Exporting: Getting Goods to Market - Self-paced Learning

Environmental, Social and Governance (ESG) Fundamentals - Self-paced Learning

CyberSimple Starter - Self-paced Learning

Microsoft Word Advanced

Understanding and Managing Costs

Microsoft PowerPoint Intensive

Analysing and Evaluating Business Performance

Budgeting Fundamentals

Finance for Small Business Owners (for Non-Finance People)

Export/Import Certificate (EIC) - Self-paced Learning

Incoterms® 2020 Certificate (INCO) - Self-paced Learning

Sustainable Business & ESG Workshop

Microsoft Excel 2016 - Formulas and Functions

Microsoft Excel 2016 - Introductory

Finance for Non-Finance People

Microsoft Excel 2016 - Intermediate to Advanced