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
In this week’s webinar, you’ll get an overview of two tools in Excel for crunching numbers so you can know what the numbers mean to your business: PivotTables and Slicers (new to Office 2010).
References for this webinar:
Go to http://aka.ms/offweb for more information on how to join the series.
--Doug Thomas
Comments: (5) Collapse
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
regards jeff
Hmmm, noodling on this a bit, as we aren't exactly sure what you want. Here's are two potential answers from the Excel writers:
but he may be able to do what he wants by turning on Classic View, so he can drag the calculated values where he wants them. When in a PivotTable, click the Options tab. On the far left of the Ribbon is the Options button. Look for Classic layout under Display.
Sounds like he wants to duplicate entries. You can do that in the Field List by dragging the same field to the Values area, and placing it below the field that’s already there. Then you can change the calculated field by using Show Values As (you’ll see that by right-clicking), or you could use another formula in that field, I believe.
This article was very interesting and helpful
Would it be possible to get the Excel file for this webinar? I would like to try to duplicate the steps.
You can practice the things I did here in the Office training courses. Open a course and look for the Practice link on the left hand side.
office.com/.../FX102828216.aspx
--Doug