Home > Training > Recorded Webinars > Rising Above Excel's VLOOKUP Function
Processing, please wait

  • Product id  :  IQW15C9033

    Rising Above Excel's VLOOKUP Function

Speaker
: David Ringstrom
Duration
: 60 Mins
Purchase options
  • Description
  • Why should you attend
  • Areas covered
  • Who will benefit
  • Speaker

If you're not using look-up functions such as VLOOKUP in Microsoft Excel then you're likely working far too hard. Such formulas allow you to instruct Excel to locate and return the data you need, instead of you manually crafting formulas that point to the relevant cell. VLOOKUP is easy to implement, but users often struggle with its nuances. In this session Excel expert David Ringstrom, CPA helps you ensure that you're never caught unaware when using look-up formulas. He'll show how to manage the pesky #N/A error that often arises, as well as how to head off potential data integrity issues. He'll also expand your toolbox by sharing some alternatives to VLOOKUP.

• Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions.
• Discover how to use wildcards and multiple criteria within lookup formulas.
• Improve the integrity of spreadsheets with Excel’s VLOOKUP function.
• Learn about the IFNA function available in Excel 2013 and later.
• Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP.
• Perform dual lookups, which allow you to look across columns and down rows to cross-reference the data you need.
• Uncover the limitations of VLOOKUP and learn about alternative functions.
• Use the SUMIF function to summarize data based on a single criterion.
• Use the SUMIFS function to sum values based on multiple criteria.
 
• Understand how to use VLOOKUP to perform both exact and approximate matches.
• Use the MATCH function to overcome a data integrity risk with VLOOKUP.
• See how the SUMIF and SUMIFS functions can serve as alternatives to VLOOKUP.
 
•  CFOs, Controllers
•  Investment Analysts, Financial Analysts, Business Analysts
 Forecasting & Planning, M&A Specialists (Mergers & Acquisitions)
 Risk Managers, Strategic Planners, Capital Expenditure Planners
 Cost Accountants, Managerial Accounts
 

David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David's catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.

People also viewed :