Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

ResolvedVersion 2003

Wed 18 Jun 2008, 11:26 Delegate Marnie said...

Marnie has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced course

Pivot tables

please explain how these work!

Fri 20 Jun 2008, 11:17 Trainer Amanda said...

RE: pivot tables

Hi Marnie

Thank you for your question.

Pivot tables can take a bit of time to get your head around.

I would suggest having a look at some online tutorials which will help explain why pivot tables are useful:

1. Microsoft 'What's so great about pivot table reports?' tutorial:
http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033& ;pid=CR061831141033

2. Contextures.com and Peltiertech.com are web sites I've found helpful with relation to Excel. Here is a page on the web site which lists various topics related to pivot tables you can choose from:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

I hope you find these useful.
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Pivot tables

Pivot tables

RE: pivot tables

Excel articles

Excel tip:

Quickly insert a function