Excel - Formulas & Auditing
Designed to elevate your Excel skills beyond basic calculations.
Timezone:
Melbourne Australia
27 February 2025
12:00 pm to 2:30 pm
Delve into the world of formulas beyond the basic SUM, AVERAGE, MIN, MAX formulas, and gain essential techniques to create, audit, and understand more advanced formulas like IF, AND, OR functions and how to insert any function into your spreadsheet.
Uncover Excel’s error detection tools, and learn to easily keep an eye on values cross multiple sheets. You will also discover the Goal Seek tool that allows you to change the answer you get from a calculation or formula to one you would rather see instead.
Don’t miss out on this opportunity with expert trainer Derek F Bradshaw from knowitinc.com and broaden your Excel knowledge and skills!
Prerequisites
Participants are expected to have a basic understanding of Excel and its core functionalities or have attended the Excel Calculation Basic training. Familiarity with basic calculations, spreadsheet navigation, data entry, and basic formatting will be beneficial. This course is designed for users of all levels, making it suitable for beginners eager to learn, or long time Excel users looking to refine their formula skills.
Topics
Formula Techniques
- Using logical functions (IF)
- Nesting functions for complex calculations (AND, OR)
- Using the fx button to insert functions
- Additional Resources for learning more functions
Formula Auditing Tools
- Tracing precedents and dependents
- Evaluating formula errors and understand error types
- Using the Watch Window to monitor cell values dynamically
- Changing the answer to a calculation or formula using Goal Seek
By the end of this course, you'll understand how to create Excel formulas, conduct formula audits, and watch numbers update in other sheets with ease. Don't miss this opportunity to boost your Excel expertise – book now and take the first step toward becoming an Excel formula master!
Don't miss out - boost your Microsoft Excel skills today!
Location
Online Live with a trainer
Date and Time ( Melbourne Australia 🇦🇺 time)
27 February 2025
12:00 pm 2:30 pm
With World Time Buddy, you can easily convert times across different timezones, helping you determine if you can join this live online session from anywhere in the world.
Duration
Approx 2.5 Hours
Session may end sooner or later depending on various factors in the session like interactions, questions, pacing of the attendees, etc.
Price in New Zealand Dollars
Only $250 per person + 15% GST = $287.50
Early Bird Seat = $200 per person + 15% GST = $230
This is an online training session open to the public.
Contact us if you would like to arrange this as a private online training session for your team instead, or for it to conducted in-person at your location.