Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 405876
 
Credit & Course Provided by:

Excel: Mastering Lookup Functions

Live Webinar
November 12, 2019
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart

Gain an in-depth knowledge on the Lookup functions in Excel®.

VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) formulas in Excel®. Used properly, they will help you to improve the accuracy and integrity of your Excel® workbooks, save a ton of time and minimize data entry errors.

This topic is categorized as intermediate-to-advanced. It is aimed at users who want to learn about the Lookup functions in Excel®.

Learning Objectives

• You will be able to recognize how do I avoid my lookup formula displaying an ugly error when it can’t find a match?

• You will be able to describe what’s the difference between VLOOKUP and INDEX-MATCH?

• You will be able to discuss how I’ve heard of VLOOKUP but what’s HLOOKUP?

• You will be able to identify how to construct and use the HLOOKUP function.

Registration

Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart