Microsoft Excel lets you enter and analyze large amounts of data with worksheets and charts. This table explains some of the new features of Excel 2011. For more information on how to perform a given task in Excel 2011, visit the Microsoft Excel 2011 Help web site.
|Office Ribbon||The Ribbon replaces the Formatting Palette and Elements Gallery of Office for Mac 2008. It appears under the menu bar. Options on the Ribbon change depending on what you are working on.|
|Conditional Formatting||New formatting and filtering options are available in Excel. You can apply colors to cells based on their values for selected cells or a whole worksheet. You can also use multiple filters.|
|Sparklines||These are one-cell charts that show the data for a column or row. You can use a bar, line or column chart.|
|PivotTables||PivotTables let you compare different aspects of a large set of data. For more information, see About PivotTables.|
|Visual Basic||This allows you to record macros and use any macros you have created for other versions of Microsoft Office. Macros automate tasks; you could create a macro to apply conditional formatting or insert PivotTables. Visual Basic also means that you can use automated worksheets.|
|Microsoft Office Apps||These allow you to work on Office documents from computers that do not have Office installed. They require an Internet connection.|
|Coauthoring||Using SkyDrive or a SharePoint server, multiple people can work on the same document simultaneously and share their changes. Once a change is shared everyone with access to the document will see the changes. However, you must be careful to share, rather than save, each time you make a change.|