Enterprise Applications: Excel 2011 Pushes the Envelope

 
 
By P. J. Connolly  |  Posted 2010-11-03
 
 
 

Excel 2011 Pushes the Envelope

by P. J. Connolly

Excel 2011 Pushes the Envelope

Set Sharing Options

When more than one person is modifying an Excel 2011 workbook, it's possible to define whose changes take priority.

Set Sharing Options

Sparklines Dress Up Data

Excel 2011 adds Sparklines, tiny charts that provide an at-a-glance summary of data, while remaining near the values that define the charts.

Sparklines Dress Up Data

Reorder the Ribbon

Excel 2011 users can reorder the ribbon tabs, for greater ease of access to frequently used functions.

Reorder the Ribbon

New PivotTable Builder

Excel 2011's PivotTable Builder allows users to intuitively pull together the data for a PivotTable by adding fields, changing hierarchy or reformatting numbers.

New PivotTable Builder

Paste Data as a Picture

Excel 2011 allows one to paste a range of data as a picture, for reference purposes or to display data that shouldn't be changed.

Paste Data as a Picture

Find Data with Ease

Excel 2011 adds the ability to search within a spreadsheet for text, and will present all instances of a matching string.

Find Data with Ease

New Filtering Tools

Data is quickly and easily filtered in Excel 2011 to help locate crucial data without changing the contents of a worksheet.

New Filtering Tools

Find Worksheets with Color-Coding

Sheets in an Excel 2011 can be color-coded to make it easier to find important information.

Find Worksheets with Color-Coding

Rocket Fuel