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

excel training microsoft - Pivot Tables

ResolvedVersion Standard

Mon 28 Jan 2008, 09:43 Delegate 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

Thu 7 Feb 2008, 10:29 Trainer 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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

excel training microsoft - Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Turn Function tooltips on and off