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.
With Excel 2013, we made it our mission to simplify the chart customization process and to enable users to quickly modify their charts with a few simple clicks.
Slicers were first introduced in Excel 2010 and made filtering PivotTables as simple as clicking a button. We’ve taken the goodness of slicers but moved it beyond just PivotTables - with Excel 2013 you can now create slicers on any table!
Besides many new, exciting features, Excel 2013 also offers enhancements to older features even those that may be a little more obscure to the everyday Excel user. Today we will shed some light on one of these features. The feature that I want to talk about here is the OLAP based Calculated Members and Measures.
Definition and Caveat
OLAP is an acronym for online analytical processing. Although there are technically different OLAPs, we refer specifically to Microsoft SQL Server Analysis Services data sources.
Have you ever looked at a dashboard someone made and went, “man, I like that, but there’s too many steps for me to remember”? Or maybe wanted to have a way to play around with your data in a safe space so you don’t mess it up?
Power View is a new add-in for Excel 2013 that consumes the Data Model. For those who are avid readers of our blog, you will remember Diego did a post on the Data Model we’ve integrated into Excel. If you don’t remember that post (because not all of us are perfect), the gist is that there’s a new way to have lots of data in Excel and not slow it down while also having handy things like relationships (to make your handy dandy new in-workbook cube relational). Another thing to note is that the Power View add-in comes installed by default in Professional Plus versions of Office.
As Scott mentioned in his Charting Overview post, users have always struggled with picking the right chart type to represent their data. Unless you have a good understanding of the different chart types available and the types of data they work for, many users have trouble choosing the right chart type to properly represent their data, and often fallback to choosing something familiar. Even worse, sometimes users ended up choosing chart types that misrepresent their data, changing the message they’re trying to present. So as a part of the data visualization effort for Excel 2013, we focused on simplifying the process for making charts, and helping users easily and quickly make great looking charts that are appropriate for their data.
In this week’s webinar, we’ll show you some of the new features coming to Excel 2013. You can try them out right now during the free Customer Preview.
Click read more below to view entire webinar or watch the trailer now:
What you will learn at Tuesday's webinar:
We have 5 brand new Excel, Web Excel and SharePoint features to introduce to you in Office 2013, all designed to help you manage the use of spreadsheets and Access databases. I'll tell you about each of them in more detail, but the names really speak for themselves:
· Audit and Control Management Server
· Discovery and Risk Assessment
· Spreadsheet Inquire
· Spreadsheet Compare
· Database Compare
With the Office 2013 release, the Office DataViz team is proud to deliver a rich set of charting capabilities across Excel, Word, PowerPoint, and Project. In fact, because there are so many features, this article will only be an overview. Subsequent articles will go into the specific use cases and steps for each of them.
I’ve been working on Excel charting since the Office 2007 release, when we replaced the charting engine, changed the rendering layer, and enabled charts to run on the server. This was a pretty ambitious release, which set a whole new direction for data visualizations in Office. Since then, I’ve written several blog articles on Excel charting, and many of the reader comments have centered around when we were going to provide feature x, y, or z. I always appreciated these comments because it showed that there was a very passionate community of users who really cared about the charting capabilities in Office.