Features you can expect with Microsoft Excel 2013
Are you expecting a lot to have come out in Microsoft Excel 2013? You are right to a greater extent. I would like to discuss a few new features in this blog today.
Once you launch Excel 2013, you would say – yes, that’s an elegant look. Very true, a careful attention seems to have been paid by Microsoft in designing the home screen of the Excel 2013. Any user will simply love the way it has been designed and the way its user interface and navigation have been shaped up.
Ribbon with Office button was there in the earlier version of MS Excel. This time, it’s there but the look is new. Moving ahead of the style, remember you were not able to have the custom tabs in the version 2007. But in MS Excel 2010 & 13, users can have the custom tab simply by the customization of Ribbon option.
You will have the lists of File menu options in the Backstage view of your excel document. It means when you click on File option, it takes you to the backstage view where you are not able to see the document but you will come across a number of useful options. You would find the Info, Recent, New, Print and Options links in the backstage sidebar. You will also have properties revealing entire properties of your excel document that can be edited at one go.
Excel 2013 gives you the most effective and easiest way for managing your documents. Some of the important ones are:
Users using MS Excel 2013 can recover their documents in case they forget to save the file. One can simply click on Recover Unsaved Documents and it will lead to opening of all the unsaved excel documents. You can even manually track the unsaved versions of files. To do this you can head to:
File > Open > Recent Workbooks. Default path of unrecovered files is
in Windows7/Vista OS
in Windows XP
C:\Documents and Settings\<USER_NAME>\Local Settings\Application Data\Microsoft\Office\Unsaved Files
While finalizing your workbook if you would like to protect the document or sheets, you can to File > Info and then click on Protect Workbook option.
However, document protection was available in the previous versions also, but in the present version, you can do much more. You can mark the document as final, you can protect a sheet, and even workbook structure. You can add a digital signature also.
MS Excel 2013 opens and presents an Excel sheet out of an external resource in the form of Protected format.
For getting secured from vulnerabilities users are prompted by Excel to enable them for editing.
Data Analysis Utility
It is easier to have data analysis in Excel 2010/13. It has been made even more effective in this latest version with the use of Sparkline, Pivot Tables and Slicers.
Sparklines are basically the tiny charts found in a cell which can be easily visualized and can have glimpse of your own data. Using it one can track the performance of any business and progress of students as well.
Pivot Charts and Pivot Tables
In this new version of Excel, User Interface and functionality are much more improved. In Pivot table Slicers can be used. Users can also comprise features of Show Value for Ranking and % Running Total. The presence of Multi-threading helps users for retrieving data quicker. Even users can fill down the labels as enabled by Pivot Table.