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 » Excel pivot tables
Excel pivot tables
Resolved · Low Priority · Version 2003
Alexandra has attended:
Excel Intermediate course
Excel Advanced course
Excel pivot tables
what are they?
RE: excel pivot tables
Hello Alexandra
Thank you for your question and welcome to the forum.
A pivot table can be created from data that is displayed in columns in a spreadsheet, to allow any data in the column to be displayed in a table matrix.
For example, if you had a column with Region name, another with Month, another with Salesperson and a fourth with Sales, you could create from this a pivot table that shows:
Regions here
Months here Sales totals here
The pivot table can be changed around once created so you could then look at
Salesperson here
Months here Sales totals here
So you can analyse the data in different ways.
The Microsoft web site has a good tutorial (Pivot Tables 101) which you can find by searching for pivot tables on their web site.
Also we offer training on pivot tables as part of our Excel Advanced course.
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:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |