This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail.

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

  • Format numbers in Excel 2013
  • Decide how to format numbers in Excel 2013.
  • Use Auto Fill to copy and fill a series in Excel 2013
  • Extract or add data using Flash Fill in Excel 2013
  • Choose how to automatically populate cells in Excel 2013
  • Create and modify a hyperlink in an Excel 2013 workbook
  • Decide how to add hyperlinks to a worksheet in Excel 2013


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 Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

60 Minutes

365 Days