What is New in Excel 2013

What is new in Excel 2013? 

Last week, Microsoft Introduced Office 2013 Preview, the next generation of Microsoft Office product. Excel 2013 ships as a part of Office 2013. 

Metro Look 

The new Microsoft Excel 2013 is totally redesigned and reimagined with a Windows 8 and Metro Style app interface. Here is the new logo with the Metro look:

You will also notice a new interface and Metro style fonts, navigation, colors etc.:

 

To the Cloud 

When you install Office 2013, it asks you for cloud connectivity and connects you with the Office 365 and SkyDrive. You will have to provide your LiveID to connect to SkyDrive and all your documents will be stored in the cloud. You can see from the above image that I can now save my documents on my local computer or on my SkyDrive in the cloud. 

More Templates

Now when you start Excel or create a new workbook, you will see a list of pre-loaded nicely designed templates. These templates include a wide variety of templates, from a family budget template to an inventory tracker template and your personal money tracker template. You can also search for more templates online.

 

New Ribbon Style

Metro style ribbon. The Save option can save your document to SkyDrive if you're connected online:

 

Also check out the new design of the footer including layout and zoom options:

Quick Analysis 

Quick Analysis is a new tool added to Excel 2013 that enables single-click access to data-analysis features, such as formulas, conditional formatting, Sparklines, tables, charts, and PivotTables. You just need to select some data and right-click and see various Quick Analysis options.

Smooth and Clear Selection 

One of the major issues in the previous versions of Excel was current selection visibility. Excel 2013 makes it simple to select and see what cell (rows and columns) are currently selected.

 

Apps for Office

Office 2013 now supports apps. Office developers can build apps and deploy and sell them. You may access, buy, and install these apps using the Apps for Office option within Excel 2013.

New Data Sources 

PowerPivot now supports more data sourcees including OData feeds, Azure SharePoint Data Feeds, OLEDB providers and even JASON and OAuth feeds. The new DataFeedConnection, ModelConnection, TextConnection, and WorksheetDataConnection objects are available now.

A new DataModel object model (OM) enables developers to load and refresh data sources programmatically.   

New Office 2013 Section on C# Corner 

Are you one of the guys who jumps on a new product right away? We just launched a new section on Office 2013 where you can share articles, blogs, tutorials and even tips.  

Share your blogs and articles or learn more about Office 2013 here >> 

Learn more What is new in Excel 2013 for developers