Excel - Formulas & Auditing
Designed to elevate your Excel skills beyond basic calculations.
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.
Location
Online Live with a trainer
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.
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!
Price in Australian Dollars
Only $250 per person + 10% GST = $275
Early Bird Seat = $200 per person + 10% GST = $220
Additional Fees:
- Card, transaction, and currency conversion fees may apply where applicable.
Payment Methods:
- Multiple currencies accepted.
- Pay easily with debit or credit including with and more.
- We recommend checking the current exchange rate if you are paying in a different currency.
Important Notes:
- Prices may change without notice.
- All course fees are non-refundable. This means no refunds will be given for cancellations, withdrawals, or non-attendance. This policy helps us maintain high standards and session integrity, and manage costs for our global participants. Please book carefully and make sure you can attend the session(s).
Book on this session
- Please use the Register button at the top of the page to book yourself, someone else or a group.
- Create a new account during registration to easily manage your bookings, or log in to your existing account.
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.