Excel Dexterity: Intro to Lookup Formulas
CPE 2 | Computer Software & Applications | Self-Study

$49.00 each

Course ID: CPE Credits Field Of Study Author or Speaker:
DR-603.19  2 Credits   Computer Software and Applications   David Ringstrom
Instructional Method: Advanced Preparation: Program Prerequisites: Experience Level:
 Interactive Self Study  None   None  Overview


Excel Dexterity: Intro to Lookup Formulas

Presented by David H. Ringstrom, CPA

 If you're not presently using look-up formulas such as VLOOKUP, HLOOKUP, SUMIF, and others in your work, then there's much about your experience in Excel that is more difficult than necessary.

In this comprehensive presentation, Excel expert David Ringstrom, CPA, introduces several lookup functions and provides context on when you’re likely using them. He demonstrates troubleshooting techniques and prepares you to deal with nuances that can frustrate users new to lookup functions.
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.