Close

November 4, 2012

Microsoft Excel 2013 Features

In this blog post we will see Microsoft Excel 2013 Features. Most interesting feature of MS Excel is much enhanced User Interface, prior to MS Excel 2010. Microsoft introduces Office button in MS Excel 2007. Office button has been replaced by File button in MS Excel 2010. The same File button exists in MS Excel 2013 as well. We will see the new features of MS Excel which increases the productivity and usability.

  1. Home Screen

Once the MS Excel 2013 launched, it will display Home screen which is elegant and rich in look. Much care has been taken care by Microsoft in terms of design, user interface and navigation. Also Microsoft considered the evolution of tablet. Hence the ease of navigation of Office 2013 is hassle free.

Microsoft Excel 2013 Features Home Screen

  1. User Interface

Though earlier version of MS Excel provides ribbon with Office button, there was no way to create custom tabs. In MS Excel 2010/13, users could create custom tab using Customize the Ribbon option.

Customized Ribbon in MS Excel 2013

Microsoft Excel 2013 Features Excel Options

Microsoft Excel 2013 Features Custom Tab

File menu lists out the BackStage view of your excel document which shows Info, Recent, New, Print, Options et al.

Also it reveals all properties of your excel document which are editable at single instance.

Microsoft Excel 2013 Features Info screen

  1. Management Tools

Excel provides easy and effective way to manage your docuemt with following options.

Recover

MS Excel allow users to recover excel document if the users forgot to save by navigating to File > Recent in MS Excel 2010, click on Recover Unsaved Documents which opens all unsaved excel documents. 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\UnsavedFiles

Recover Versions

To recover versions go to File > Info, click on Manage Versions then select Recover Unsaved Workbooks which opens browse dialog box with recent copies of unsaved files. See below snapshot.

Protect Workbook

To mark as final and make your workbook as final, to protect your document/sheet/workbook structure with password, to restrict access to users and to add invisible digital signature, go to File > Info, click on Protect Workbook.

To inspect your document, checking the accessbility across users  and to validate the compatility with earlier verions, excel provides intuitive way in this latest version.

Microsoft Excel 2013 Features Check Compatibilty

Checking Compatibility across versions

Microsoft Excel 2013 Features Compatibility Checker

Compatibility Checker in Excel 2010

  1. Protected Mode

MS Excel 2013 opens excel sheet from external resource in Protected format. Excel prompts users to enable editing message to secure from vulnerabilities.

  1. Data Analysis Utility

In Excel 2010/13, data analysis is much more easy and effective using Sparklines, Slicers, Pivot Tables.

Sparklines

Sparklines are tiny charts in a cell that are easy to visualize your data. It is very useful in tracking your business performance, student’s progress et al.

Microsoft Excel 2013 Features SparkLines

Slicers

Slicers enable users to filter data quickly in a Pivot Table. It slices data into segments instantly based on filters.

Microsoft Excel 2013 Features Slicers

Pivot Charts and Pivot Tables

Much improvement in Pivot’s User Interface and its functionality. Slicers can be used in Pivot table. Users can include Show Value features for Ranking, % Running Total etc. Multi-Threading enable users to retrieves data quickly. Now, Pivot Table allows users to fill down labels.

In next post, we will see more new rocking features in Microsoft Excel 2013. If you are enjoying our articles, please do subscribe our free newsletter.

About NaveenKumar Namachivayam

Hi there! is a passionate and experienced Performance Test Analyst based in Chicago, USA with skill sets in Manual Testing, Test Automation, Performance Testing, and Test Estimation. He loves to learn and experiment new trends and models in Software Testing. Please stop by at his personal blogs: Excel Blog, DealsBrook, NaveenKumarN.in, and Affiliate Insights blog and Software Testing Memes.

Leave a Reply

Your email address will not be published. Required fields are marked *