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 » What is a pivot table
What is a pivot table
Resolved · Medium Priority · Version 2007
RE: What is a pivot table
Hi Arienne,
Welcome to the forum, thank you for your question:
A pivot table is a summarisation of data which can be manipulated and viewed from different angles, if you have a large database and wish to summarise it; extracting either Totals, Averages, Highest or Lowest values etc, you could use a Pivot Table.
To create a Pivot table go to the menu command Data, Pivot Table and Pivot Chart Report, follow the Wizard's commands/suggestions to arrive at a grid which then allows you to place your field headings in the appropriate places. Your Pivot table will then be created.
I hope that has helped, if so please click the resolved link, thank you 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:Change the Print button so it brings up the Print dialogue boxIf you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following: |