Google Spreadsheet - Pivot Table

I was excited when Google released the data validation lookup (See previous post) from a range of cells feature in Google Spreadsheet August last year. My excitement shoot to roof top when Google announce the pivot table feature in Google Spreadsheet today. Finally!

For those who has been using pivot table in Microsoft Excel should familiar with the benefits of pivot table instant real time and simple setup for large data summary with multiple dimension and filtering, analysis and graph. For those who isn't familiar with pivot table, watch the how pivot tables works in Google Spreadsheet in the video below.

Please note that the pivot table from Microsoft Excel can not be uploaded to Google Spreadsheet at this time.