Excel Lookup Functions 2 Part Web Series (Module 1) 2018 is a webinar that covers topics such as:
- Learning why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
- Simplifying multiple-field look-ups with concatenation (combining fields together into a single cell)
- Seeing what types of user actions can trigger #REF! errors
- Learning about the IFNA function available in Excel 2ExcludeInclude3 and later
- Employing the SUMIF function to add up values related to multiple instances of criteria that you specify
- Using VLOOKUP to look up data from another workbook
- Understanding the importance of absolute references within many lookup functions
- Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
- Seeing how the HLOOKUP function enables you to perform horizontal matches
- Troubleshooting other errors VLOOKUP can present, such as #REF!, #NAME!, and #VALUE!
- Learning about the MAXIFS function available in certain versions of Excel 2ExcludeInclude6
- Exploring why VLOOKUP sometimes returns #N/A instead of a desired result
Excel Lookup Functions 2 Part Web Series (Module 1) 2018 is intended for:
- CPAs
- CFOs
- Investment Analysts
- Controllers
- Business Analysts
- Financial Analysts
- M&A Specialists (Mergers & Acquisitions)
- Forecasting & Planning Teams
- Strategic Planners
- Risk Managers
- Capital Expenditure Planners
