Back
Excel

Introducing Excel 2013

This blog post is brought to you by Jane Liles Group Program Manager for the Excel team. With this post she kicks off a brand new blog series introducing all the features we have added across Excel for the release of Office 2013.

Greetings from the Excel team hallway…

By now you’ve hopefully tuned into our Office Next blog, which provides all-up view of our latest release for Office, and seen some articles on the web. Today I have the privilege of sharing a high-level view of Excel 2013, a release that arrives on the heels of Excel’s 25th anniversary. The team has been working hard to deliver the next version, and we’re excited to be able to share Excel 2013 Preview with you and hear your feedback.

Excel is a powerful spreadsheet and data analysis application, with hundreds of capabilities that can help you organize and make sense of the data and numbers in your life. We’ve made several investments in Excel 2013 to empower our users by bringing these and more capabilities to you in ways that are easy, intuitive, and enjoyable. But before I tell you about where we focused our efforts, I’d like to share a little about how we got there.

It Begins with Our Customers…

When we began planning for Excel 2013, we started by doing a ton of customer research. Yes, we do this every release, but this time our goal was really to cast the net wide and get a sense of the full spectrum of users, from the spreadsheet dabblers to the analysts and “super-crazy power user” (you probably know a few of these Excel gurus). We visited small businesses, home offices, “consumers”, and large organizations, and observed Excel users in action. We conducted surveys and focus groups, mined the blogosphere, interviewed people 1-on-1, and consulted our MVPs, friends and families. And we listened to feedback from past releases. Then we took some time to wallow in the resulting data and do some analysis (go figure — we’re the Excel team, we like to analyze.). The insights we gained from this customer research played a major role in our decisions about where to invest.

We proceeded into development with 4 major areas of investment, with one consistent theme across all of them: empowering our users. As I mentioned at the beginning of this post, Excel is a powerful application – and many of our users have become experts at harnessing that power and turning that into results: lists, spreadsheets, reports, business solutions, in-depth analyses, dashboards, etc.

Enjoyable Experience, With More Smarts Built in

clip_image004One of the things we learned through our customer research was that while many people know that Excel has a wealth of capabilities, they can sometimes feel intimidated by all of the options available and aren’t sure how to use them. So this time we made it a priority to provide a cleaner experience that puts the focus on your content and offers features that are appropriate to what you’re doing — you’ll see this in both the Excel desktop client (“traditional Excel”) and the Excel Web App. We also provided some additional guidance to show you what’s possible, and to help you make your data do and look like what you want, more quickly, with less hunting around and trial-and error. Features like Quick Analysis, Flash Fill, Chart Recommendations, and PivotTable Recommendations are examples of this type of guidance. Do you have trouble getting charts to look right? We’ve made it easier to create the right chart, and customize it with a couple of clicks. We’ll go into more details about all of these in future posts. Do you use multiple monitors and wish you could have an Excel workbook open on each of them? Well, with Excel 2013 you finally can!

Powerful, Integrated Business Intelligence Capabilities

clip_image006For Excel 2013 we decided to make major investments in BI, and in particular, we had a goal to make Excel a full-fledged self-service BI tool. If you have already discovered PowerPivot for Excel 2010 and SharePoint 2010, you’ll be happy to see that we’ve integrated the same tabular data model natively into Excel 2013! We’ve also included new analysis capabilities like Quick Explore, Timeline slicers, PowerPivot and Power View – yes, PowerPivot and Power View now come with Excel and integrate with the Excel experience – in the client and in the Web App via SharePoint and Excel Services. Wow! For Enterprise-scale BI, the convenience of self-service in Excel on the front end is backed by the collaboration, scalability, reliability, and compliance/control of SharePoint with Excel Services and SQL Server 2012.

There is so much to tell about BI and Excel 2013…consider this a teaser.

Excel, Everywhere You Need It to Be

clip_image008It’s important to our customers to be able to get to their Excel spreadsheets from wherever they are, on whatever device they’re using. Whether it’s from their PC at work, their laptop at home, a Mac, a tablet while on the go, or their phone, Excel users need to get to their data. For 2013 we invested in that Excel Everywhere experience by increasing our investment in Excel on tablet devices and in the browser, aiming to help users getting the most out of our SkyDrive and O365 services with enhancements to the Excel Web App and embedding capabilities, as well as the sharing and touch input experiences. More on “Excel Everywhere” in our next post…

New Office Application Model

clip_image010Do you build solutions for Excel? If so, you probably know that the world of application and solutions development has evolved significantly towards web services and live content over the past couple of years. In this release you will be able to extend Excel to include web services content by creating and embedding the new Office Apps right into Excel using simple JavaScript and HTML5– and they will work in the client and in the Web App!

clip_image012

We’re eager to share everything Excel 2013 with you in more detail, and we promise that we will. Stay tuned for more posts about Excel 2013, and please try it out for yourself by going to the Office 2013 Customer Preview site!

Join the conversation

20 comments
  1. We use VBA extensively for automation needs…so it will be interesting to see how much I will be able to move over to the new application model. You folks might want to consider working with Channel 9 to contribute a developer oriented show/series, ex. "Office Dev" and link to those videos here. Hopefully SharePoint Sideshow will make a come back too.

  2. Is the ability to "check out" or "check in" a file that was opened from a SharePoint doc library supposed to be missing? It doesn’t show up on the File tab anymore, and when I manually add those buttons to my Quick Access toolbar, they are grayed out.

  3. The Consumer Preview makes a fresh impression and I work quite properly with pleasure with it. However, I miss a German version which was equally available, nevertheless, with the Preview of Windows 8. Any information, when and how?

  4. Is there any function in excel webapps similar to googlefinance() function which is part of google spreadsheets? Thats the only reason why I am still using google docs.

    • @Dasaratha – We don’t have a specific finance function in Excel (or Excel Web App) yet, but check out the =WEBSERVICE() and =FILTERXML() functions that are part of Excel 2013. These will let you grab financial data from a web service and then parse out the specific info you are looking for. These are in the Excel 2013 Preview, and while they aren’t in the Excel Web App Preview yet, we’re considering adding them in the future. Would love to hear if they meet your needs.

      • Thanks for the reply Dan. I will check them out. Also, can you refer any web service which returns financial data?

  5. Hurrah!

    "Do you use multiple monitors and wish you could have an Excel workbook open on each of them? Well, with Excel 2013 you finally can!"

    The feature that I’ve been asking for will finally make it into a product! Hurrah!

  6. All these fancy new features are nice and I’m sure that the developers think they are to die for! However, I wonder how many users will actually use many of the advanced features. Even more important, how many really significant complaints have been addressed (and resolved) with this upgrade.

    Related to the question above, are all the new bells and whistles really worth the price of a new upgrade? What has happened to the service pack upgrades?

  7. Thanks for the preview Jane – it looks very interesting so I’m looking forward to upgrading! The multiple monitor feature is reason enough on its own! I wrote an article a little while ago "8 Bold Predictions about the Future of Excel" which might be of interest if you’re considering ideas for Excel 2016 and beyond http://www.accessanalytic.com.au/pdf/20120601ArticleFutureofExcel.pdf

  8. Will a Powerpivot report be fully available in Sharepoint 365 Online offer?
    I want to refresh report in my PC and open it and use Slicers and Pivot tables filters in the web app.

  9. I am pleased with this vesion of Excel and can’t wait to get it the very first day with the full version of Office 15 or 2013 on launch date.

  10. A2 is =FILTERXML(B2; "id") and B2 is 10319555Sergio
    It does not work, I’ll love to know why
    Thanks for your kind help

  11. Sorry the XML was remove from my post XML is a valid XML with 2 elements name and id

  12. @smabres – A better place to ask questions like this is in the forum: http://answers.microsoft.com/en-us/office/forum. For this specific question, there are a couple things to change: First, you need to have valid XML (you’re missing a root node, which I’ve called "item" – so the correct XML is as follows: [?xml version="1.0" encoding="UTF-8"?][item][id]10319555[/id][name]Sergio[/name][/item]
    (NOTE: replace all brackets with less than/greater than as appropriate). Second, you need to use xpath in the FILTERXML formula, so the correct syntax is: =FILTERXML(B2, "//id"). Hope that helps!

  13. re: "Even more important, how many really significant complaints have been addressed (and resolved) with this upgrade."
    I’d like a response to this as well. SP1 of Office 2010 only solved some problems….many still remain. Also I’d like to know why SP2 never happened ?

  14. I have a comment about the new version of Excel.

    Will there be a way to convert/translate formula/function names between english and local versions?

    This has been something thats a little frustrating when working with Excel in diffenrent language versions (Norwegian, English and German).

    Opening a spreadsheet in another language does this automatically, but when creating a new spreadsheet you need to know all the local formula names.

  15. Would it be possible to address some of the long standing, non-sexy bugs and limitations of Excel?

    One that is currently causing me grief is that vba Range.DirectDependents does not work intersheet. It has not worked since at least Excel 1995.

    The work around is the horrible NavigateArrows hack. But this has problems like being slow, requiring unprotected workbooks, killing undo, and killing copy/paste.

    The code for doing the precedents must be in the Audit Toolbar code. One just needs to create a new method, range.EvaryDirectDependent (say).

    Is there even a mechanism where members of the community can request such things?

  16. Hi all, who knows how I can create a second, third or more pages in Power View with Excel 2013? I didn’t find such opportunity (button) in the Power View ribbon…

    Thx, wieba68

  17. What has happened to workspaces (.xlw), Excel 2013 is now horrible to use with multiple monitors. with 2010 and nview I could open four workbooks spanned across my monitors with one click. Now I can’t get two sheets of the same work book to span two monitors. This is a terrible implementation – I’m going back to 2010 – concatenate and ctrl+h instead of flash fill is much better than having five ribbons taking up my screen real estate.

  18. Do Excel 2013 contains a scale breaker for charts? also any built in method for creating waterfall charts?. Excel really miss this

Comments are closed.