Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

21WS-1398: Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (Webinar)

If you have questions about this event, please call us at 952-831-2707.

Tuesday, September 21, 2021
9:00am - 11:00am Central Time
2 CPE (2 non-technical)

Alternate dates & more options

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 subjects

  • 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 objective(s)

  • 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 program?

Accounting professionals using Excel for Windows

Fees

Our records indicate you are a nonmember. If you register, you will be charged $89.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Standard Member Fee $89.00
checkmark Standard Nonmember Fee $89.00

More program information

Instructor Jeff Lenning, CPA, CITP
Location Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level Basic
Format Group Internet Based
Sponsor Surgent
NASBA ID#: 103212
Prerequisites Prereq. Basic knowledge of Excel for Windows
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business days before the event start date. Learn more

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog

If you have questions about this event, please call us at 952-831-2707.