Enable the Data Analysis add-ins
In order to use Power Pivot, the respective add-in must be activated which can be done with the following message box which pops up if the add-in hasn't been activated: 
After activating the add-in, Excel's Ribbon is extended with Power Pivot tab.