Excel Lookup Functions 2 Part Web Series (Module 2) 2018 is a webinar that covers topics such as:
- 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 (Module 2) 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