Home · Course Details

Learn how to write and edit IF formulas to return results based on variable conditions in your spreadsheet data.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Experienced
  • 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

Topics covered include:
  • Overview of dynamic formulas
  • Introduction to simple Functions
  • SUM, AVERAGE, MAX, ROUND
  • Using complex Functions
  • COUNTIF, SUMIF, ROUND,
  • Nested ROUND, IF, Nested IF

No pre/post work required

Name Date Time Location Cost
Virtual Class - Excel: Formulas for What-If analysis 7 March 2019 12:00 pm - 01:30 pm Online $99
Virtual Class - Excel: Formulas for What-If analysis 20 May 2019 12:00 pm - 01:30 pm Online $99

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.