Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

ResolvedVersion 2003

Tue 13 May 2008, 17:03 Delegate Shanna said...

Shanna has attended:
Excel Intermediate course

Pivot tables

what is a pivot table?

Thu 15 May 2008, 20:07 Trainer Cress said...

RE: pivot tables

Go to data, then pivot table and chart and follow the wizard. You must have your data already on the sheet first. If for example you have a sheet of sales data and each row has a country to show where the sale happened, you can put it into a pivot table to give a group summary on sales per country. It will show all country data, or you can pick a particular country and it will automatically give you a sum of the sales value or the number of sales depending on the option you set.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Pivot tables

Pivot tables

RE: pivot tables

Excel articles

Excel tip:

Freeze Rows and Columns to keep lables displayed