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.

Click Add to Data Model in the Tables group. Doing so generates another view of your data. Your Excel data is safe–you can’t edit the data in the Power Pivot view.

Smart rename: Excel 2016 enables you to rename tables and columns in your workbook’s data model. With each edit or change, Excel 2016 now automatically updates any related tables and calculations ...

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

There's a reason why when you format your data into a table, Excel grays out the Merge And Center option—because it messes around too much with how tables and their filters work.