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.

Here are some quick facts though: Any given workbook will only have one Data Model. Any table in Excel can be added to the Data Model. Almost all Data Sources can be added to the Data Model (SQL, ...