Menu
Log in

        

Microsoft Training: Excel Calculation Basics

  • 2 Jul 2024
  • 9:00 AM - 11:00 AM (AEST)
  • Microsoft Teams

Registration

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

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).

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

Powered by Wild Apricot Membership Software