Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
Overview
Focused training in Excel to overcome VLOOKUP errors and constraints, enhancing data precision for those in the accounting field.
Highlights
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