1. Convert to table and name the name, as following example named as “Products” Table
2. Excel options -> Add-ins ->Manage -> COM Add-ins-> Go -> turn on the powerpivot
3. Powerpivot -> Add to Data Model for all of the tables
4. Powerpivot -> Manage ->Diagram view -> connect the relationship
5. Powerpivot -> Manage ->Data view -> pivot table
The same process as simple pivot table