Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

Excel: Pivot tables

Hi,

This is related to Microsoft Excel. Somebody would tell me What is the Pivot Tables and how to use it“ please (some examples or tutorial will be great).

Thank you


tjie
0
tjie
Asked:
tjie
  • 2
2 Solutions
 
NBVCCommented:
Just google "pivot table tutorial"  and you will get many options, including even YouTube videos, and samples...
0
 
tjieAuthor Commented:
If you ever used it, would you explain a little bit of this "pivot table" (with your own wording) please .....Many times, "our language" is easy to understand ..

thanks
0
 
Patrick MatthewsCommented:
People typically use PTs to condense a data set into aggregate data for specified dimensions.

For example, you might have a data set with thousands of rows, and each row indicates the total sales for a particular product, store, and date.

With a PivotTable you can quickly and easily analyze the data to do things like find total sales by product, by store, by date, or by combinations of the above.
0
 
Patrick MatthewsCommented:
Glad to help :)

For a little PivotTable-related levity: http://www.youtube.com/watch?v=GwbSJFtRmDw
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now