Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data.

This course discusses various statistical functions, including those designed to work with averages, determine the median, pinpoint rank, percentages, and sample populations. In addition, this course explores the available cube functions, and the methods for working with arrays.

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 statistical functions in Excel 2010
  • Use conditional functions in Excel 2010
  • Use array formulas in Excel 2010
  • Use advanced Excel functions
  • Add and edit ActiveX Controls in an Excel worksheet


Individuals who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments

60 Minutes

365 Days