Menu

Excel for Accounting Professionals Session 5: Error Trapping and ImprovingLookups

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

    *Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*

    Prerequisites

    Working knowledge of 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.

    Highlights

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

    Register Now

    Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

    • Event Code:

    4902079

    2 CPE Credits
    Specialized Knowledge and Applications: 2 Credits

    Registration

    Member Price:
    $125
    Non-member Price:
    $149

    Registration is open through 07/09.

    Wednesday, July 9th

    9:00am to 11:00am

    Add to Calendar

    Instructor

    Liam Bastick

    Related Courses

    AI Revolution: The Big Picture for CPAs

    July 7, 2025

    2 Credits
    Details
    Forensic Data Analytics Supercourse for Fraud Prevention and Detection

    July 8, 2025

    8 Credits
    Details
    Long-Term Care Insurance: Make the Switch

    July 8, 2025

    1 Credits
    Details
    © 2025 Kentucky Society of Certified Public Accountants. All Rights Reserved. Contact Us