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.

How to Data Model in Excel Spreadsheets. Enable PowerPivot Add-In. Open Excel and go to the File tab. Select Options from the menu. In the Excel Options dialog box, click on Add-Ins.

Whether you've recently taken a Microsoft Excel course or you want to check that you're up-to-date with the program's latest capabilities, take the How-To Geek Advanced Excel Test and see how you fare ...