Good day to you all. Today i am going to share with you how to make a pivot table using microsoft excel. If you do not know what is Pivot Table, this is a easy way of presenting multiple information in a table. For example, this is our raw data. We want to have a pivot table of count of persons according to each nationality.
Go to Data - Pivot Table and Pivot Chart Report.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5w1Z-W5EBfD5T86cRgq-DsTk6UcaJ7x7RGB5AA5QLQMcMz78Na8t_9XeiCJGdUcvaGRP1QyWSDKbiwBi4kFN_HH4ZkYo1BGqPtsqwc0rx8yRm5c7o9-Wm17oORcrxL5RTXzfyFQLtJPQ/s400/1.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW9YKreui20KEn6LFwNwR4u9FD3echbpMFnKQ27T0AfAAvWD-qOSCelbXoL-cCx_L1yaOwhX15hTVuVYEdf6BrJbghwxZFF03s2Yph24K96Ozk4jb4GoM7yogZNdd2znOdszzPE-7PJSQ/s400/2.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkyc9GHngtvsL4TqrOfh-JCjOs-c__Cl0-fcTBXe1DjekOMIptjjeWxUlTGLJ3FH_-1WPlkhAkJUDvhBDj7umJys6Y_soV6J5C9gjS8wkO7bz4HVVsvRU9yAGcVNaKWxxnlDNoDKlhh7g/s400/3.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUIIU2hazlL1G1CwFtD4w6wPZx75Q5xUjOw6TD-HEgrU6m-IH_Ayajh1PjUNsY9wx0VEEUayL0ANNdGCITN3h2_NsM3HLXLxvvExhnyZiPx9xh1Zovr8U_0zYueqjAVrLMTkCeVrFoljQ/s400/4.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6sy2cT8_Gk4sjX4MYrvTgzyPRt1or9julzSMuCVgPyIoqrSfW1m5yDMAIBOJRbIgckBDrhSEsgEODa-VSveFn-eBmkrd957iUkF_DU-wXreZYczIy78BCQ3f10KCPlLVaRHJd0ZhLh4E/s400/5.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUAp36XNmhDOg2I7ZvAeRk3jtSJ8kUW2C4fwA-8GjzD92yHrN5jqvUBQrTwoN6xJ5wUSp1gFCbCLiHrP6RDBm-M1T1rgSIPms3XjhzG9vcm78qX-4DhOaKsdGFvM17kVQji3pHdQo0ywQ/s400/6.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0QQbnBdUGFMxBUdAxYN2EI-xsBjmPOKyKpN6WRSfZt7nFsB4RBwn2G7QeoCiJSfNQyjW0czslZOHnx7Ug2E5hCadL5wtWv0tTmpJlvF2z3ymN8GvN5mdWF8bedIWY5tF28C-Grvv5QdE/s400/7.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1huxzwDLWQ4Wvc1lMjA8LKsv1ccxwq7LnmMw14PGudNYwo8ZZZJFDVB33xSjDQFRACfdw54CfIfTvMsr-xOIN7WqMypaEfmnz8Bo3157wozS86q9RCsTr3EPMkXCjwJ12kj_F9SXFL0k/s400/8.jpg)
This is an example of Pivot Table which I have generated with Microsoft Excel's Pivot table. And it is just few clicks involved. Every people should know this
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeSUFwWq0QlqQpYrDJ-rwS0Yzn181otKZURcU5XFvbXVmAqhsTa2lL2HgDkB4ugaI-ISweBXe93eJfHbLw2ogmMVXvARkGe54Z3vlYlE10KKY5VzjUvpmrNzeIftWGh_OpS_eHlZzx1zk/s400/9.jpg)
cool.. very useful to get information =)
ReplyDeletekenwooi.com