Advanced Formatting in Excel 2007
Descriere curs:
- 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.
- Estimated Duration: 2.0 hours
- Lesson Objectives: Format Charts in Excel 2007
• format chart elements in Excel 2007
• identify Chart Tools commands for customizing chart elements
• save and apply a chart template
Modify Pictures in Excel 2007
• 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
Modifying Charts and Pictures
Create and Edit Excel 2007 Custom Number Formats
• create a custom number format
• identify codes for custom number formats
Use Advanced Conditional Formatting in Excel 2007
• create a new conditional formatting rule
• recognize how conditional formatting cell precedence works
• find cells that have conditional formats
Creating Custom and Conditional Formats in Excel 2007
Using Advanced Formatting in Excel 2007
Opinii/comentarii despre acest produs
Nu am gasit comentarii despre acest produs.