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.
|
9/3/2015
|
When:
|
9/3/2015 8:00 AM - 10:00 AM
|
Presenter:
|
Jeff Lenning
|
|
« Go to Upcoming Event List
|
|
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 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
Designed for: Accounting professionals using Excel 2007, Excel 2010, or Excel 2013 for Windows
Prerequisite: Basic knowledge of Excel for Windows
Advanced Prep: None
Speaker: Jeff Lenning
Vendor: Surgent McCoy
Field of Study: Spec. Knowledge (2)
Level: Basic
CPE Credit: 2 Hours
Acronym: EXLU
Registration Fees: $89.00
Register Here
|
|