Excel Lookup Functions – 2 Part Web Series 2018

Excel Lookup Functions 2 Part Web Series 2018 is a webinar dedicated to ways to apply a variety of lookup functions in order to work more efficiently in Excel.

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
• Using VLOOKUP to look up data from another workbook
• Using the SUMIFS function to sum values based on multiple criteria
• Learn about the MINIFS function available in certain versions of Excel 2ExcludeInclude6
• Exploring why VLOOKUP sometimes returns #N/A instead of a desired result
• Performing dual lookups, which allow you to look across columns and down rows to cross-reference the data you need
• Comparing the MIN, SMALL, MAX, and LARGE functions
• Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
• Seeing how the HLOOKUP function enables you to perform horizontal matches
• Implementing Data Validation to ensure that users make choices that VLOOKUP will recognize as valid
• Discovering how to use wildcards and multiple criteria within lookup formulas
• Seeing what types of user actions can trigger #REF! errors
• Transforming numbers stored as text into values by way of the Text to Columns wizard

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