Excel Lookup Functions – 2 Part Web Series (Module 1) 2018

Topics

• 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

Who should Attend

• CPAs
• CFOs
• Investment Analysts
• Controllers
• Business Analysts
• Financial Analysts
• M&A Specialists (Mergers & Acquisitions)
• Forecasting & Planning Teams
• Strategic Planners
• Risk Managers
• Capital Expenditure Planners