Pivot tables

The UK's most regular instructor-led training courses.
Training information: basic training excel · Excel-courses-london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyMon 25 Jan 2010, 09:37Delegate Arjuna said...

Arjuna has attended:
Excel Introduction course

Pivot tables

I want to know more about pivot table customisation. Thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	1		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

1,055 posts

ReplyTue 26 Jan 2010, 14:06Trainer Andrew said...

RE: Pivot tables

Hi Arjuna

Thank you for your question. Here is an interesting article from Microsoft regarding Pivot Tables in Excel 2007.
http://office.microsoft.com/en-us/excel/HP101773841033.aspx?pid=CH101768451033

We also cover the topic in more depth on our Excel 2007 Advanced Training (more details at
http://www.microsofttraining.net/excel-2007-advanced.php)

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 2 Feb 2010: Automatically marked as resolved.

· Compare Different MS Excel Training Methods
· Simple Ways To Customise Excel
· Advanced level training: Microsoft Excel and the Web
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Using Dates Within Excel

Please browse our web site to find out more about
basic training excel and other Microsoft training courses.

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips