excel consultant - pivot

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Pivot

excel consultant - Pivot

resolvedResolved · Low Priority · Version Standard

Stuart has attended:
Excel Advanced course

Pivot

What is a pivot table?

RE: Pivot

Hi Stuart

Thanks for your question.

The idea behind a pivot table is to take information that is stored in a series of columns in Excel (a list) and turn it into a summarised table format.

The pivot table allows you to collate/summarise individual values that are stored in a column, by for example, summing them, averaging them, displaying percentages of totals and so on.

The major advantages of a pivot table are that you can rearrange the items you put into the table quickly and easily by dragging and dropping; and you can create a chart from it by clicking a button.

Tracy

 

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:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips


Server loaded in 0.13 secs.