Excel - Calculation Basics
The essential primer on how to perform calculations in Excel.
Timezone:
New Zealand
18 February 2025
11:00 am to 1:30 pm
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.
Prerequisite
Attendees must already be familiar with working in Microsoft Windows or macOS. Experience with email and or other Microsoft Office applications like Word, Excel or PowerPoint is an advantage.
Topics
Duration: Approx. 2.5 hours
- 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
Don't miss out - boost your Microsoft Excel skills today!
Location
Online Live with a trainer
Date and Time (New Zealand 🇳🇿 time)
18 February 2025
11:00 am 1:30 pm
With World Time Buddy, you can easily convert times across different timezones, helping you determine if you can join this live online session from anywhere in the world.
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.
Price in New Zealand Dollars
Only $250 per person + 15% GST = $287.50
Early Bird Seat = $200 per person + 15% GST = $230
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.