This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel’s powerful customisation features. Explore numerous abilities to modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules to further enhance data presentation.

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

  • Customise workbook settings using Excel Options
  • Recognise how to alter code strings to create custom number formats
  • Create a conditional format based on a new formatting rule
  • Manage conditional formatting rules
  • Customise workbook settings and the Quick Access Toolbar

Audience

Prerequisites

Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.

Individuals and business users with basic computer literacy

60 Minutes

365 Days

loading...