Microsoft Excel 2013: An introduction to features

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.

Home Screen

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.

User Interface

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 Backstage view

Management Tools

Excel 2013 gives you the most effective and easiest way for managing your documents. Some of the important ones are:

Recover

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

C:\Users\<USER NAME>\AppData\Local\Microsoft\Office\UnsavedFiles

in Windows XP

C:\Documents and Settings\<USER_NAME>\Local Settings\Application Data\Microsoft\Office\Unsaved Files

Protect Workbook

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.

Protected Mode

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

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.

About Support Desk

Apple Mac and Computer Repair blog by the Support Desk at Geeks Onsite Limited