Pivot Tables

Resolved · Low Priority · Version 2003

Tue 16 Dec 2008, 17:00 Delegate Teresa said...

Teresa has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

How do I create a basic pivot table

Wed 17 Dec 2008, 15:19 Trainer Pete said...

RE: Pivot Tables

Hi Teresa,
Thank you for your question;
In reply: A pivot table is a summarisation of a larger database/list which can be viewed from different perspectives. To create a Pivot table you should use the Pivot Table wizard, as this allows you to correctly position your fields.
From your main table of information: Click in the database, go to the menu command Data>Pivot Table and Pivot Chart Report and follow the steps to create the frame for your Pivot table, drag your fields to the correct positions and your Pivot table is created for you. Formatting and subsequent rotation is undertaken by opening the Pivot Table toolbar and also by dragging and dropping fields to new locations. I hope that helps... Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips