Using lookup, reference, math, and text functions in Excel 2010 (45399304) - Online

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.

• 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