Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
|
|
|
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 tables
Resolved · Low Priority · Version 2007
Reply Tue 18 Jan 2011, 16:03Delegate Johanne said...
Johanne has attended:
Excel Introduction course
Excel Intermediate course
Pivot tables
how to do pivot tables
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Hello Johanne,
Hope you enjoyed your Microsoft Excelcourse with BEST Training.
Thank you for your question regarding Pivots.
To create a Pivot, click anywhere inside your data list in excel, then from the Insert Tab (ribbon), the first button on the left is Pivottable, Click this, then from the dialog that appears click OK (no need to change anything here).
A new sheet with an empty pivot tale will appear. On the Left will be a list of all the headings from your data table. You can drag these into the pivot into the relevant area. The pivot will be created automatically.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Tue 25 Jan 2011: Automatically marked as resolved.
|