知唔知道 excel Pivot table 點用啊？

Basically Pivot table is a interactive tools in Excel that helps user to organize/analyze a whole bunch of data.

For example in university student record, you have all data like Name, Sex, Age, Faculty etc.,

By using Pivot table, you can quickly organize/analyze student records to get result like:

-How many boys and girls study in each Faculty
-Age group in each major

etc and etc

I am not sure what kind of task you need to do. But it's a convenient tool to handle a whole bunch of data.

If you want to know more details on how to use pivot table, please post more details here and I can help.

I hope that helps.

以下的連結是台灣 yahoo 一群excel高手在討論 pivot table, 他們的討論中, 你可以學到很多, 試試看！


http://tw.myblog.yahoo.com/lyuan-716/article?mid=145&prev=239&next=87&l=f&fid=8

I found the following web-sites for you. Good reference materials.

http://youlearnexcel.com/pivot.htm
http://www.barrelofcrafts.com/
http://www.cpearson.com/excel/pivots.htm