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.