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 courses - What is a pivot
excel courses - What is a pivot
Resolved · Low Priority · Version Standard
Tracey has attended:
Excel Intermediate course
What is a pivot
how do I use a pivot chart, also if I have data sent to me in a pivot on it how can I delete it.
thanks
RE: what is a pivot
Hi Tracey,
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.
You should have a data table associated with the Pivot table, so in theory you can delete the Pivot table and leave the data in the standard format.
I hope this gives you an idea of what pivot tables can do.
Tracy
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:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |