Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

Pivot Tables

Resolved · Medium Priority · Version 2007

Reply Tue 17 Feb 2009, 16:04Delegate Ann said...

Ann has attended:
Excel Intermediate course

Pivot Tables

What are they?

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Feb 2009, 09:55Trainer Amanda said...

RE: Pivot Tables

Hello Ann

Thank you for your question and welcome to the forum.

A pivot table is used to display data normally stored in columns (i.e. an Excel list or database), in a table or matrix format. It makes the data more flexible as it can be displayed in multiple ways.

For a bit of further information on pivot tables, please see
http://peltiertech.com/Excel/Pivots/pivottables.htm

Kind regards
Amanda

Tue 24 Feb 2009: Automatically marked as resolved.

Excel articles

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Getting To Grips With Gantt In Excel
· Creating Error Alerts In Excel Using Data Validation
· How To Use Functions In Excel 2010
· Which Is Better, Excel Or Access?

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

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips