Pivot Table

The UK's most regular instructor-led training courses.
Training information: excel training in uk · Excel training london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Pivot Table

Valine has attended:
Excel Introduction course

by - delegate Valine [1 post] (2008 May 2 Fri, 17:01) Reply

what are the advantages of a pivot table

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 20 Tue	Bloomsbury	7	book now	£218	£240
2003/XP	2008 May 21 Wed	Southwark	5	book now	£219	£235
2003/XP	2008 May 21 Wed	Bayswater	6	book now	£195	£205
2003/XP	2008 May 23 Fri	Bloomsbury	6	book now	£214	£230
2003/XP	2008 May 30 Fri	Southwark	6	book now	£214	£230
2003/XP	2008 Jun 4 Wed	Bayswater	7	book now	£203	£230
Full Schedule: See all 153 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Pivot Table

by - trainer Rich platinum contributer [610 posts] (2008 May 4 Sun, 16:13) Reply

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 otpion you set.

· Prepare for your MOS Certification with MS Excel Courses
· Crazy Things People Have Done With Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Training: Essential for Today's Employees
· Identifying Suitable Candidates For VBA For Excel Training

Please browse our web site to find out more about
excel training in uk and other Microsoft training courses.

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

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Pivot Table

Related articles

Excel tip:

Freeze Rows and Columns to keep lables displayed