Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table
|
|
|
Bookmark this page|
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 table
Resolved · Low Priority · Version 2003
ReplyFor upcoming training course dates see: Pricing & availability
RE: pivot table
Hi Charlene,Thank you for your question and sorry for the delay in responding.
Open the spreadsheet and select any cell under the main headings. Go to Data and then the Pivot Tables option.
The wizard will then appear. Select excel database as the source and the Pivot Table option.
Then select the data source which must include all the headings and data source.
Finally tell excel where you want to place the pivot table. Then click Layout and choose which fields you want as Page, Row, Column and data.
Click OK and then Finish.
I hope this helps.
Regards
Simon
Tue 16 Feb 2010: Automatically marked as resolved.
|
 |
|
» Forum post: Master Project/Shared Resources |
I want to introduce the above to my dept, with everyone using the same package, how do I know whats been going on if there are more than 1 administrator ?? How do I keep up with it.....
