This course will cover What-if Analysis which enables you to retrieve required results from formulas by determining the data the formula requires, forecast worksheet outcome models, and to see how changing values in formulas affect the formula results. These tools include Goal Seek, Scenario Manager, and Data Tables.

For an optimal experience please check the minimum computer system requirements.

This online course forms part of the SkillsNet short course suite.

Please note this course is only available to CPA Australia members.

Learning objectives

  • Use financial functions in Excel 2013
  • Enable iterative calculations in Excel 2013
  • Decide how to use financial functions in Excel 2013
  • Decide how to allow circular references in Excel 2013
  • Add a watch to a cell in Excel 2013
  • Decide how to watch cells in Excel 2013
  • Use Goal Seek to find the input for a result in Excel 2013
  • Compare scenarios with Scenario Manager in Excel 2013
  • Create a data table in Excel 2013
  • Decide how to use what-if analysis in Excel 2013

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

60 Minutes

365 Days

loading...