excel microsoft training - Macro Pivot Tables

Resolved · Low Priority · Version Standard

Fri 18 Jan 2008, 10:05 Delegate Gary said...

Gary has attended:
Excel Intermediate course
Excel Advanced course

Macro Pivot Tables

"How do I build macros & Pivot tables?"

Mon 21 Jan 2008, 15:12 Trainer Katie said...

RE: Macro Pivot Tables

Hi Gary,

Thanks for your question.

To build MACROS:

Select TOOLS menu > Macro
Select RECORD NEW MACRO
Name macro (no spaces / no special characters)
Assign shortcut key if necessary
Press OK & start recording the procedures
to finish, press STOP RECORDING
(under TOOLS menu > MACRO again)

To build PIVOT TABLES:

Click anywhere within your data table
Select DATA menu > PivotTable & PivotChart Report
Press NEXT, Confirm Data region, Press NEXT again.
Select the location of new Pivot Table
Press FINISH

Hope this helps.

Regards,

Katie

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips

excel microsoft training - Macro Pivot Tables

Macro Pivot Tables

RE: Macro Pivot Tables

Excel articles

Excel tip:

How to select certain data in an Excel 2010 workbook