Menu
Log in
Forgot password

Log in
Contact Us

ALGIM Training Session: Excel Calculation Basics

  • 1 Feb 2024
  • 11:00 AM - 1:00 PM (NZDT)

Registration

Registration is closed

The essential primer on how to perform calculations in Excel.
Learn to perform basic calculation, use constants in your calculations, use functions, understand the basis of errors and track where numbers in your spreadsheet are coming from.

This online session will cover

  • Create Basic Calculations
  • Understand the importance of BODMAS
  • Learn basic function syntax
  • Write SUM, AVERAGE, MAX, MIN and COUNT formulas
  • Use AUTOSUM, AUTOAVERAGE, AUTOMAX, AUTOMIN
  • Discover AUTOSUM Tips
  • Use AutoFill
  • Relative vs Absolute references [F4]
  • Copying and Pasting Formulas
  • Copying and Pasting Values
  • Understand Error Types
  • Introduction to Formula Auditing
  • Tips on essential continued learning resources

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. If you have any concerns, please contact events.coordinator@algim.org.nz

Powered by Wild Apricot Membership Software