Excel Dexterity: Advanced Lookup Functions

$49.00 each

Course ID: CPE Credits Field Of Study Author or Speaker:
DR-610.19  2 Credits   Computer Software and Applications  David Ringstrom, CPA
Instructional Method: Advanced Preparation: Program Prerequisites: Experience Level:
Interactive Self Study Video  None   Experience with Lookup Formulas  Recommeded  Intermediate 




Excel Dexterity: Advanced Lookup Functions

Presented by David H. Ringstrom, CPA

In this hands-on presentation Excel expert David Ringstrom, CPA, explains helpful ways you can improve the integrity of your spreadsheets using Excel’s lookup functions. The presentation starts out by comparing exact and approximate matches with VLOOKUP, HLOOKUP, and LOOKUP. You'll then see a number of ways to troubleshoot common problems that plague VLOOKUP and other look-up functions. The presentation closes with a discussion of other alternatives such as MATCH/INDEX, SUMIF, and SUMIFS.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to 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. 

View Cart

cart empty