Power Pivot is a free add-in to the 2010 version and can be downloaded from below link. It comes with Office 2013 Pro & Office 365.
Download Link: https://support.office.com/en-nz/article/Power-Pivot-Add-in-a9c2c6e2-cc49-4976-a7d7-40896795d045
Power Pivot extends capabilities of the pivot data summarization and we can import data from multiple data sources.
The following free Microsoft Virtual Academy course can be very helpful in learning Power Query & Power Pivot along more info.
In this post, I will share a basic use of Power Pivot with example in Excel 2010.
Once we have downloaded the add-in, we would be able to see it in our workbook in top ribbon.
With Power Pivot, we can link our multiple tables through the common Key/Column between them. It’s just like the relational database. Once we have linked them, then they could be summarized at one place. We will see it in this post step by step.
We have the below 3 tables of data in the 3 separate sheets.
Customer Table

Product Table

Sales Table

Have your data in table form, for this select your data and press CtrlL. Name your table, just for clarity. For this have your cursor somewhere in table and go to design tab and change the default table name there.
After that click on the PowerPivot which would be at the top bar. Your cursor be in somewhere the table i.e Customer Table and then click on Create Linked Table. This will move the table in Power Pivot window. Do this for all the tables and move the 3 tables. Now Go to Design Tab in Power Pivot window and then click on Create Relationship, a new window will open.
Relate the Product and Sales table on ProductKey Column and Customer and Sales Table on KeyCustomer Column, one by one. This way all the three tables are linked now.
For any change in relationship click on Manage Relationship
To view the Diagram View of relationships, go to Table Tools tab and then click on Diagram View. Once the relationship is finalized, go to workbook, PowerPivot then PivotTable and Create Pivot table as we do, but here we can have data from all the 3 tables in our Pivot table.
[null, null, null, null, {"document_url": "http://amiqexcel.blogspot.com/2015/01/power-pivot-table-excel-2010.html", "unformatted_src": "http://1.bp.blogspot.com/--y_vt11IXZI/VKvF9fAv0NI/AAAAAAAAALY/wyLMgBv0Sjc/s1600/PowerPivot1.jpg", "src": "http://1.bp.blogspot.com/--y_vt11IXZI/VKvF9fAv0NI/AAAAAAAAALY/wyLMgBv0Sjc/s1600/PowerPivot1.jpg", "formatted_filename": "PowerPivot", "rendered_width": 640, "rendered_height": 216}, null, {"document_url": "http://amiqexcel.blogspot.com/2015/01/power-pivot-table-excel-2010.html", "unformatted_src": "http://2.bp.blogspot.com/-fSQuE2cfdl0/VKvGY82R7QI/AAAAAAAAALg/kQABnmbUPng/s1600/Powerrelation.jpg", "src": "http://2.bp.blogspot.com/-fSQuE2cfdl0/VKvGY82R7QI/AAAAAAAAALg/kQABnmbUPng/s1600/Powerrelation.jpg", "formatted_filename": "Powerrelation", "rendered_width": 640, "rendered_height": 336}, null, {"document_url": "http://amiqexcel.blogspot.com/2015/01/power-pivot-table-excel-2010.html", "unformatted_src": "http://1.bp.blogspot.com/-WcgXAMmySLU/VKvGrACphpI/AAAAAAAAALo/jfEmeZhvbkI/s1600/powerdiagramview.jpg", "src": "http://1.bp.blogspot.com/-WcgXAMmySLU/VKvGrACphpI/AAAAAAAAALo/jfEmeZhvbkI/s1600/powerdiagramview.jpg", "formatted_filename": "powerdiagramview", "rendered_width": 640, "rendered_height": 344}, null, {"document_url": "http://amiqexcel.blogspot.com/2015/01/power-pivot-table-excel-2010.html", "unformatted_src": "http://1.bp.blogspot.com/-dfq276yTDPY/VKvHYSiVWEI/AAAAAAAAALw/8tnQ4TtnXYc/s1600/powerpivottable.jpg", "src": "http://1.bp.blogspot.com/-dfq276yTDPY/VKvHYSiVWEI/AAAAAAAAALw/8tnQ4TtnXYc/s1600/powerpivottable.jpg", "formatted_filename": "powerpivottable", "rendered_width": 640, "rendered_height": 306}, null, null, null, {"document_url": "http://amiqexcel.blogspot.com/2015/01/power-pivot-table-excel-2010.html", "unformatted_src": "//lh5.googleusercontent.com/-jNXtj1c7kvQ/AAAAAAAAAAI/AAAAAAAAAJw/pyn0JWmcHSc/s80-c/photo.jpg", "src": "http://lh5.googleusercontent.com/-jNXtj1c7kvQ/AAAAAAAAAAI/AAAAAAAAAJw/pyn0JWmcHSc/s80-c/photo.jpg", "formatted_filename": "photo", "alt_text": "My photo", "rendered_width": 80, "rendered_height": 80}, null]