Question: what is the difference between pivot and powerpivot?
Answer: The basic difference between Power Pivot and Excel is that you can create a more sophisticated data model by working on it in the Power Pivot window. Let's compare some tasks. Import data from different sources, such as large corporate databases, public data feeds, spreadsheets, and text files on your computer.