we can create pivot table in Visualforce Page using javascript for details http://gourangasadhukhan.blogspot.in/2014/11/how-to-create-pivot-table-in-forcecom.html
Download plugin for Excel 2010/2013 - http://www.microsoft.com/en-us/download/details.aspx?id=39379
Power Query allows for various data sources and then combining, transformations, filtering and other massaging the data so that once it is in Excel you can create simple Pivots and Charts
we can create pivot table in Visualforce Page using javascript
for details http://gourangasadhukhan.blogspot.in/2014/11/how-to-create-pivot-table-in-forcecom.html
Download plugin for Excel 2010/2013 - http://www.microsoft.com/en-us/download/details.aspx?id=39379
Power Query allows for various data sources and then combining, transformations, filtering and other massaging the data so that once it is in Excel you can create simple Pivots and Charts