Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)

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.

Date/Time

Thursday, November 14, 2019
Registration Time: 9:00am
9:00am – 11:00am

Add to Outlook calendar

Course Type

On-line Live Vendors

CPE Credit

2.00 hours CPE credit

Field of Study

Specialized Knowledge & Applications

Level of Knowledge

Basic

Designed For

Accounting professionals using Excel for Windows

Vendor

Surgent McCoy CPE, LLC

Prerequisites

Basic knowledge of Excel for Windows

Advanced Preparation

None

Highlights

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

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

Location

N/A (This is a webcast)
Member Fee $89.00
Non-Member Fee $89.00
Your Price $89.00
View more conferences and courses

Registered for CPE? Log in to download electronic course materials.