You have data, and lots of it. When you want to analyze all that data, learn how to use the Power Pivot add-in with Excel to import data sets, identify relationships, build pivot tables, and create pivot charts.
How to Use Power Pivot in Excel | Full Tutorial
Power Pivot gives you the power of business insights and analytics apps. You don’t need specialized training to build data models and perform calculations. You just need to enable it before you can use it.
Select File > Options.
Select the Manage drop-down menu, and then select COM Add-ins.