microsoft excel training london - Pivot table

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

Resolved · Low Priority · Version Standard

Pivot table

Holly has attended:
Excel Intermediate course

by - delegate Holly [1 post] (2007 Feb 27 Tue, 09:51) Reply

please can you tell me how to create a pivot table and why are they used?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: pivot table

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 27 Tue, 11:01) Reply

Hi Holly,

1. Enter the data you require for the Pivot table.
2. Select any cell within that data range
3. Then click Data > Pivot Table and Chart Reports
4. Follow all the steps of the wizard
5. Drag the fields you want to see onto the pivot table from the field list.

Pivot tables can be a more efficient way to view data

Hope that helps and enjoy your training

Tracy

· Identifying Suitable Candidates For VBA For Excel Training
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Do You Really Need Excel VBA Training?
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips