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
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
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-602 Using Microsoft Office Excel 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Advanced Excel
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Excel 2007: Advanced
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|