Mobile Edition


Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU) (SUEXLU03)

 
Date:Thursday, August 29, 2019
Time:10:00AM - 12:00PM
(Registration at 9:30 AM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Jeff S. Lenning
Vendor:Surgent McCoy
Course Level:Basic
Early Bird Price:$89.00 FICPA Members, $119.00 Non-Members

Description:
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Objectives:
  • Recognize when and why a lookup function is better than a direct cell reference
  • Use three of Excel's many lookup functions
  • Gain comfort with the arguments of the functions presented


Major Topics:
  • Using lookup functions as an alternative to direct cell references
  • Understand the limitations of the VLOOKUP function
  • Discover ways to move beyond these limitations


Who Should Attend:
Accounting professionals using Excel for Windows

Prerequisite:
Basic knowledge of Excel for Windows

Advanced Preparation:
None

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.