Become an Expert on Lookup Functions

SKU: CPE-07-054
Credit Hours: 5
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA

Upon completion of this course, you should be able to:
  1. Differentiate among a variety of functions.
  2. Recognize lookup functions syntax and how to use them in calculations.
  3. Recognize the steps to incorporate data validation.
  4. Recognize the importance of a range name and how to create one.
  5. Recognize how to incorporate wildcards into functions
  6. Understand how to incorporate other functions, such as COLUMN and ROW, into Lookup and Reference functions.