Advanced Formatting in Excel 2007

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.

• 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