This Excel tutorial explains how to create Relationship and create Pivot Table using PowerPivot. You may also want to read: Create Relationship in Microsoft Access PowerPivot in Excel In Excel version 2016, PowerPivot is pre-installed and you can see the option in the ribbon tab. For previous versions of Excel, some versions cannot support PowerPivot. If you are not using Excel 2016, I recommend you to google search how you can install PowerPivot in your version, you may need to...