Pivot tables

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

Resolved · Low Priority · Version 2007

1 post

ReplyWed 17 Jun 2009, 15:34Delegate John said...

John has attended:
Excel Advanced course

Pivot tables

In pivot tables, how do you summarise data so that it does not appear for every field?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	5		£199	£204
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
2007	Tue 30 Mar 2010	Southwark	5		£199	£204
2003	Thu 1 Apr 2010	Bloomsbury	4		£207	£212
Full Schedule: See all 77 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

2,024 posts

ReplyThu 18 Jun 2009, 14:00Trainer Amanda said...

RE: Pivot tables

Hello John

Thank you for your question and welcome to the forum.

Could you please explain your question further?

Thanks
Amanda

· Reporting and Analysis with Excel
· Utilise the web's information banks with Microsoft Excel
· Microsoft Excel Features and Functions for Accountants
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Correct In, Garbage Out

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

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips