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

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