Let’s start with it is a great way to be able to visualize data and transform to information. It is intended to be a self-service business intelligence tool provided as an add-in for a tool we already know … Microsoft Excel ... 2010.
If you have been wondering where to go? what to do? and how do I?
I am including links that will help you be on your way to better understanding of the topic and tool. (Links to TechNet documentation)
Introduction to PowerPivot
Walkthrough: Create your first PowerPivot Workbook
Get to know the UI
PowerPivot for Excel Central
Get some samples