Menu
Log in
Forgot password

        
Log in
Contact Us

Microsoft Training: Excel Formulas and Auditing

  • 24 Sep 2024
  • 11:30 AM - 1:30 PM
  • Microsoft Teams

Registration

Registration is closed

Join us for an enriching course 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.


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.


Course Outline

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


    What you need to know

    • Microsoft Teams will be used for this training session. You will receive a Teams Meeting link prior to the training date. 
    • We recommend you log in ten minutes before the training session starts to ensure there are no tech issues.
    • Please note the times are in Australian Eastern Standard Time (AEST) which is two hours behind New Zealand Standard Time (NZST).
    • Duration: Approx. 2 hours


    For any questions, please contact service@algim.org.nz

    Powered by Wild Apricot Membership Software