2022 Course Listing
& Registration

logo-web

Courses Offered - July to Oct 2022

Below are the private courses running for the Municipality of Meaford  from July 2022 through to Oct 2022.

To register, please use the form at the bottom of this page.

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

ezgif.com-webp-to-png.png

Excel Course 3
Using IF & VLOOKUP

Available Dates
Tue Jul 19 (9am to 12:30pm)
Tue Sep 13 
(9am to 12:30pm)

Learn how to effectively use the two most popular functions in Excel – IF and VLOOKUP.   We also cover a feature called Range Names, which is incredibly useful with formulas. Topics include:

The IF Function
– IF Arguments
– Using IF
– Nesting IF’s
– Multiple Conditions with AND/OR
– Conditional Formatting with IF
– The IFS Function (Excel 365/2019)

Range Names
– Why Use Range Names?
– Creating and Referencing a Range Name
– Go to a Range Name
– Edit and Delete a Range Name

The VLOOKUP Function
– What is VLOOKUP?
– VLOOKUP vs. HLOOKUP
– Using VLOOKUP
– Approximate & Exact Match
– IFNA with VLOOKUP
– What is the New XLOOKUP Function (Excel 365)?

ezgif.com-webp-to-png.png

Excel Course 4
More Useful Formulas

Available Dates
Tue Oct 11 (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:

Conditional Functions
– 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

To register for one or more courses, please complete this form.    

Private Individual

Registrations

Summary

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.