Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

PIVOT TABLE

5 replies [Last post]
Mon, 2005-04-11 08:29
Sunil Kumar
User offline. Last seen 8 years 26 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
CAN ANYONE TELL ME IN DETAIL THE USE OF PIVOT TABLE IN EXCEL WHICH I BELEIVE IS XCELLLENT FOR TRACKING ENGINEERING IN A PROJECT.

THANX

Sunil
Top

Replies

Sun, 2005-04-17 14:08
#1
Philip Jonker
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
There is nothing like basics, pivot tables are nothing but bata bases and their indexes. Challenge
Top
Sun, 2005-04-17 05:12
#2
Sunil Kumar
User offline. Last seen 8 years 26 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Dylan, Andrew and Alexander,

Thankyou very much, They were fantastic leads to findout on Pivots.
Are there similiar sites on Access too...

Regards

Sunil
Top
Sat, 2005-04-16 13:15
#3
Dylan Wan, PMP EVP
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 9 Mar 2005
Posts: 13
Groups: None
Here is a PivotTable paper found in the Constrcution Financial Management Association web site:

www.cfma.org/documents/PivotTables.pdf
http://www.cfma.org/pivot_dir.htm

You can also get a sample spreadsheet from here:

www.cfma.org/PIVOT.xls

Hope this helps.
Top
Tue, 2005-04-12 02:08
#4
Andrew Podolny
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Hi there.
Here is online tutor
http://www.contextures.com/xlPivot01.html
(See the bottom of the a.m. page for additional info)
Top