Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

To activate Power Pivot, go to File > Options, click Add-ins, select COM Add-ins from the dropdown, and check the box for ...

To use this functionality, when creating a PivotTable, check the Add this data to the Data Model box in the Create PivotTable dialog box as pictured below. This Data Model approach enables you to ...