Jeff Lenning, CPA, CITP


    Credit Info
  • NASBA Field of Study

    Specialized Knowledge

  • Format

    On demand

  • Level


  • CPE Credit


  • Course acronym

  • Prerequisites


  • Course duration

    2 Hours

Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups

As popular as the VLOOKUP function is, it has limitations. This session walks through the limitations and suggests how to improve the VLOOKUP function. We then discuss how to move beyond VLOOKUP altogether. We spend some time trapping errors with the IFERROR function, which was first rolled out with Excel 2007. The webcast is designed with time for you to work along. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows.
Hurry up, special offer for a limited time only.
Topics discussed

Learning 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.

Who will it benefit?

Accounting and finance professionals who’d like to improve their mastery of Microsoft Excel