excel 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 2007 - pivot tables

Excel 2007 - pivot tables

resolvedResolved · Low Priority · Version 2003

Sue has attended:
Excel Introduction course

Excel 2007 - pivot tables

What is a pivot table?

Edited on Wed 16 Jul 2008, 09:09

RE: Excel 2007 - pivot tables

Hi Sue,

Thank you for your post, welcome to the forum, in answer to 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 follow 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, and can now be manipulated or Pivoted by moving field headings to different locations.

Please note we cover Pivot Tables on the Excel Advanced Course.

I hope that has helped, regards Pete


 

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips


Server loaded in 0.08 secs.