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

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.