Enhancements to charting, themes, and styles in Excel 2007 enable you to create attractive and well-organized representations of spreadsheet and workbook data. Charts, themes, styles, and pictures can all be easily inserted and customized from the Ribbon bar. This course demonstrates how to effectively use and customize charts in Excel 2007, and explores available chart types and styles. Using themes and styles to improve presentation, and adding visual elements to workbooks, are also covered.
Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007
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
Using Charts in Excel 2007
- insert an Excel 2007 chart
- identify the main elements of a chart
Updating Charts in Excel 2007
- change Excel 2007 charts
- change the data range included in the chart
- move a chart to a new worksheet
Adding Charts to Workbooks in Excel 2007
Insert Illustrations in Excel 2007
- insert illustrations in Excel 2007
Use Excel 2007 Themes and Styles
- apply a theme
- apply a cell style
Adding Visual Elements to Excel 2007
Applying Styles and Themes 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: Beginning Excel
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Excel 2007: Basics
• 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
|