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.
Snapshot
Duration: 90 minute
Level: Intermediate
Pre-requisites: Basic familiarity with Excel formulas
Version: Suitable for 2010, 2013, 2016 and Office 365
Learning outcomes
- 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
Upcoming Sessions
There are currently no openings available for this course.
Please enquire using the button below.