Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » advanced+excel+courses - Pivot Table

advanced+excel+courses - Pivot Table

ResolvedVersion Standard

Thu 31 Jan 2008, 14:28 Delegate Cat said...

Cat has attended:
No courses

Pivot Table

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...

Sun 10 Feb 2008, 11:13 Trainer Stephen said...

RE: Pivot Table

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

Wed 13 Feb 2008, 19:35 Delegate Cat said...

RE: Pivot Table

Hi there,

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

Tks,
Cat

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

advanced+excel+courses - Pivot Table

Pivot Table

RE: Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel