Excel 2007 New Features

Objective

Learn to work with the new features of Excel 2007.

Prerequisite Skills

• Familiar with previous versions of Excel.

• Familiar with the new Office 2007 interface (helpful, though not essential)
  (Suggested course: Office 2007 New Features)

Course Description

The most noticeable change between Excel 2007 and earlier versions is the new user interface (i.e., the Ribbon and Office button, which display in place of the familiar toolbars and menus used in the past). Once you have grown accustomed to this new way to access Excel commands, however, you'll want to know about Excel 2007's other new features as well.

Attend this course if you want to:

• Open workbooks created in earlier versions of Excel.

• Convert workbooks between versions.

• Work with the Office button and Ribbon in Excel.

• View calculations on selected cells in the status bar.

• Customize the status bar to display the information you prefer.

• Group related rows of data into a table.

• Format a table.

• Use formulas in tables.

• Convert a table back to a regular range of cells.

• Use the new Page Layout view.

• Use data bars, color scales, and icon sets to help visualize your data values.

• Highlight cells in a range based on a rule.

• Sort data in a worksheet.

• Understand new file formats for Excel.
  

Class Length

90 minutes

Delivery Options

• Virtual classroom - public
  ($70 per student; check times and register here)

• Virtual classroom - dedicated (up to ten people from the same organization)
  ($480 per class; contact us for more details)

• Virtual classroom - one on one
  (Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)

• On-site instructor-led
  (Contact us for details)