fbpx

February 27

3 Major Difference between Pivot Table and Power Pivot Table

0  comments

1a. Pivot Table can only accept a single source of data. 

1b. Power Pivot Table can accept multiple sources of data.

more-than-one-source-of-data-bet-pt-ppt

2a. Pivot Table can only do simple summary such as Sum, Count, Max, Min

2b Power Pivot Table can do complex calculations

performs calculations

3a. Pivot table can only accept data from the entire source (worksheet)

3b Power Pivot Table let you pick choose the columns from source to be included in the report

pick and choose columns  from source for Power Pivot

Tags


You may also like

Are you aware of these 2 developments?

This sounds like a lame question but it’s not

Leave a Reply
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!