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.

Learn about how to create a table in Excel so you can start presenting your data to others in a more professional manner.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

The display is separate from the source data and doesn’t change the source data in any way. In Excel, PivotTable refers to the tool that helps you create a pivot table.

Learn how to use Excel pivot tables and charts to organize, summarize, and display your survey data in different ways. Follow these easy steps and tips.

How To Automate a Table in Word Using Excel. As the world's leading business productivity suite, Microsoft Office provides many useful features including the ability to automatically display data ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Using Excel 2013's Frequency function as an array quickly compiles the frequency data from a list of "bin" ranges. You can then display this data on a bar chart to more readily compare the ...