In this step by step PowerPivot Tutorial I will show you how to use PowerPivot in Excel 2013 and by that I simply mean how to open PivotTable in Excel using the PowerPivot model you have. For the purpose of this tutorial I will use PowerPivot in Excel 2013.
Other Versions of Excel:
- PowePivot Excel 2013 (v3)
- This blog post has been written using PowerPivot in Excel 2013 Preview. I hope that another way to open PivotTable using PowerPivot model will be introduced in final version.
- PowerPivot Excel 2010 (v2) - SQL Server 2012
- The examples we use should work with v2 but there is another way to do that which is not avilable in Excel 2013 (yet)
- PowerPivot Excel 2010 (v1) - SQL Server 2008 R2
- The examples we use should work with v1 but there is another way to do that which is not avilable in Excel 2013 (yet)
Who is it for?
- People who would like to simply learn how to create PivotTable using PowerPivot Model.
Prior knowledge. You should have PowerPivot model created with relationships.
In our example we will use previous PowerPivot model.
Go to PowerPivot Model. In Home tab click PivotTable and select PivotTable
Insert Pivot dialog box appear and I select existing worksheet and click ok
and below we can see new Pivot table with new Excel 2013 PivotTable Fields interface. It looks better and has some new interesting functionality like active which is going to help a lot! however search has been removed which I particularly liked but as I am using Excel 2013 Preview I hope that only means that more robust search will be introduced in fianl version of Excel 2013.
Below I selected Country Field check box and GooglePosition and changed it to Average.
This tutorial focuses on PowerPivot model itself so this is where I will not show details on using Pivot Table but later on we will briefly use certain functionality when we will be evaluating usefulness of the PowerPivot model.