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

Date Time (AEDT) Location Available Spaces Cost
12 September 2022 09:30 am - 11:00 am Online 5 $195.00
19 October 2022 02:30 pm - 04:00 pm Online 5 $195.00
30 November 2022 12:00 pm - 01:30 pm Online 5 $195.00
13 December 2022 02:30 pm - 04:00 pm Online 5 $195.00
24 January 2023 09:30 am - 11:00 am Online 15 $195.00
10 February 2023 02:30 pm - 04:00 pm Online 15 $195.00
8 March 2023 09:30 am - 11:00 am Online 15 $195.00