BInterest

One of the most awaited Microsoft product after the launch of Windows 7, on 22nd Oct, 2009 is Microsoft Office 2010 which promises to be one of the best of its kind. Some of the major areas of improvement incorporated in the Microsoft Office 2010 includes Extended File Extensions, Improved User interface & redefine the user experiences. One of the Most used product within the Microsoft Office is Excel, so lets have a look at top 4 enhancement / additional features of the Excel 2010. But then, before we processed a word from Chris Capossela, senior vice president of Microsoft’s Information Worker Product Management.

Next Wave of Microsoft Office 2010 Products Will Redefine How People Work

Top 5 Features / Enhancement in Microsoft’s Excel 2010 :

1. 64 Bit Microsoft Excel 2010 :

From 2010, all the office application would offer support to 64-bit. How would this help all the excel users ? This would enable excel users to create a single worksheets up to 4 GB in size. How many times it happens that a large base file crashes even in Office 2007 ? If you create a Excel Spreadsheet anywhere near to 4 GB, do share it with all of such via comment…..

2. Protect View :

As the internet grows, along with the users of Office live, more and more spreadsheets would be on the live network rather then on your local hard drive. But growth of internet is directly proportional to the malware and virus environment and you would not like to have a files with them for sure. Some Excel macros could have viruses or other bad things in them, so to prevent editing of the downloaded content without your permission, Office 2010 adds the small red pop up messages (Same as macro in office 2007) which needs to be enabled before you start editing the spreadsheet downloaded from the internet.

3. Ribbon Customization Via Grouping :

If you love the Office 2007 Ribbon customization, to have a short key of the features you user the most, then you would be for sure in love with this ribbon button’s grouping features, which helps the users to group the similar activity buttons in to a single button via right clicking on a tab on the ribbon and processing towards the customize The Ribbon option. Adding groups to the Ribbon tabs is easy in Office 2010.

3. Pivot Slicers :

Pivot tables of Office 2010 are called as Power Pivot & the features with makes the pivot a power pivot is Slicers. Pivot Slicer is the feature started in Office 2010 to make your pivot experiences more easier then even, by providing a snapshot view of pivot table to current working worksheet. It Helps you to review the data without manipulating the table or base data. Slicers displays it in a chart style box any where you like over the spreadsheet. Example of Pivot Slicer is provided below :

The pivot table was created on the same worksheet as the slicers. The selected information in the month slicer highlights corresponding information in the other slicer and changed the pivot table to show the values selected.

5. Excel Sparklines :

Excel Sparklines are nothing but the tiny charts that fit into a cell majorly used in formation of the Reports & Dashboard.  It allows you to create a graphical representation right next to the data itself (See Image below). Example, suppose that in September I sold 50 widgets, but in October I sold 500 widgets. The sparkline chart depicting September vs. October sales is highlighted in red.

Wanting early for the official launch of the Office 2010, by the time you think what else you can do with excel 2010, Request you all to go through the simple poll on Excel 2010 Unique features below : Waiting for your response.

[poll id="4"]

You can follow me on Twitter at http://twitter.com/binterest.Do stay tuned to Binterest.com for more, Best Way 2 do it, Subscribe to Binterest's Feed Updates