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

what pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » What is a pivot table

What is a pivot table

ResolvedVersion 2007

Arienne has attended:
Excel Intermediate course

What is a pivot table

What is a pivot table

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

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

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.11 secs.