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 |