Customer Service: 800-778-7436     

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)

Thursday, May 3, 2018
10:00 AM - 12:00 PM (Eastern)

Jeff Lenning

  • Format Webinar
  • Credits 2
  • Level Basic
  • Field of Study Computer Software & Applications (Non-Technical) (2)

$89.00


Overview

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.

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

Learning 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

Who should take this course:

Accounting professionals using Excel for Windows

Basic knowledge of Excel for Windows

None

No

No

No

loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.