City of St. Catharines Learning & Development

To take this course, you must have a solid understanding of most topics covered in Excel Course 1A and 1B. Helpful if you have some knowledge of Course 2A and 2B topics.

Get the hang of two of Excel’s most powerful functions—IF and VLOOKUP—and learn how to use Range Names to make your formulas smarter and easier to manage. This course gives you practical tools to level up your data game with confidence.

Includes:

The IF Function

• IF Arguments
• Using IF
• IF with Checkboxes

Range Names

• Why Use Range Names
• Create/Reference 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