C - Lookup Functions – A Comprehensive Look at Lookup & Reference Functions

C - Lookup Functions – A Comprehensive Look at Lookup & Reference Functions
Click to enlarge
Price: $59.99
Credits: 5
Prerequisite: 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.
Level: Intermediate
Model: PM12
Author: Patricia McCarthy/Joe Helstrom
Average Rating: Not Rated
Fields of study: Computer Science
Format: PDF


Course Description

This course provides a comprehensive look at the Lookup and Reference category in Excel.  It starts by covering the LOOKUP function and then goes into great detail on the VLOOKUP function. You will learn how to use VLOOKUP, how to use it with Wildcards, how to use VLOOKUP to search through multiple sheets for a match and how to use VLOOKUP when a match is not in the first column of your table.
The course then takes a look at HLOOKUP
. It continues and explains the advantages and disadvantages of INDEX MATCH versus VLOOKUP. The course then takes a look at the OFFSET function which allows you to set up calculations that automatically update as data is added.  The INDIRECT function is also discussed and how to find data on other sheets in your file. A couple of minor functions such as HYPERLINK and TRANSPOSE are also briefly discussed.

Course Objective: To become familiar with the different Lookup functions in Excel and how to utilize them.

LEARNING OBJECTIVES:

Upon completion of this course, you should be able to:

1.   Identify different functions and understand their differences

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 range names and how to create one

5.   Recognize how to incorporate wildcards into functions

6.   Be able to incorporate other functions such  as COLUMN, ROW and ISERROR into VLOOKUPS

 

Prerequisites: 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.

Version: Excel 2007/2010/2013

Level: Intermediate

NASBA Category: Computer Science/Specialized Knowledge

Write Review
Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad            Good

Enter the code in the box below:

There are no additional images for this product.
No Records.