EXCEL 2007
NEW FEATURES

Course Length: 1/2 day session

Who should attend: Someone who is an experienced Excel user and has recently upgraded their software to version 2007.

Suggested Background: Should understand how to use some version of Excel.

This course covers the commonly used NEW features of version 2007 for a typical user. Due to the minimal prerequisites, there are other more advanced new features that are not covered.

Upon completion of this course, you will:

Getting Started

Identify Excel screen element changes

Use the Microsoft Office button

Access Page Layout View

Work with the New Ribbon Tabs

Identify the various Ribbon tabs:

Home, Insert, Page Layout, Formulas, Data, Review and View

Interface & Customize New Elements

Understand Special Command tabs

Use the Excel Galleries to format cells

Work with Excel options

Customize the Quick Access toolbar

Spreadsheet Enhancements

Create a new workbook and save it

Insert sheets

Insert a table

Format a table

Analyze Data

Apply conditional formatting

Sort data

Filter data

Work with a formula and function

Create and format a chart

Create a PivotTable