Enterprise Applications: Excel 2011 Pushes the Envelope

Excel 2011 Pushes the Envelope

by P. J. Connolly

Set Sharing Options

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

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.

Reorder the Ribbon

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

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.

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.

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.

New Filtering Tools

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

Find Worksheets with Color-Coding

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