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 · Medium Priority · Version 2007
Kevin has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Pivot tables
What is the sequence for building a pivot table.
RE: Pivot tables
Hello Kevin
Thank you for your question.
To create a pivot table:
1. Click within the columns of data you wish to be able to use within the pivot table once it has been created (including headings in the first row of the columns).
2. Go to Insert and click PivotTable and Pivot Table again.
3. Select the range of cells you want to include in the pivot table.
5. Select whether you want to create the pivot table in a new worksheet, or in the same worksheet as the data you have selected.
6. The pivot table areas appear on the page.
7. Tick/check the field/s you wish to include in the pivot table.
The fields will appear in the boxes underneath - you can drag and drop the field into different areas of the pivot table by moving fields into different boxes. Fields can be removed by unchecking them in the list of fields provided.
Amanda
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:Shortcut for deleting all comments in a spreadsheetIf you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by: |