Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Pivot tables
introduction excel training - Pivot tables
Resolved · Low Priority · Version Standard
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Hi Jo
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.
Amanda
|
