50559 - Excel Lookup Functions
CLASS DATE(s):
7/23/2020 - 7/24/2020
9/3/2020 - 9/4/2020

COURSE LENGTH: 2 Days

COURSE COST: $625.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This two-day instructor-ledcourse provides students with the knowledge and skills to write basic Excel lookup formulas as well as in depth nesting of advanced array and reference functions. The purpose of the course is not only to show that certain functions exist and how they look like, but to show the diversity and usefulness of those functions. This is a very hands-on approach with constant examples, practices and problem solving provided to the audience.

AUDIENCE AND PREREQUISITES

This course is intended for both novice and experienced information worker who have the understanding and knowledge of basic Excel formulas and functions. A minimum one year experience with Excel is recommended before attending.

Before attending this course, students must have:
Basic knowledge of Excel formulas and functions.

  

Course is subject to minimum enrollment. Courseware is not included in course cost. For more details, please contact email: learn@vtec.org or call: 207.775.0244.

COURSE TOPICS:


At Course Completion
List LOOKUP function in Excel.
Recognize the opportunities for LOOKUP function use.
Decide which lookup function is best in the given scenario.
Always keep in mind a wide range of functions and have the ability to combine their use.

Module 1: Introducing LOOKUP functions
Example by using the IF function
Which LOOKUP functions are at our disposal
Other functions we will use during this course
What knowledge should we possess before moving on

Module 2: The LOOKUP Functions Basics
LOOKUOP function
VLOOKUP function
HLOOKUP function
Recognize a LOOKUP function syntax.
Recognize situations when we use the LOOKUP function.
List how does LOOKUP differ from other lookup functions.
Recognize a VLOOKUP function syntax.
Recognize what kinds of examples are solved using VLOOKUP function.
List all differences from other lookup functions.
Recognize a HLOOKUP function syntax.
Tell when to use HLOOKUP.

Module 3: Advanced LOOKUP examples with function nesting
MATCH function
How can we use MATCH with VLOOKUP
INDEX function
Combining MATCH and INDEX functions
INDIRECT function
CHOOSE function
CELL function
OFFSET function
ROW and COLUMN functions
Enhance lookup formulas with many new functions and tools.
Recognize the need for MATCH function.
Face any situation where lookup functions are required at their daily faceoff with Excel.