Excel Update on Logic Functions IF, AND, OR, and More 2019 is a webinar that covers topics such as:
- 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
Excel Update on Logic Functions IF, AND, OR, and More 2019 is intended for:
- 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