You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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.
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.
One 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!
For 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.
It’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…
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!
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?
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.
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.
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.
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?
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 www.accessanalytic.com.au/.../20120601ArticleFutureofExcel.pdf
Thanks for the reply Dan. I will check them out. Also, can you refer any web service which returns financial data?
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.
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.
A2 is =FILTERXML(B2; "id") and B2 is <?xml version="1.0" encoding="UTF-8"?<id>10319555</id><name>Sergio</name>
It does not work, I'll love to know why
Thanks for your kind help
Sorry the XML was remove from my post XML is a valid XML with 2 elements name and id
@smabres - A better place to ask questions like this is in the forum: answers.microsoft.com/.../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!
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 ?
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.