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

Topics

• 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