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

pivot tables

ResolvedVersion 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:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.