Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines.

This online course forms part of the SkillsNet short course suite.

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

Professionals seeking to improve competency in Excel.

60 Minutes

365 Days

loading...