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.

Microsoft is bringing its AI directly into Excel formulas with the Copilot function. It is designed to automatically analyze, ...

With Excel's Copilot, tasks like classifying feedback or creating summaries can be done quickly by simply typing a prompt into a cell. The tool enables automation ...