Excel - Calculation Basics
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.
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.
Location
Online Live with a trainer
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.
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!
Price in Australian Dollars
Only $250 per person + 10% GST = $275
Early Bird Seat = $200 per person + 10% GST = $220
Additional Fees:
- Card, transaction, and currency conversion fees may apply where applicable.
Payment Methods:
- Multiple currencies accepted.
- Pay easily with debit or credit including with and more.
- We recommend checking the current exchange rate if you are paying in a different currency.
Important Notes:
- Prices may change without notice.
- All course fees are non-refundable. This means no refunds will be given for cancellations, withdrawals, or non-attendance. This policy helps us maintain high standards and session integrity, and manage costs for our global participants. Please book carefully and make sure you can attend the session(s).
Book on this session
- Please use the Register button at the top of the page to book yourself, someone else or a group.
- Create a new account during registration to easily manage your bookings, or log in to your existing account.
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.