98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table
Pivot table
Resolved · Low Priority · Version 2003
Shirley has attended:
Excel Advanced course
Excel Intermediate course
Pivot table
How do you st up a pivot table
RE: pivot table
Hi Shirley,
Thank you for your question.
Open the file you want to use for your pivot table and go to Data, Pivot Table...
The next step is to select Pivot Table and Excel list. Then select all the cells as the range of cells you want to analyse.
Save the Pivot Table on a new worksheet and then click Layout. In the Layout screen, you choose the row and column headings you want and where the two intersect you choose a data field.
Then click Ok and finish.
I hope this answers your question.
Regards
Simon
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:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |