Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot
Resolved · Low Priority · Version 2007
Reply Thu 6 Jan 2011, 16:02Delegate John said...
John has attended:
Excel Intermediate course
Pivot
Need a concise description of pivot and its workings
For upcoming training course dates see: Pricing & availability
RE: pivot
Hi John, thanks for your query.
Put simply a Pivot table is a summarising and analytical tool, affording structural flexibility in the construction of bespoke tables from a source of data. There are two key things to remember about pivot tables: 1) the pivot table functionality in Excel is a creative tool; it's easy to create a new table using it, but what you do with it after that is entirely up to you, and 2) the pivot table created is not dynamically connected back to your source data, so you must remember to refresh when you change your source data. We create and manipulate pivot tables on our Advanced Excel course, but here is a brief walkthrough of basic functionality:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
Hope this helps,
Anthony
|