Microsoft Excel 2010: 10 Best New Features in Microsoft Excel 2010

Microsoft Excel 2010 is reported as a top notch product. Though it has not been released yet, we eagerly awaits its quick arrival. It has a handful of new and advanced features that would distinguish it from its predecessors (Microsoft Excel 2003 and Excel 2007 ). The customization of Ribbon, new charting by cell/column of data for trending, are fascinating. The slicer is pretty neat and the Excel services, Apps all are very unique features of this new version of Microsoft Excel 2010. Without further ado, I am giving you details of 10 best key features of Microsoft Excel 2010.

1. Sparklines to Create Chart in New Format

Microsoft Excell 2010 comes with a new feature — Sparklines. It helps revamping charts and thus ensures improved data visualization. You can create small charts in a single cell. It will highlights pattern of your data i.e, increase or decrease in sale. The new chart, showing data trend, will be time saving. At a glance, you would get a whole lot of information, that may require several hours otherwise.

2. Excel Web App, Co-authoring Facilities

After extending Excel to the web browser in 2007, Microsoft has upgraded its 2010 version of Excel by introducing “Excel Web App”. The core feature of this web app is to bringing the opportunity for multiple users to edit same spreadsheet simultaneously, may be from different locations. You can see the changes made by other editors in the workbook, appearing on the status bar. You’ll also get to know who are the other editors, working on the same workbook with you.

3. PowerPivot for Excel add-in

The 2010 version of Excel is even better and has free add-ons not available in 2003. Business users can take full advantage of Microsoft SharePoint Server 2010. They can publish and share analysis using this feature, while other users enjoy the same Slicer, PivotTable, and fast-query capabilities working on Excel Services.

4. More Memory, More Power

To fulfill customer’s increasing demand Excel 2010 is incorporated with more technical sophistication. The multi-threaded applications, that you found in Excel 2007, this time saw a strategic improvements. Microsoft is also rumored for coming with yet another version of Excel. It will be a 64-bit version of Excel, that support more memory than current 2 GB limitation.

5. Access Spreadsheets from anywhere

With Excel 2010, you are now benefited with an awesome spreadsheet experience across multiple locations and devices. Just post your Spreadsheets online and access them virtually from anywhere. You can view or edit them from any computer or Windows phone, thanks to Microsoft Excel 2010.

6. Improved Data Presentation

Are you a perfection maniac? Then you’ll be glad to know that Excel 2010 allows you to bring more style and color in your data presentation. An array of new controls for improved style, icons, data bars are embedded within Excel 2010. Users can highlight specific items in a few clicks. Data with negative values will be displayed at the data bar so that you can get a accurate view of data presentation.

7. Slicer the Searching filter

Now you have reason to rejoice! Excel 2010 provides an exciting feature for quicker display of data. It saves your time while giving you a precise view of PivotTables. The Slicer feature is responsible for dynamic segmentation and filtration of data. The new search filter brings what you want from large data sets in your tables.

8. Microsoft Office Backstage and customized Ribbon

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. With the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own. So experience working in a new style with Excel 2010.

9. Interactive and Dynamic PivotCharts

Want to view different data in a PivotChart? Now you can do this with the help of Excel 2010. A group of data will be displayed directly in a Pivotchart, regardless of PivotTable views and you can analyze them.

10. Excel Services

The last but not the least is the integration of Microsoft SharePoint Server 2010 and Excel Services. This integration lets business users share analysis and results across their organization by publishing spreadsheets to the Web. They can create a business intelligence dashboard and share business information with business partners or customers. This secured environment is really a boon to the business users of Excel 2010.

If you are an user of beta version of Microsoft Excel 2010 and find any other interesting features, please share your experience with us. We will keep you updated with more features as we get to know.