- Why should you attend
- Areas covered
- Who will benefit
Excel expert David Ringstrom, CPA, shares helpful tweaks you can use with the venerable VLOOKUP function. In this invaluable presentation, he explains alternatives to VLOOKUP, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, IFERROR, ISERROR and OFFSET functions.
Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. Many users rely on VLOOKUP to return data from other locations in a worksheet, but because using VLOOKUP isn’t always the most efficient approach, David explains alternatives. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016.
He draws to your attention any differences in Excel 2013, 2010 or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
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).