Relationship include in the tool bar
In Excel 2013, a new feature have been added to the Data menu, it is the Relationships button.
You must create at least 2 tables in your workbook in order to use this feature.
Tables have made their appearances since Excel 2007. But honestly, as they made through the use of automated formats, they were hardly used.
Excel 2013 will allow you to link multiple tables between. For more than shaping convenience, tables also automatically generated names for the table but names all columns.
Tables have the advantage of making your dynamic data ranges. Simply enter in the document data using the formula below to calculate the sum of the Total column. Use your SUM formula if you need to add information to your table “Customer”: it will automatically adjust to new lines.
Converting one table in many tables
Often, Excel workbooks looks like this, a long list of data with the same information (in this example, City and State are repeated)
A customer lives in one city, and a city belongs to a single state. So rather than repeat for each client, the names of his city and state, we will create two other tables with only cities and states name as follows:
Besides the fact that your workbook will be smaller, and thus faster to open, split your main table in 3 tables will greatly decrease data entry errors :)