98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - What can a pivot table be used for?
basic training excel - What can a pivot table be used for?
Resolved · Low Priority · Version Standard
Wed 8 Nov 2006, 10:13Delegate Howard said...
Howard has attended:
No courses
What can a pivot table be used for?
What is a pivot table? and what can it be used for?
Thu 9 Nov 2006, 10:19Trainer Richard said...
RE: Excel training course
A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.
Use a PivotTable report when you want to analyze related totals, especially when you have a long list of figures to sum and you want to compare several facts about each figure.
An example would be looking into a sales report, broken down by Region, Product, Sales Person or Quarterly Totals. You are able to expand and contract the detail of each area to focus on the detail that is most important to you.
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:Quickly hide and unhide rows and columnsUse the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D. |
