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 ...

Even though it’s an official add-on from Excel, Power Pivot isn’t limited to spreadsheet data only. You can import data from any CSV or plain text files, and even connect it to databases like ...