Webinar: Excel PivotTables and Slicers

re: Webinar: Excel PivotTables and Slicers

Doug Thomas — Tue, 21 Aug 2012 14:44:59 GMT

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

re: Webinar: Excel PivotTables and Slicers

reearl001 — Thu, 16 Aug 2012 21:05:17 GMT

Would it be possible to get the Excel file for this webinar? I would like to try to duplicate the steps.

re: Webinar: Excel PivotTables and Slicers

jmgaskill — Sun, 17 Jun 2012 22:08:14 GMT

This article was very interesting and helpful

re: Webinar: Excel PivotTables and Slicers

Doug Thomas — Wed, 13 Jun 2012 18:07:50 GMT

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.

re: Webinar: Excel PivotTables and Slicers

spiderjeff — Wed, 13 Jun 2012 00:37:47 GMT

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