Creating a simple PivotTable presentation kit


show more Creating a simple PivotTable presentation kit provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Creating a simple PivotTable presentation kit

PivotTables make it easy to emphasize aspects of your data whether that's monthly performance or sales to a customer. The problem with PivotTables is that it can be hard to remember how to reconstruct a position during a presentation. Having detailed notes helps, but you still have to take the time to manipulate your worksheet. In this movie I will show you how to create a simple Excel presentation kit that uses macros to recall positions. I have decided to run my macros by clicking shapes that I have positioned in row one but you can just as easily add macro buttons to the Quick Access Toolbar.

I've already recorded and assigned macros for the Year_Month and Quarter_Company shapes. So now what I want to do is record a macro for the company by month and year shape and then assign it. To record that macro I'll go to the View tab and then at the right end, click the Macros button's down arrow and then click Record Macro. Then in the Record Macro dialog box I can type in the ma...

Creating a simple PivotTable presentation kit
Video duration: 3m 23s 3h 43m Intermediate

Viewers:

Creating a simple PivotTable presentation kit provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...