Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups (2 hours)

Overview

This webcast walks through the limitations, and suggests how to improve the VLOOKUP function. We spend some time trapping errors with the IFERROR function, which was first rolled out with Excel 2007.

Prerequisites

working knowledge of Excel

Objectives

• Improve the use of VLOOKUP with MATCH.
• Improve the use of VLOOKUP with VALUE/TEXT.
• Move beyond VLOOKUP with INDEX.
• Trap errors with IFERROR.
• Use the IF function.

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!