New features in Microsoft Excel 2010

Microsoft Office Excel 2010 is available with many new features and improvements for all types of users. Microsoft has rewritten almost all old functions to improve performance and accuracy in Excel. Excel 2010 is definitely improved in performance and has reduced graphics clutter when compared to Excel 2007.

Features in Microsoft Excel 2010:

1. Improved Ribbon: Microsoft introduced ribbon in Office 2007 but it is included in the list of new features because it has come a long way. The ribbon in Office 2010 is an enhanced, cleaner and more customizable tool. It is easier to change the behavior of the ribbon including adding your own shortcuts and hiding it if you don’t need to use the ribbon.

2. Paste option: Microsoft has also introduced a new paste option. This option will display when you right click to paste. The paste option will change depending on what you are doing, So you might see different options when you past a picture than you would if pasting text.

3. Sparklines: Sparklines is one of most exciting features of Excel 2010. Sparklines are tiny charts that appear within a single spreadsheet cell. Basically Sparklines are a visual way to display numbers. Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing.

4. Slicer: Slicer is another new feature on Excel 2010 which helps to filter the data in pivot tables. Pivot tables are used to summarize the data and with the introduction of Slicers, you can visually filter the data on pivot table and quickly find the data you are looking for. You can use Slicers anywhere you want in the excel sheet and you don’t need to move the pivot tables to do that.

5. Protected view: like Word 2010, Excel 2010 features protected view. If you open any downloaded file from the internet or an old version of Office, you won’t be able to edit the file right away. This is because Excel 2010 opens such files in protected mode, and by default editing is disabled to prevent a virus or malicious code from running. If you know where the file came from and trust it then you can enable editing with one click.