Online Directory | NACVA Site Search:

Accelerate Excel: Look-Up Formulas

Practice Management

 Accelerate Excel: Look-Up Formulas
CPE Credit

Program Type: Recorded Webinar (Audio, PPT Presentation)
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught.
Advanced Preparation: None
Delivery Method: Group Internet-Based
CPE Credits: Two (2) Hours
Fields of Study: Computer Software & Applications
Item Number: 14PPM1006B
Shipping Weight: 0lbs. 0oz.
Price: $110.00
Program Description

In this webinar Excel expert David Ringstrom, CPA helps you go beyond VLOOKUP with regard to using look-up functions in Excel. The webinar starts out with some basics on VLOOKUP, then quickly picks up the pace by showing you how to tweak VLOOKUP with the CHOOSE and MATCH functions. Go farther with the SUMIF and SUMIFS function, and then get an overview of SUMPRODUCT for times when you need backwards compatibility with Excel 2003.

Learning Objectives

After completing this webinar, attendees will be able to:

- Improve the integrity of spreadsheets with Excel's VLOOKUP function
- Analyze what causes look-up errors, and see how to overcome such situations
- Discover how to use wildcards and multiple criteria within look-up formulas
- Don't be caught off-guard by the new IFNA function available to Excel 2013 users
- Perform dual lookups, where you look across columns and down rows to cross reference the data you need
- Explore why the MATCH and INDEX combination is often superior to VLOOKUP or HLOOKUP
- Uncover the limitations of VLOOKUP, along with alternatives
- Master the versatile SUMIF function
- Utlize the SUMIFS to sum value based on multiple criteria
- Compare the variety of functionality the SUMPRODUCT function offers
- Determine situations where VLOOKUP may return an error or omit desired data
- Future-proof VLOOKUP with the MATCH function
- Compare and contrast the SUMIF, SUMIFS, and SUMPRODUCT functions

Who Should Attend

Practitioners seeking to use Excel more efficiently by way of worksheet functions


David H. Ringstrom, CPA
Mr. David Ringstrom is President and Founder of Accounting Advisors, Inc. He started the firm in 1991 and provides consulting and training services nationwide. He is a nationally recognized Microsoft® Excel expert, and regularly teaches live webinars on spreadsheets and other topics. David has written freelance articles on Microsoft® Excel and accounting software for over 15 years, and he has served as the technical editor for over 25 accounting software reference books.