Customizable Ribbon

The Ribbon was introduced in Excel 2007, but has been improved in Excel 2010: now you can create your own tabs and groups for the Ribbon. You can also rename or change the order of default tabs and groups. We will show you how.

Backstage View

Backstage view is where you open, save, print, share, and manage your files and program options. We will show you how to access Backstage view

Workbook Management

Three new tools help you manage, protect, and share your documents.  We will show you how to Recover previous versions (lets you revert to an earlier version of your document), enable Protected view (protect your computer from online attacks when opening files from the Internet) and open Trusted documents (remembers which files you trust so you aren’t prompted each time the file is opened).

Paste with Live Preview

We will show what pasted content will look with various paste options before you paste it.

More Themes and Styles

Predefined styles and themes let you change the overall look and feel of a worksheet in just a few clicks. Now Office 2010 has even more themes you can apply to your documents.

Improved Picture-Editing Tools

There are many new ways to edit pictures and images in your documents.
Insert screen shots: You can take a screen shot or screen clipping and add it to your documents.
Improved SmartArt: Now you can add SmartArt that uses photographs.
Other tools: New picture editing tools let you refine the brightness, contrast, or sharpness of a picture; add artistic effects; and control cropping and compression.

Accessibility Checker

The Accessibility Checker lets you find and fix issues that can make it difficult for people with disabilities to read or interact with your workbook.

Language Tools

Improved language tools let multilingual users set preferences for language settings in Office 2010.

Better conditional formatting

Conditional formatting allows you to analyze Excel data with just a few clicks. New icon sets and formatting options for data bars are available to add to conditional formatting in your documents.  We will show you how.

Improved charts

We will show you how Sparklines works. Sparklines are tiny charts that fit within a cell. They are useful for showing a snapshot of your data in a small amount of space.

Expanded charting limits: Now the number of data points in a data series is only limited by available memory.

Double-click to format charts: In Excel 2010, you can instantly access formatting options by double-clicking a chart element.

Macro recording for chart elements: You can use the macro recorder to record formatting changes to charts and other objects.

Improved PivotTables

PivotTables are easier to use and are more responsive in Excel 2010. Multi-threading to speed up performance; the ability to fill down labels; and new search features are some of the enhancements in Excel 2010.

Slicers are a visual way to filter the data in PivotTables. When a slicer is inserted, you use buttons to filter the data and display what you need. Slicers also make it easy to see which filters are applied.

Improved functions

Excel 2010 includes a set of more accurate functions for statistics. Some existing functions have also been renamed so they better describe what they do.

Improved filtering

A new search filter helps you to find what you need in large worksheets quickly. Search filters can be used in tables, PivotTables, and PivotCharts. AutoFilter buttons also remain visible as you scroll down in a table.

Equations in text boxes

Excel 2010’s built-in Equation Tools make it easier to write and edit equations by keeping them inside text boxes on a worksheet.