Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Pivot tables
Resolved · Low Priority · Version Standard
Hi Jacques
Thanks for your question.
The idea behind a pivot table is to take information that is stored in a series of columns in Excel (a list) and turn it into a summarised table format.
The pivot table allows you to collate/summarise individual values that are stored in a column, by for example, summing them, averaging them, displaying percentages of totals and so on.
The major advantages of a pivot table are that you can rearrange the items you put into the table quickly and easily by dragging and dropping; and you can create a chart from it by clicking a button.
Tracy
|
Excel tip:Display Functions on WorksheetsFunctions in Excel can be difficult to recall their format/syntax |
We'll call during UK business hours
Server loaded in 0.1 secs.