[{"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

This course is about advanced features of Excel with the emphasis on the data side of workbooks. It is aimed at users who have experience with Excel and wish to add to their knowledge and increase their skill level beyond simple worksheets.

This course is setup for Excel in the Windows environment, it is more suitable for PC users.

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.

Prerequisites

Attendees will be well familiar with the Excel environment and Excel basics. They will have a strong understanding of Excel workbooks and worksheets.

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

Objectives

Participants will be instructed in a variety of Excel features using examples that are at advanced levels with the aim of learning how to create complex and professional spreadsheets.

Learning Outcomes

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

Utilise Quick Analysis
Filter data
Combine data in multiple tables
Create tables from data
Provide protection to worksheets
Import data from external sources
Use data to create pivot charts
Create and use controls

Course Duration

This is a one-day course split into two sessions carried out over two days. Each day the duration of the course will be 3½ hours. The sessions may be run in the morning or the afternoon of their allocated day.

Delivery Method

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

Questions may be asked during the presentation.

Participants will have their own computer and it is recommended they have 2 screens. One screen for the facilitators presentation and one to complete the exercises.

Course material and exercises will be provided.

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

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 | 20 Jun 2024 - 21 Jun 2024

Limited tickets remaining

Online | 2 Sep 2024 - 3 Sep 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 - Advanced

Microsoft Excel 2016 - Advanced

View pricing and register below:

Prerequisites

Objectives

Learning Outcomes

Course Duration

Delivery Method

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

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