This course is not currently offered by Global Knowledge. Information here is provided for reference only.

This course covers the new features of Excel 2007. Topics covered include getting help and using new formatting, pivot table, table, formula, sorting and filtering, and graphics and file format features. Students will examine how the new interface affects navigation and investigate views and other options and tasks.

For this course, training is performed on student's equipment. We provide the software and data files for the training.

What You'll Learn

• Explore New Features
• Use New Help Features
• Use New Conditional Formatting Features
• Use New PivotTable Features
• Use New Table Features
• Use New Formula Features
• Use New Sort and Filtering Features
• Use New Graphic Features
• Use New File Format Features

Who Needs to Attend

Business users who want to upgrade their knowledge from Excel 2003 to Excel 2007

Prerequisites

An understanding of Windows and Excel 2003

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Exploring New Excel Features

• Hiding the Ribbon Tab
• Using KeyTips
• Inserting a New Worksheet
• Freezing the Panes
• Exploring Excel Options
• Customizing the Status Bar
• Using Page Layout View
• Using the Zoom Slider

2. Using New Help Features

• Using Help
• Using Help Online Content

3. Using New Conditional Formatting Features

• Using Highlight Cell Rules
• Using Manage Rules
• Using Clear Rules
• Using Data Bars

4. Using New PivotTable Features

• Creating a PivotTable Report
• Adding PivotTable Report Fields
• Using Expand and Collapse Buttons

5. Using New Table Features

• Creating a Table
• Removing Duplicates from a Table

6. Using New Formula Features

• Using Formula AutoComplete
• Viewing New Functions

7. Using New Sort and Filtering features

• Sorting Records by Multiple Fields
• Filtering Data to Find Above Average

8. Using New Graphic Features

• Using New Chart Features
• Using SmartArt

9. Using New File Format Features

• Using the Document Inspector
• Marking a Document as Final
• Saving to a PDF Format
• Using the Compatibility Checker
• Converting a File to Excel 2007 Format
• Saving in a Binary Format