Excel Essentials: Creating and Understanding Formulas

2025-100

CPD Hours:	1.00
Duration:	1 hr

$89.00 +GST Non Member

$74.00 +GST Member

Registration Closed

Event Detail

Join Sharyn for an engaging and informative one-hour Teams webinar designed for business professionals who want to enhance their Excel skills. This session will focus on creating and understanding calculations in Excel, making it easier to create efficient worksheets that contain accurate calculations and read and understand other people's formulas. Whether you're a beginner or looking to refresh your skills, this webinar is perfect.

Key Topics Covered:
• Introduction to Excel operators (e.g., *, /) and the importance of brackets in formulas.
• Understanding the role of $ dollar signs in formulas.
• Explore essential functions: SUM, MAX, MIN, AVERAGE, COUNTA, COUNT, SUMIF and COUNTIF.
• Unpacking common formulas – calculating GST and percentages
• Learn how to create and read linked formulas between worksheets.

Why Attend?
• Gain a solid foundation in Excel formulas and functions.
• Learn to create accurate and efficient calculations.
• Learn how to read and interpret formulas created by others.
• Enhance your productivity and efficiency in Excel.
• Refresh your skills and stay up-to-date with Excel best practices.

This session will also be packed with valuable tips, hints, and shortcuts to boost your efficiency in Excel. Don't miss this chance to elevate your Excel skills and become more proficient in handling calculations and formulas. Register now and join us for an hour of insightful learning and growth!

PDP Topics this Event Relates To:

Miscellaneous

Business Skills
Other

All Coming Instances

10:30AM - 11:30AM, Thu, 03 Jul 2025
Registrations Close:	02 July 2025
Class Limit:	300
Presenter:	Sharyn Baines
Online:	Webinar links will be sent to everyone registered the day prior.

Registration Closed

By clicking 'Book Now' all attendees:

Consent to the disclosure of their personal information provided to IBANZ in this booking to:

all other attendees of the webinar, and
all viewers of the recorded webinar on IBANZ's website, and
the presenters of the webinar.

Agree to our Privacy Statement found here.
Agree to the terms and conditions of the website use found here.

Terms and Conditions

Discounts are available for group bookings. Please enquire.

The running of this workshop is subject to minimum attendees.

No refund will be given if you do not notify us prior to the start of the event.

If you cannot make the session please advise so we can make the recording available on your dashboard.

Full terms and conditions are available here

Find a Broker
Search 2000+ members
from all over New Zealand