ALGIM Training Session: Excel Formulas and Auditing

Unlock the full potential of Microsoft Excel with our comprehensive 2-hour course on mastering formulas and auditing techniques. Whether you're a beginner looking to delve into the world of Excel or an experienced user seeking to enhance your skills, this session is tailored for you. In this course, we'll guide you through the essentials of creating powerful formulas, conducting formula audits for error detection, and enabling seamless data tracking across multiple sheets. Join us to elevate your Excel proficiency and gain the confidence to navigate through complex workbooks with ease.

Prerequisites

Participants are expected to have a basic understanding of Excel and its core functionalities. Familiarity with 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 advanced users looking to refine their formula skills.

Training Topics:

Advanced 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 have the skills and confidence to navigate Excel formulas with precision, conduct thorough formula audits, and watch numbers update in other sheets with ease. Don't miss this opportunity to boost your Excel expertise – sign up now and take the first step towards becoming an Excel formula master.

Microsoft Teams will be used for this training session. You will receive a Teams Meeting link prior to the training date. 

This session is recommended for Australian members due to timing, however Aotearoa New Zealand members are welcome. 

We recommend you log in ten minutes before the training session starts to ensure there are no tech issues. If you have any concerns, please contact events.coordinator@algim.org.nz