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 12 August 2019 09:30 am - 11:00 am Online $99
Enrol
Virtual Class - Excel: Formulas for What-If analysis 26 September 2019 02:30 pm - 04:00 pm Online $99
Enrol
Virtual Class - Excel: Formulas for What-If analysis 22 November 2019 12:00 pm - 01:30 pm Online $99
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