With Microsoft Excel 2010 you can now analyse, manage and share information in many more ways than ever before. With its new analysis and visualization tools it can help you track and highlight important data trends. Whether you’re producing financial reports or managing personal expenses, Excel 2010 gives you more efficiency and flexibility to accomplish your goals.

Make fast, effective comparisons

• Discover patterns or trends that can lead to more informed decisions and improve your ability to analyze large data sets.
• Use tiny charts that fit within a cell alongside your text data
• Filter large amounts of information using the new Slicer functionality and you can enhance your PivotTable and PivotChart visual analysis

Get powerful analysis from your desktop

• It’s now easier and faster than ever before for you to accomplish your work with the new features of Excel 2010
• The new Search Filter quickly narrows down the available filter options in your tables. You can now find exactly what you are looking for from up to a million or more items, instantly
• PowerPivot is a free add-in in Excel 2010 that lets you experience fast manipulation of large data sets and streamlined data integration. You can share your analysis through SharePoint Server 2010 with no extra effort required
• You can now work with much more information (more than 2GB’s) and maximize new and existing hardware investments.

Save time, simplify your work, and increase your productivity

• Create and manage your workbooks much easier than ever before
• You can now recovered unsaved version of files that you closed – this is a huge benefit of Excel 2010. How many times have you spent hours working on something to have your power fail, or to close without saving. The version recovery feature is just one of many new features available from the new Microsoft Office Backstage view. The Backstage view replaces the traditional File menu in all Office 2010 applications to provide a centralized, organized space for all workbook management tasks
• Easily customize the new and improved ribbon to make the commands you need more accessible. You can customize your tabs so that you are completely in control

Break down barriers and work together in new ways

• Work with other people simultaneously on the same workbook in almost any Web browser using Excel Web App
• If you’re in a small company or working on your own, all you need is a free Windows Live ID to simultaneously author workbooks with others
• Corporate users in companies running SharePoint Foundation 2010 can use this functionality within their firewall
• You can share your workbooks in a web browser with your team while maintaining a single version of the workbook

Access your workbooks anytime, anywhere

• You can easily access your workbooks and stay on top of your game even if you are out of the office:
             o Microsoft Excel Web App: Edit virtually anywhere. View and edit your workbooks in a Web browser when you are out of the office
             o Microsoft Excel Mobile: Quickly update and recalculate Excel workbooks. You can view entire spreadsheets, including charts and formatting. Sort and filter lists or update your data and formulas and instantly see the results with Excel Mobile on your Windows Phone 7 device. How amazing is that?!

Microsoft Excel 2010 makes it easier and more fun to get what you need done quickly, with more flexibility, and with better results.

Source: Microsoft