This course will give you an understanding on customising cells, adding forms, and creating templates to tailor your workbooks to your individual needs.

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

  • Create a custom data format in Excel 2013
  • Create a custom fill series in Excel 2013
  • Decide how to create a custom data format and fill series in Excel 2013
  • Apply custom styles in Excel 2013
  • Add form fields to a workbook and create a template in Excel 2013
  • Add form fields to a workbook and create a template in Excel 2013
  • Choose how to create a custom cell style and form control in Excel 2013
  • Apply advanced conditional formatting in Excel 2013
  • Apply advanced conditional formatting in Excel 2013
  • Decide how to apply advanced conditional formatting and filtering in Excel 2013
  • Check for accessibility issues in Excel 2013
  • Decide how to provide accessibility in a workbook 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...