Advanced Formatting in Excel 2007


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



Overview/Description
Charts and pictures enable you to present data visually, demonstrating data more effectively than rows and columns of data. In Excel 2007, you can customize charts and their individual elements, as well as pictures and clip art, to create professional and appealing documents. Formatting, both custom and condition-based, enables you to display data in formats that best suit your needs. This course explores modifying charts and pictures and creating and editing custom number formats.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

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

Expected Duration (hours)
2.0

Lesson Objectives

Advanced Formatting in Excel 2007

  • format chart elements in Excel 2007
  • identify Chart Tools commands for customizing chart elements
  • save and apply a chart template
  • use the Adjust formatting commands to modify a picture
  • recognize the commands for formatting a picture's style
  • format a picture's size and properties
  • format a chart
  • modify a picture
  • create a custom number format
  • identify codes for custom number formats
  • create a new conditional formatting rule
  • recognize how conditional formatting cell precedence works
  • find cells that have conditional formats
  • create custom number formats
  • create a new advanced conditional formatting rule
  • use advanced formatting in Excel 2007
  • Course Number:
    mo_adex_a01_dt_enus

    Expertise Level
    Expert