Course ID: ELL21207- Excel Lookup Functions
Author: Patricia McCarthy 

Retrieve and use Excel data quickly and efficiently.
If you have been wanting to learn how to create a basic lookup or to learn more about other Excel functions that allow you to lookup and retrieve information then this class is for you. 

Course Description
This course covers three (3) different lookup functions as well as the Lookup Wizard. For the VLookup and Index Match functions, you begin with an overview and then go through a detailed practice exercise step by step. You then do a second similar exercise with more general steps. Finally, you try an exercise all on your own - with a few hints. An answer file is provided for each exercise.

For more information see:

1.5 CPE Hours
Course description and outline
Sample page
Copy of exam

Learning Objectives

• Learn how to apply lookup functions in Excel to  a spreadsheet so that you can efficiently identify and retrieve specific information that has been stored in it as a table of data
• Learn how to evaluate the different Excel lookup functions and asess which function should be used based upon the volume and arragement of your data.

Delivery
Interactive

Level
Intermediate

Version
Excel 2007 however, Excel 2003 users should have no trouble adapting

Prerequisite
An understanding of absolute cell references and range names is needed

NASBA Category
Computer Science

Format
Course manual in pdf format and Excel exercise files. 

Revised/Reviewed: November 2011