Become a Lookup Expert! (LEMC)

Pre-requistes:

Assumes familiarity with Excel and how to use basic functions such as SUM and COUNT. Assumes the user understands what an absolute cell reference is.

Knowledge Level:

Intermediate

Major Topics:

• Using the EBook
• Overview of lookup functions
• Types of lookups functions and their uses

Learning Objectives:

• 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

Designed For:

All CPAs