Skip to main content

Excel for Accounting Professionals Session V: Error Trapping & Improving Lookups

-

(Check-In )

Add to Calendar

Online

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

Practical hands-on Excel learning exercises taught by a highly engaging expert in the field.
You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives.
You'll walk through the VLOOKUP and IFERROR functions and explore the following topics:

  • Improving the use of VLOOKUP with VALUE/TEXT
  • Improving the use of VLOOKUP with MATCH.
  • Moving beyond VLOOKUP with INDEX
  • Trapping errors with IFERROR

    Moving beyond basic Excel functions

    Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel.

    You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing:
  • Combining functions to enhance flexibility
  • Utilizing functions for atypical data categories
  • Perfecting sophisticated lookup functions

    • Non-Member Price $109.00

    Member Price $89.00

    Add to Cart