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.

A treemap chart provides a hierarchical view of data and makes it easy to spot patterns. Learn how to create a treemap chart in Excel.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Learn how to quickly and easily build impressive Excel dashboards for your next presentation or data analysis spreadsheet. Color is an import ...

Suppose you want to create a chart that reports the relationships within your company or organization. In that case, you can use the SmartArt graphic feature in Microsoft Excel to build an ...