Microsoft Office Excel 2007: Upgrading From a Previous Version

DSOC0270—Three Hour Training Class

Course Description

This short course focuses on the new features of this popular spreadsheet program. Students will learn to use the new interface and attributes.

Audience

This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Excel and are upgrading to Microsoft Office Excel 2007.

At Course Completion

After completing this course, students will be able to:

• Navigate the interface
• Customize the interface
• Understand the new file formats
• Organize data using tables
• Sort and filter data
• Create and apply themes for use across Office products
• Apply new conditional formats including data bars and traffic signals
• Use new formula tools designed to improve efficiency
• Create enhanced charts
• Create enhanced pivot tables
• Communicate using illustrations in Excel

Prerequisites

Students enrolling in this course should understand how to use some version of Excel. This course covers the commonly used new features for a typical user.

Training Course Content

Module 1: The Microsoft Office Excel 2007 Interface and Specifications

• More Cells and Improved Performance
• The Microsoft Office Button
• The Ribbon
• The Quick Access Toolbar
• Headers and Footers: Page Layout View
• Customize the Interface

Module 2: Organizing and Formatting Data

• Microsoft Office Excel 2007 Tables
• Themes
• Enhanced Conditional Formatting
• Templates

Module 3: Analyzing and Summarizing Data

• New Formula Tools
• Enhanced Charts
• Enhanced PivotTables and PivotCharts
• Import External Data

Module 4: Finishing Touches

• Illustrations
• The Prepare Options