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
Jane has attended:
Excel Introduction course
Excel Intermediate course
Pivot tables
what are pivot tables
RE: pivot tables
Hi Jane, Thank you for your post and welcome to the forum, in answer to your question
Pivot Tables are a summarisation of data, which is able to be manipulated so that results can be views from different perspectives; (Did that make sense?)
To create a Pivot Table in Excel you must have your data laid out in a list, this means that each column must have a heading (field name) and the information in that column must relate to the heading. You should also have a field which is numeric values otherwise the only summarisation your Pivot table will be able to do is to count the entries for a particular Field item.
Your list should not have any row or column gaps, (when Excel sees a gap it will consider that the list has ended,) especially between the Field Name and the column below it.
Once you list is correctly created, select Data>Pivot Table and Pivot Chart report, and follow the Wizard instructions to place your fields in either Page, Column, Row and Data locations.
You will now be viewing your Pivot Table which can be manipulated further by using the options on the Pivot Table Toolbar.
I hope that has helped you to understand them a little more, regards Pete
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:Jumping Across the Excel ScreenPgDn and PgUp keys scrolls up and down a screen page in most applications. |