Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Pivot Tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training microsoft - Pivot Tables

Resolved · Low Priority · Version Standard

Reply Mon 28 Jan 2008, 09:43Delegate Matthew said...

Matthew has attended:
Excel Intermediate course

Pivot Tables

The issue I have with pivot tables is that it is difficult knowing what data goes where

For upcoming training course dates see: Pricing & availability

Reply Thu 7 Feb 2008, 10:29Trainer Amanda said...

RE: Pivot Tables

Hi Matthew

Thank you for your question, and apologies for the delay in response.

The whole idea of the pivot table is that it gives you numerous choices in how you choose to display your data. Really there are no 'rules' on where items go in the pivot table area, apart from numerical values should go into the data items area.

I hope this helps.
Amanda

Excel articles

· Tips To Help You Excel
· How to Create Better Excel Spreadsheets: Part One
· Find Out How To Create That Missing Link With Excel
· Excel 2010 - Is It Worth The Upgrade?
· Formulas In Excel: The Very Basics

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