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 Snapshot Duration: 90 minutesCategory: ExcelPlatform: Adobe ConnectLevel: ExperiencedPre-requisites: Basic familiarity with Excel formulasVersion: Suitable for 2010, 2013, 2016 and Office 365 Learning Outcomes Understand how dynamic formulas work in ExcelUse simple Functions – Excel’s built-in formulasUse IF Functions to calculate and return results based on conditional testsUse nested IF Functions for complex conditional tests Course Outline 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 Resources & Precourse Work No pre/post work required Name Date Time Location Cost (inc GST) Virtual Class - Excel: Formulas for What-If analysis 7 March 2019 12:00 pm - 01:30 pm Online $99 Enrol Virtual Class - Excel: Formulas for What-If analysis 20 May 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