Excel – Formulas for what-if analysis
Learn how to write and edit IF formulas to return results based on variable conditions in your spreadsheet data.
Duration: 90 minute
Pre-requisites: Basic familiarity with Excel formulas
Version: Suitable for 2010, 2013, 2016 and Office 365
- Understand how dynamic formulas work in Excel
- Use simple Functions – Excel’s built-in formulas
- Use IF Functions to calculate and return results based on conditional tests
- Use nested IF Functions for complex conditional tests
There are currently no openings available for this course.
Please enquire using the button below.