Week 7-Microsoft Excel 2010

Microsoft excel 2010 is designed to get the most productive results when carrying out spreadsheets and important calculations in this busy world. There are some special features in excel 2010 that makes it stand out from the rest of the versions.

• Improved ribbon: First introduced in Excel 2007, the ribbon makes it easy for you to find commands and features that were previously buried in complex menus and toolbars.

• Microsoft office backstage view: Click the File tab to open Backstage view, where you create new files, open existing files, save, send, protect, preview, and print files, set options for Excel, and more.

• Microsoft Excel web app: Excel Web App extends your Excel experience to the web browser, where you can work with workbooks directly on the site where the workbook is stored.

• Spark lines: Excel Web App extends your Excel experience to the web browser, where you can work with workbooks directly on the site where the workbook is stored.

• Slicers: Slicers are visual controls that let you quickly filter data in a PivotTable in an interactive, intuitive way. If you insert a slicer, you can use buttons to quickly segment and filter the data to display just what you need.

• Improved conditional formatting: Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets.

• Improved filter capabilities: In addition to slicers, which are described earlier in this article, Excel 2010 comes with new features that make it easier to sort and filter data.

• More themes: In Excel 2010, there are more themes and styles than ever before. These elements can help you apply professional designs consistently across your workbooks and other Microsoft Office documents.