pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · Low Priority · Version 2007

Sam has attended:
Word Advanced course
Excel Intermediate course
PowerPoint Intermediate Advanced course

Pivot Tables

How do you use pivot tables?

RE: Pivot Tables

Hi Sam,Thank you for your post;

In answer to your question, a Pivot Table is an interactive worksheet table that can summarise large amounts of data using the views and permutations that you choose.
It is called a Pivot Table because you can rotate its row and column headings around the core data to give you different views of the source data.
As the source data changes you can update the pivot table, a pivot table can be used as a source for a pivot chart. regards Pete.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.1 secs.