1. Create data charts in a single cell.

With Sparklines, a new feature in Excel 2010, you can create small charts in a single cell to quickly discover patterns in your data. It’s a quick and easy way to highlight important data trends such as seasonal increases or decreases, saving you time.

2. Zero in on the right data points quickly.

Excel 2010 delivers new and exciting filter enhancements. The Slicer feature provides you with a rich visualization of your PivotTable and PivotChart views so you can dynamically segment and filter the data to display precisely what you need. With the new search filter, you can spend less time sifting through large data sets in your tables, PivotChart and PivotTable views, and more time analyzing.
 

3. Efficiently model and analyze almost any data.

The PowerPivot for Excel 2010 add-in, a free download, provides groundbreaking technology such as streamlined integration of data from multiple sources and lightning-fast manipulation of large data sets with up to millions of rows. Business users can effortlessly publish and share analysis through Microsoft SharePoint Server 2010, and have other users enjoy the same Slicer, PivotTable, and fast-query capabilities when working on their Excel Services report.¹

4. Access your spreadsheets from virtually anywhere.

Post your spreadsheets online and then access, view, and edit wherever from just about any computer or your Windows Phone 7 device.² With Excel 2010, you can take advantage of a best-in-class spreadsheet experience across multiple locations and devices.

• Microsoft Excel Web App: Edit workbooks in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience.²
• Microsoft Excel Mobile: Stay current and take immediate action when necessary using the mobile version of Excel on Windows Phone 7.³

5. Connect, share, and accomplish more when working together.

Co-authoring through the Microsoft Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations.² You can see who’s working on a spreadsheet with you at the same time. See changes from others appear as they are made. And with the number of editors in the workbook shown on the status bar, you'll always know who else is editing the workbook with you.

6. Add more sophistication to your data presentations.

Conditional Formatting in Excel 2010 gives you more control over styles and icons, improved data bars, and the ability to highlight specific items in a few clicks. You also can display data bars for negative values to more accurately illustrate your data visuals.

7. Take advantage of more interactive and dynamic PivotCharts.

Quickly gather more insights with the ability to display different data views directly in a PivotChart, independent of PivotTable views, to analyze and capture the most compelling picture of your numbers.

8. Do things easier and faster. 

Excel 2010 simplifies how you access features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you save, share, print, and publish your spreadsheets with just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.
 

9. Harness more power for building bigger, more complex spreadsheets.

Power users and analysts rejoice! With the new 64-bit version of Excel 2010, massive amounts of information are easier to analyze than ever before. Analyze large, complex datasets greater than the 2‑gigabyte limitation of previous Excel versions.  

10. Publish and share through Excel Services.

SharePoint Server 2010 and Excel Services integration lets business users share analysis and results across their organization by publishing spreadsheets to the Web. Build a business intelligence dashboard and share sensitive business information more broadly with coworkers, customers, and business partners in a security-enhanced environment.

Microsoft Excel 2010 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions. New analysis and visualization tools help you track and highlight important data trends. Easily access your important data on the go from almost any Web browser or smartphone.¹ You can even upload your files to the Web and work simultaneously with others online. 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

Excel 2010 delivers powerful new features and tools to help you discover patterns or trends that can lead to more informed decisions and improve your ability to analyze large data sets.

• Get a visual summary of your data using tiny charts that fit within a cell alongside your text data with new Sparklines.
• Quickly, intuitively filter large amounts of information using new Slicer functionality and enhance your PivotTable and PivotChart visual analysis.

Get powerful analysis from your desktop

The refinements and performance improvements in Excel 2010 make it easier and faster for you to accomplish your work.

• Use the new Search Filter to quickly narrow down the available filter options in your tables, PivotTable, and PivotChart views. Find exactly what you are looking for from up to a million or more items, instantly.
• PowerPivot for Excel 2010, a free add-in, lets you experience fast manipulation of large data sets (often in millions of rows) and streamlined data integration. And you can effortlessly share your analysis through SharePoint Server 2010.²
• Work with massive amounts of information ― more than 2 gigabytes ― and maximize new and existing hardware investments by using the 64-bit version of Office 2010.³

Save time, simplify your work, and increase your productivity

It’s much easier to create and manage your workbooks when you can work the way you want to work.

• Recover unsaved versions of files that you closed without saving! That’s right. 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 improved Ribbon to make the commands you need most accessible. Create custom tabs or even customize built-in tabs. With Excel 2010, you’re in control.Break down barriers and work together in new ways

Excel 2010 offers easy ways to enable people to work together on workbooks, improving the quality of their work. Best of all, those with previous versions of Excel can still participate seamlessly.

• You can now work with other people simultaneously on the same workbook in almost any Web browser using Excel Web App.
• Corporate users in companies running SharePoint Foundation 2010 can use this functionality within their firewall.
• 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.
• SharePoint Excel Services lets you share your easy-to-read workbooks in a Web browser with your team while maintaining a single version of the workbook.

Access your workbooks anytime, anywhere

Get the information you need, when and how you want it. Now you can easily access your workbooks by taking the Excel experience with you and stay on top of your needs while you’re on the go.

• Microsoft Excel Web App: Edit virtually anywhere. View and edit your workbooks in a Web browser when you’re away from home, school, or your office.⁴
• Microsoft Excel Mobile: Quickly update and recalculate Excel workbooks. 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.⁵

Whether you’re working on your personal budget or travel expenses, collaborating with a team on school or work projects ― even if your workbooks exceed a million rows ― Excel 2010 makes it easier to get what you need done quickly, with more flexibility, and with better results.