microsoft excel course - Pivot Tables

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

Resolved · Low Priority · Version Standard

Pivot Tables

Sab has attended:
Excel Advanced course

by - delegate Sab [1 post] (2007 Mar 16 Fri, 09:43) Reply

How do you create a pivot table?
What are the main functions of the pivot table?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot Tables

by - trainer Carlos gold contributer [394 posts] (2007 Mar 20 Tue, 11:54) Reply

Pivot tables allow you to look at data in several dimensions; for example, sales by region, sales by sales rep, sales by product.

To create a Pivot table:

Select a cell in the target table

Click Data / Pivot table and Pivot chart report

Follow the steps in the Wizard

· Advanced level training: Microsoft Excel and the Web
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Advanced Excel Training - takes you to the next level
· Fun Things I've Done With Excel

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips