Follow this tutorial to learn how to perform the basic tasks in PowerPivot for Excel.
PowerPivot for Excel Tutorial Introduction
Add Data to Your PowerPivot Workbook (Tutorial)
Save Your PowerPivot Workbook (Tutorial)
Create Relationships Between Tables (Tutorial)
Create a Calculated Column (Tutorial)
Create a Hierarchy in a Table (Tutorial)
Create a PivotTable from PowerPivot Data (Tutorial)
Create a PivotChart from PowerPivot Data (Tutorial)
Add Slicers to PivotTables (Tutorial)
Add Slicers to PivotCharts (Tutorial)
Create a Measure and KPI (Tutorial)
Create a Perspective (Tutorial)