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.
Tips
How-to
News
Videos
Stories
With Excel 2013, you now have a new default style and set of chart styles to apply to your chart. The new styles are designer quality and will make your chart beautiful in one click!
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