Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Advance excel
|
|
|
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. |
microsoft excel training - Advance excel
Resolved · Low Priority · Version Standard
Reply Fri 7 Dec 2007, 17:06Delegate Basil said...
Basil has attended:
Excel Advanced course
Excel Advanced course
Advance excel
Understanding pivot tables
For upcoming training course dates see: Pricing & availability
RE: Advance excel
Hi Basil, Thank you for your post, In answer to your post, A pivot table is a summarisation of data which can be manipulated and viewed from different angles, if you have a large database and wish to summarise it; extracting either Totals, Averages, Highest or Lowest values etc, you could use a Pivot Table. To create a Pivot table follow the menu command Data, Pivot Table and Pivot Chart Report, follow the Wizard's commands/suggestions to arrive at a grid which then allows you to place your field headings in the appropriate places. Your Pivot table will then be created. I hope that helps, best regards Pete.
|