Excel 2007 Charts, Pictures, Themes, and Styles

Overview/Description
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

Expected Duration (hours)
1.5

Lesson Objectives

Excel 2007 Charts, Pictures, Themes, and Styles

insert an Excel 2007 chart

identify the main elements of a chart

change Excel 2007 charts

change the data range included in the chart

move a chart to a new worksheet

work with charts in Excel 2007

insert illustrations in Excel 2007

apply a theme

apply a cell style

use illustrations to enhance a worksheet

use a predefined theme and style to create a professional-looking worksheet

use charts, illustrations, themes, and styles to improve the visual impact of your workbook