Skip to main content

What’s New in Excel 2013?

When a new version of Microsoft Office is released, sometimes Excel gets lots of new features and other times it gets very few new features. In the case of Office 2013, Excel got quite a few new features.Here’s a quick summary of what’s new in Excel 2013, relative to Excel 2010:

  • Backstage: The Backstage screen has been reorganized and is easier to use.
  • Support for Apps for Office: You can download or purchase apps that can be embedded in a workbook file.
  • New types of assistance: Excel provides recommended pivot tables and recommended charts.
  • Support for other devices: Excel is available for other devices, including touch sensitive devices such as Windows RT tablets and Windows phones.
  • Single document interface: Excel no longer supports the option to display multiple workbooks in a single window. Each workbook has its own top-level Excel window and Ribbon.
  • New Slicer option: The Slicer feature, introduced in Excel 2010 for use with pivot tables, has been expanded and now works with tables.
  • Enhanced chart formatting: Modifying charts is significantly easier.
  • Fill Flash: Fill Flash is a new way to extract (by example) relevant data from text strings. You can also use this feature to combine data in multiple columns.
  • Cloud storage: Excel is tightly integrated with Microsoft’s SkyDrive web-based storage.
  • The Data Model: Create pivot tables from multiple data tables, combined in a relational manner.
  • Quick Analysis: Quick Analysis provides single click access to various data analysis tools.
  • Timeline filtering: Similar to the Slicer, the Timeline makes it easy to filter data by dates.
  • New worksheet functions: Excel 2013 supports dozens of new worksheet functions.
  • New aesthetics: Excel has a new “flat” look and displays an (optional) graphic in the title bar. The default color scheme is white, but you can choose from two other color schemes (light gray and dark gray) in the General tab of the Excel Options dialog box.
  • New add-ins: Three new add-ins are included (for Office Professional Plus only): PowerPivot, Power View, and Inquire.

Leave a comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>

1 comment
  1. UM
    umesh

    dear sirs,
    i want to study all excel in this site just like a book so u should provide all chapters of this book
    regards umesh