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

1281 - Excel Course 3: Using IF & VLOOKUP