Excel 2011 Pushes the Envelope

1
2
3
4
5
6
7
8
9
1 of 9

Excel 2011 Pushes the Envelope

by P. J. Connolly

2 of 9

Set Sharing Options

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

3 of 9

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.

4 of 9

Reorder the Ribbon

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

5 of 9

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.

6 of 9

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.

7 of 9

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.

8 of 9

New Filtering Tools

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

9 of 9

Find Worksheets with Color-Coding

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

Top White Papers and Webcasts