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 » basic training excel - Pivot tables
basic training excel - Pivot tables
Resolved · Low Priority · Version Standard
Martin has attended:
Excel Intermediate course
Excel Introduction course
Pivot tables
i want to know what pivot tables are and how i could use these in the job
RE: Pivot tables
Hi Martin
Pivot tables allow you to take figures and associated labels stored in a list format in Excel, and summarise the figures in a table-like format.
This is something that's easier to see rather than explain - if you look up pivot tables in Excel Help, it provides some diagrams which will help you to understand how a pivot table displays information.
The advantage of the pivot table is that once it is created, parts of the table can be rearranged, for example, if I have years listed in rows and product names listed at the top of columns, I can switch these around.
I hope this gives you an idea of what pivot tables can do.
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; |