Excel Essentials: Creating and Understanding Formulas 3-7-25

V368XCEL

1.00 CPD Hours

$89.00 +GST Retail
$74.00 +GST Learning Partner

Learn Module Detail

By: Sharyn Baines, Excel at Work

Duration: 57:15

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
 

Login





Forgot password?
Create an Account
Find a Broker
Search 2000+ members
from all over New Zealand