Processing, please wait

  • Rising Above Excel's VLOOKUP Function

Product Id IQW15C9033
Speaker David Ringstrom
Duration 60 Mins
  • 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 H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).