Question: what is the difference between pivot table and powerpivot?
Answer: Power Pivot has more calculations (or measures) which means it can do lots of complex formulas versus a Pivot Table. ... Also Power Pivot can summarize data using multiple data sources, whereas a Pivot Table only uses one source. So Power Pivot is a Pivot Table on STEROIDS!