advanced+excel+courses - Pivot Table

The UK's most regular instructor-led training courses.
Training information: advanced+excel+courses · Excel training courses · VBA training in London

· Low Priority · Version Standard

Pivot Table

Cat has attended:
No courses

by - delegate Cat [2 posts] (2008 Jan 31 Thu, 14:28) Reply

I am busy revising, and have come across this section, but have forgoten something, once i have to identified the exact location of the data i need to select the upper-left cell of the pivot table, where and how do i do this???
(this is just before i need to select the layout button)

thanks...

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot Table

by - trainer Stephen gold contributer [283 posts] (2008 Feb 10 Sun, 11:13) Reply

Hi Cat

Thankyou for your question

Could you please clarify your requirements for me?

In particular are you trying to create a new pivot table or manipulate an existing one. Also, is your source data organised as list; that is it is arrayed in columns with column headers?

Many thanks

Stephen

RE: Pivot Table

by - delegate Cat [2 posts] (2008 Feb 13 Wed, 19:35) Reply

Hi there,

yes i am trying to create a new pivot table, and yes it is in colums with column headers...

Tks,
Cat

· Excel Macros for the Non-Programmer
· How to Create Better Excel Spreadsheets: Part Two
· MS Excel: Excel At Making The Most Of Your Christmas
· How to Create Better Excel Spreadsheets: Part One
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips