This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines.

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

  • Apply conditional formatting to a worksheet in Excel 2013
  • Decide how to apply conditional formatting to a worksheet in Excel 2013
  • Create custom conditional formatting rules in Excel 2013
  • Choose the best way to customise conditional formatting rules in Excel 2013
  • Create a basic sparkline in Excel 2013
  • Create an advanced sparkline in Excel 2013
  • Decide how to create and edit sparklines 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 Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

60 Minutes

365 Days

loading...