Excel Update on Logic Functions – IF, AND, OR, and More 2019

Topics

• MINIFS function available in certain versions of Excel 2016
• IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions
• The capabilities of the SUMPRODUCT function
• The pros and cons of using the F9 key within Excel’s formula bar to evaluate a portion of a formula
• IFNA function available in Excel 2013 and later
• MAXIFS function available in certain versions of Excel 2016
• Formulas in slow motion with the Evaluate Formula feature
• MIN, SMALL, MAX, and LARGE functions
• Two or more conditions at once with Excel’s AND function
• Single condition among two or more that returns TRUE by way of Excel’s XOR function
• Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
• The range of IS functions that can be used within IF statements to test for various conditions within a worksheet

Who should Attend

• CPAs
• CFOs
• Investment Analysts
• Controllers
• Business Analysts
• Financial Analysts
• M&A Specialists (Mergers & Acquisitions)
• Forecasting & Planning Teams
• Strategic Planners
• Risk Managers
• Cost Accountants
• Capital Expenditure Planners
• Human Resources Departments
• IT Departments
• Banking Professionals
• Auditors
• Excel Users in Regulated Lifesciences Industry
• Insurance Professionals
• Sales and Marketing Professionals
• Logistics and Supply Chain Professionals
• Managerial Accountants
• Other Accounting and Finance Professionals