Enhanced Data Management: Easily import and manage large datasets from multiple sources. Advanced Calculations: ... How to Data Model in Excel Spreadsheets. Enable PowerPivot Add-In.

After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.