Home · Course Details

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

Enrol Now
Enquire About This Course

  • 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 (inc GST)
Virtual Class - Excel: Formulas for What-If analysis 23 April 2020 02:30 pm - 04:00 pm Online $159.50
Enrol
Virtual Class - Excel: Formulas for What-If analysis 21 May 2020 02:30 pm - 04:00 pm Online $159.50
Enrol

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.

Contact Us