Skip to main content

Renew your LCPA membership by May 31 for a chance to WIN! Stay connected to what counts.

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

-

Add to Calendar

Online/Webcast

2.00 Credits

Member Price $89.00

Non-Member Price $109.00

The item(s) you are attempting to remove has already been removed from your cart.

Overview

Focused training in Excel to overcome VLOOKUP errors and constraints, enhancing data precision for those in the accounting field.

Highlights

  • VLOOKUP function
  • MATCH function
  • INDEX function
  • Error trapping
  • IF function

    Prerequisites

    Working knowledge of Excel

    Designed For

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

    Objectives

    • Apply the use of VLOOKUP with MATCH to search information effectively in Excel.
    • Apply the use of VLOOKUP with VALUE/TEXT to increase VLOOKUP functionality.
    • Determine when to move beyond VLOOKUP with the INDEX function.
    • Identify ways to trap errors with IFERROR.
    • Use the IF function.

    • Non-Member Price $109.00

    Member Price $89.00

    Add to Cart