Become an Expert on Lookup Functions

SKU: 02-054-01-CPE
Credit Hours: 5
Level: Basic
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA

Course Description:
This course provides a comprehensive examination of the Lookup and Reference category in Excel. It covers the LOOKUP and VLOOKUP functions.

At the end of this course, students will be able to:

Differentiate among a variety of functions.
Recognize lookup functions syntax and how to use them in calculations.
Recognize the steps to incorporate data validation.
Recognize the importance of a range name and how to create one.
Recognize how to incorporate wildcards into functions.
Understand how to incorporate other functions, such as COLUMN and ROW, into Lookup and Reference functions.