Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |