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
peltiertech.com/Excel/Pivots/pivotstart.htmwww.contextures.com/tiptech.html
Regards,Peo Sjoblom
quot;Darlenequot; wrote:
gt; I currently have an excel spreadsheet which contains a lot of data. I am
gt; then manipulating this data to find root cause. I am graphing the data in
gt; several differnt formats. The questions I have is would it make sense to
gt; move this data into a pivot table and pivot charts to be able to control the
gt; data managment better? Also if you can send me simple links in regard to how
gt; pivot tables work and thier benefits it would be appreciated. Thanks for the
gt; help, Darlene
Pivot tables are really easy - easier than you think. They effectively allow
you to quot;drag and dropquot; 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.
quot;Peo Sjoblomquot; wrote:
gt; peltiertech.com/Excel/Pivots/pivotstart.htm
gt;
gt;
gt; www.contextures.com/tiptech.html
gt;
gt; Regards,
gt;
gt;
gt; Peo Sjoblom
gt;
gt; quot;Darlenequot; wrote:
gt;
gt; gt; I currently have an excel spreadsheet which contains a lot of data. I am
gt; gt; then manipulating this data to find root cause. I am graphing the data in
gt; gt; several differnt formats. The questions I have is would it make sense to
gt; gt; move this data into a pivot table and pivot charts to be able to control the
gt; gt; data managment better? Also if you can send me simple links in regard to how
gt; gt; pivot tables work and thier benefits it would be appreciated. Thanks for the
gt; gt; help, Darlene
- Apr 21 Sat 2007 20:36
Moving excel data into a pivot table
close
全站熱搜
留言列表
發表留言