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.
Below is the one private course remaining for the Municipality of Meaford. To register for this course, please use the form at the bottom of this page.
If you are interested in taking any other courses, the municipality recommends you book a public course instead. Public courses are $ 150 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.