The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyse data. This course explores rounding functions, and also provides a number of functions to make working with text easier.

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 lookup functions in Excel 2010
  • Recognise when to use the lookup functions in Excel 2010
  • Use reference functions in Excel 2010
  • Use math functions in Excel 2010
  • Recognise when to use the rounding functions in Excel 2010
  • Use trig functions in Excel 2010
  • Use text functions in Excel 2010
  • Use advanced functions in Excel 2010

Audience

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

loading...