Excel 2010 New Features

Objective

Learn about the new features and enhancements in Excel 2010.

Prerequisites

Delegates must be familiar with previous versions of Excel.

Workshop Length

90 minutes

Training formats

Scheduled course · Private course · tailored · 1 to 1 (all instructor led)

Manuals

A quick reference guide provides support throughout the course and upon your return to the office.

Calendar

Click here to see the Office 2010 Migration courses calendar

 

Download pdf

Course Description

The most noticeable change between Excel 2010 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 2010's other new features as well.

Workshop profile

• 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, colour 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.