Why you NEED to start using Data Relationships
Access our COMPLETE Excel Course HERE
In this video we look at the importance of using Data Relationships when working with multiple data sets in Excel.
This video is suitable for all levels and is a great introduction to working with Excel relationships.
The main purpose of the video is to show a better solution for working with multiple datasets rather than having to use formulas or manual intervention to consolidate to a single data set which is of importance when utilising Pivot Tables as we do in this tutorial.
Download tutorial workbook HERE