February 27, 2020

3 Major Difference between Pivot Table and Power Pivot Table

3-Major-Difference-between-Pivot-Table-and-Power-Pivot-Table

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

    Jason Khoo

    >