Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darlene
 
Posts: n/a
Default Moving excel data into a pivot table

I currently have an excel spreadsheet which contains a lot of data. I am
then manipulating this data to find root cause. I am graphing the data in
several differnt formats. The questions I have is would it make sense to
move this data into a pivot table and pivot charts to be able to control the
data managment better? Also if you can send me simple links in regard to how
pivot tables work and thier benefits it would be appreciated. Thanks for the
help, Darlene
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Moving excel data into a pivot table

http://peltiertech.com/Excel/Pivots/pivotstart.htm


http://www.contextures.com/tiptech.html

Regards,


Peo Sjoblom

"Darlene" wrote:

I currently have an excel spreadsheet which contains a lot of data. I am
then manipulating this data to find root cause. I am graphing the data in
several differnt formats. The questions I have is would it make sense to
move this data into a pivot table and pivot charts to be able to control the
data managment better? Also if you can send me simple links in regard to how
pivot tables work and thier benefits it would be appreciated. Thanks for the
help, Darlene

  #3   Report Post  
Posted to microsoft.public.excel.misc
James Hamilton
 
Posts: n/a
Default Moving excel data into a pivot table

Pivot tables are really easy - easier than you think. They effectively allow
you to "drag and drop" the data you require to come up with a table of
information based on what you want to see.

I haven't got a link, but I think the best way to learn pivot tables is to
spend a bit of time playing around with them.

"Peo Sjoblom" wrote:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


http://www.contextures.com/tiptech.html

Regards,


Peo Sjoblom

"Darlene" wrote:

I currently have an excel spreadsheet which contains a lot of data. I am
then manipulating this data to find root cause. I am graphing the data in
several differnt formats. The questions I have is would it make sense to
move this data into a pivot table and pivot charts to be able to control the
data managment better? Also if you can send me simple links in regard to how
pivot tables work and thier benefits it would be appreciated. Thanks for the
help, Darlene

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
get SQL Server text data type into Excel pivot table Lee@360Commerce Excel Discussion (Misc queries) 0 August 19th 05 11:37 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
display data as a percentage of a subtotal in excel pivot table Fl pivot user Excel Discussion (Misc queries) 2 March 26th 05 12:24 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"