Excel for Accounting Professionals Session V: Error Trapping & Improving Lookups
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:
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:
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 to further prepare to tackle real-world issues and build powerful workbooks.
Non-Member Price $109.00
Member Price $89.00