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.
Do you belong to LinkedIn? Did you know that LinkedIn has lots of Excel user groups where Excel trainers, developers, financial modelers, and even Excel blackbelts compete to out geek each other--or just share information. (The Excel Blackbelt group is for data visualization experts.)
We loved this recent discussion in the Excel Trainer group when Tina Williams from the UK got the conversation going by asking: "Hello Fellow Trainers! Quick question... what is your favourite thing [notice the British spelling] about PivotTables?"
Here's a summary of the group's favorite things (notice the American spelling) that Excel PivotTables let you do:
So what's your favorite feature or reason for using a PivotTable? You can answer here or head over to join the conversation on LinkedIn.
My new favorite features are Slicers. Filtering a pivot table was always a little challenging to me. I have some experience with pivot tables but I'm far from being a black belt with them. Slicers make it extremely easy to focus on specific data without having to struggle to figure out where I needed to click to filter it out.
Everyone agrees pivot tables are AWESOME. But I think a more fruitful conversation is to discuss the things we like least about pivot tables (there aren't many). A point of frustration for me is that Pivot tables should be able to count unique instances of a data point. Using "=1/sumifs" formulas in the dataset is brilliant, but problematic if you have a very large dataset but are not using a supercomputer. In a pivot table I should be able to count the number of widgets sold in a particular month, AND the total number of unique customers to whom I sold those widgets, or the total number of stores that sold those widgets.
Jmeyer: Thanks for chiming in and explaining your scenario, and sorry about the frustration. We’ll pass on your feedback to the product team.
JoAnn: Great! I love slicers, too (new in Excel 2010). If you want to learn more, see this post: blogs.office.com/.../dressing-up-your-slicers.aspx
And Pedro, thanks for the pointer to your DevScop add-in
Emily, the Office Blog team
I use it to look differntly at my data in MsAccess. It is much easier to find errors in my data when looking at it in a pivot table.
I'm not sure this is the place to mention it, but there is a bug in the 2007 version.
I have a DB with SF books and one of the authors is Julian May. In the pivot table May is, when sorted on authors name, the first record because May is also the name of a month.
Hello , I need help ... before in excell 2003, you could put twice the info in the values section .. put one in sum and the other in count and the info was one on top of the other in one collomn but now it puts it side by side and that puts it to wide ... I want to do it klike the old version ! how can we do that