microsoft excel training class - Pivot Table

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

Resolved · Low Priority · Version Standard

Pivot Table

Amari has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel Intermediate course

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

What is a pivot table and what is it used for.

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, 10:55) Reply

Hi Amari,

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

Tracy

· Advanced level training: Microsoft Excel and the Web
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Do You Really Need Excel VBA Training?
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.

Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.

To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips