98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Pivot tables
Resolved · Medium Priority · Version 2003
Thu 29 Oct 2009, 16:22Delegate Cynthia said...
Fri 30 Oct 2009, 09:29Trainer Simon said...
RE: pivot tables
Hi Cynthia,
Thank you for your question and welcome to the forum.
The worksheet of data that the Pivot table is to be based on must be arranged in columns with field headings.
Go to Data and then Pivot Table and Pivot Chart Report and follow the steps of the wizard through and on the last screen choose the Layout option to select which fields you need to use to analyse the data.
I hope this answers your question.
Regards
Simon
Thu 5 Nov 2009: Automatically marked as resolved.
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. |
Excel tip:Excel 2010 Shortcuts - Start and End of the WorksheetDid you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard? |
