advanced+excel+courses - Pivot Table

Resolved · Low Priority · Version 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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips