Advanced Formatting in Excel 2007

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.

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
120 minutes

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.


Using Advanced Chart and Picture Formatting

  • 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

Creating Custom Number and Conditional Formats

  • 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





Multi-license discounts available for Annual and Monthly subscriptions.