Features Of Excel 2013

What Is New In Excel 2013?

This write up will let you know what more you can get with Excel in MS Excel 2013. A glimpse of Excel 2013 facilities is here for all the MS Excel users:

Connect Excel Files With Cloud

With the new edition of MS Excel, users are able to add up their crucial Excel workbooks on SkyDrive or SharePoint Server. This feature is helpful for users having Smartphones and tablets. Office 365 users, this feature offers assistance for reviewing and editing workbooks within any well-known browser.

 

 

 

Simplified File Share

Sharing of MS Excel files became far better in comparison to old editions of the workbook application. The easy to understand pane for adding up files at Server or Cloud along with facility to invite users for viewing and editing workbooks astonished Cloud users. ‘Online Lync meetings’ to share the details about any meeting in social media makes professional tasks easier.

 

Writing Pad With Touch

A required space within distinct options on Excel 2013 screen made the touch selection of any option easy.  Different options at the ribbon of Excel 2013 wizard can easily selected on Windows 8 computer or Smartphones. With touch support you can extend physical keyboard actions like PgDn, PgUp, Home, End etc

 

 

Data Model Management

Connection with standalone database management programs as well as one-to-one connectivity within tables and databases. One –to-many tables interconnectivity is also supported. Filtering database columns into Pivot tables and charts

 

Graphic Timeline Filter

Using timeline graphic filter one can filter data i.e. columns according to date added with data model. Simply date based column filter operation with the help of graphically filter pivot table.

 

Suggestion For Adding Charts

If user is not sure about which type of chart should added into table then, positioning the cell pointer at any point of the table data will show “Insert?Recommended Charts” at the ribbon. With this option users can get a preview of suggested chart for their table so, adding up the best suited chart will be easy process

 

 

Suggestion For PivotTables

After importing Excel data lists and tables from a database management program, this enhanced Excel edition will let you create required Pivot table via suggestion. Users just need to locate the cell from the data list then follow: Insert -> Table -> Recommended and Excel 2013 will suggest Pivot table addition

 

 

More Apps For Office

For extending features of this MS Excel 2013, it suggests MS Office add-in for download. Insert? Apps for Office?list of apps at the Ribbon. The most desired apps for Excel 2013 are Bing Maps, Merriam, Mini Calendar, and Date Picker app.

 

 

Quick Analysis Tool

Users can get this tool at the lower-right end of selected table within Excel 2013 Worksheet created. It permits to create pivot table or chart, total counting for columns & rows, adding sparking messages, and many more.

 

 

AutoCorrect Or Flash Fill

For differentiating longer entries of a column this tool will help you out, as well if user want to add up the same entries for next column then, this AutoCorrect tool will offer suggestion for corresponding entries as the user enters first letter into row.