20WS-0897: Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (Webinar)
If you have questions about this event, please call us at 952-831-2707.
Friday, November 6, 2020
9:00am - 11:00am Central Time
2 CPE (2 non-technical)
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
|
Standard Nonmember Fee |
$89.00
|