Using Conditional Formatting, Tables, and Sparklines in Excel 2010


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. 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, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.

Target Audience
Individuals and business users with basic computer literacy

Expected Duration (hours)
1.0

Lesson Objectives

Using Conditional Formatting, Tables, and Sparklines in Excel 2010

  • format data as a table
  • sort and filter table data in a given scenario
  • apply conditional formatting rules
  • use sparklines to show data trends
  • format sparklines
  • sort and filter table data
  • use conditional formats to highlight data
  • use sparklines to highlight trends in data
  • Course Number:
    mo_bexl_a06_dt_enus

    Expertise Level
    Intermediate