Hello Friends,
I have a sheet in excel with data, now I want to create a pivot table for this data in other sheet without using powerpivot. Just wondering how to do. Any help is appreciated.
Thanks.
Technology Tips and News
Hello Friends,
I have a sheet in excel with data, now I want to create a pivot table for this data in other sheet without using powerpivot. Just wondering how to do. Any help is appreciated.
Thanks.
I found the solution.
Hello,
We can directly select the Excel data and then click "PivotTable" button to creat the PivotTable report. For more detail information, please see the article below:
Quick start: Create a PivotTable report:
http://office.microsoft.com/en-in/excel-help/quick-start-create-a-pivottable-report-HA010359471.aspx
Regards,