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