close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()