Powerpivot vs Pivot Table


February 25th, 2014 by admin admin

PowerPivot and Pivot Table are the same and also different. The way they are managed is the same but the data sources are different. PowerPivot has it’s own working area to manage the data source while Pivot Table usually use data stored in an Excel worksheet.

To create a “Pivot Table” using the PowerPivot function, you have to use the Pivot Table icon in the POWERPIVOT ribbon.

To create a normal Pivot Table in Excel, you have to use the Pivot Table icon in the INSERT ribbon.

Leave a Reply

You must be logged in to post a comment.

s2Member®