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 tables
Pivot tables
Resolved · Low Priority · Version 2003
RE: Pivot tables
Thank you for your question.
My name is Greg and I have just joined Best Training.
1. Select the data you wish to use.
2. From the Menu Bar, go to the Data option, then PivotTable and PivotChart.
3. Go through the Wizard. When you get to step 3, choose the Layout button, then move the various "data" to the appropriate place by using the drag-and-drop technique.
I hope this answers your question. Please contact me if you have any other questions.
Thank you
Greg
RE: Pivot tables
Thank you for your question. My name is Greg and I have just joined Best.
To get started with Pivot Tables:
1. Select the data you which to use.
2. Go to the Menu Bar, select Data the PivotTable or PivotChart option.
3. Go through the Wizard which should have 3 steps. On third step, click on the Layout button, then drag-and-drop the fields on the right to the appropriate places.
I hope this helps. Please do not hesitate to contact me if there are any problems or further questions.
Greg
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:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |