pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Pivot tables

resolvedResolved · Medium Priority · Version 2003

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

Pivot tables

please explain how these work!

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


 

Excel tip:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

View all Excel hints and tips


Server loaded in 0.07 secs.