Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB21-PivotTablesRelationshipsStart.xlsm
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB21-PivotTablesRelationshipsFinished.xlsm
Download Excel VLOOKUP File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB21-PivotTablesVLOOKUPFinished.xlsm
Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class33-ExcelBasics21PivotTablesRelationships.pdf
Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm

In this video learn about how to use Excel Tables, One-To-Many Relationships and the Data Model as a substitute for a VLOOKUP Function Helper Column for a Large Data Set. Discuss pros and cons. Introduction to One-To-Many Relationships in the Excel Data Model.