Private & Public Courses Available
All private and public courses are delivered online (live and fully interactive). Speak with the Instructor at any time during the course or use the Chat and Q&A features. Each course is 3.5 hours in length and includes a PDF reference manual and 30 days of technical support.
There are no private courses available at this time.
If you are interested in taking a course, the municipality recommends you book a public course instead. Public courses are $ 175 each/per person and are open to anyone who wishes to register. Please click the link below for a full course schedule (PDF).
Excel Course 4: More Useful Formulas
Tue Feb 21 (9am to 12:30pm)
Learn how to quickly produce results that are difficult or time‑consuming using other methods. We look at conditional functions, index match, xlookup and linking formulas. Topics include:
– The Subtotal Function
– SumIf / Sumifs
– CountIf / CountIfs
– AverageIf / AverageIfs
– MinIf / Maxif (Excel 365/2019)
Linking Formulas to Other Sheets
– Link Cell/Formulas/3D Formulas
Linking Formulas to Other Files
– Create Linking Formulas
– Edit Links Dialog Box
– Finding Links in a File
Using INDEX MATCH & XLOOKUP
-INDEX MATCH & INDEX MATCH MATCH
-Using XLOOKUP (365)
-Using MATCH with VLOOKUP
-Using XMATCH (365)
-What’s Better: VLOOKUP, INDEX MATCH or XLOOKUP?
(Knowledge of VLOOKUP required)
Register for Private Course
To register for this PRIVATE course, please complete this form. To register for a PUBLIC course, please click this link: Public Course Registration Page
What You Need to Attend
To attend a live online course you will need a computer (desktop or laptop), an internet connection and a web browser.
If you work with a laptop, it might be difficult to show the Instructor’s screen and work in the program at the same time, so for smaller screens, we recommend you have a second monitor or second computer.
It would be helpful if you have a microphone so you can speak during the course, but if you don’t you will still be able to ask questions and make comments using the Q&A or Chat features.