Advanced Formatting in Excel 2007

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