Pivot Tables and Macros

Resolved · Low Priority · Version 2007

Mon 13 May 2013, 16:44 Delegate Kathryn said...

Kathryn has attended:
Excel Introduction course
Introduction to Management course

Pivot Tables and Macros

Furthe Details

Tue 14 May 2013, 10:10 Trainer Rodney said...

RE: Pivot Tables and Macros

Hello Kathryn,

Hope you enjoyed your Microsoft Excel Introduction course with Best STL.

Thank you for your question regarding further details on PivotTables and Macros.

Both of these topics are covered in our advanced course which you are welcome to participate in. Until then, I have provided you with links from Microsoft to help you out with your request.

PivotTables

http://office.microsoft.com/en-gb/excel-help/pivottable-i-get-started-with-pivottable-reports-in-excel-2007-RZ010205886.aspx

Macros

http://office.microsoft.com/en-gb/excel-help/create-or-delete-a-macro-HP010014111.aspx

I hope these links are helpful and resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Tue 21 May 2013: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips