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.
Excel Lookup Functions 2 Part Web Series 2018 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
- 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
Excel Lookup Functions 2 Part Web Series 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