pivot table

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table

Pivot table

resolvedResolved · Medium Priority · Version 2007

Sarah has attended:
Excel Advanced course

Pivot table

How do you merge a pivot table into a powerpoint presentation and have access to the pivot table data on the powerpoint presentation

RE: pivot table

Hello Sarah

Thank you for your question and welcome to the forum.

I found the following information on creating interactive pivot tables in PowerPoint, which might be useful to you.

http://www.tushar-mehta.com/powerpoint/pivottable_in_slideshow/

Please note that the instructions are for PowerPoint 2003, I think the main difference will be finding the Microsoft Office Pivot Table object since there is not a Control Toolbox toolbar in 2007.

You should find the same objects however on the Developer Ribbon in PowerPoint 2007.

If the Developer ribbon is not showing in PowerPoint, then do the following:

1. Click the Microsoft Office Button, select PowerPoint Options.
2. Click Popular, select the Show Developer tab in the Ribbon check box and click OK.


To find the Pivot Table object, go to the Developer tab, click More Controls in the Controls group.

I hope this helps.


Kind regards
Amanda

Wed 27 May 2009: Automatically marked as resolved.


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.11 secs.