Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: http://ift.tt/2AjgGx4
Download Excel Finished File: http://ift.tt/2z4t13R
Download Excel VLOOKUP File: http://ift.tt/2AgX1hs
Download Full Written Notes: http://ift.tt/2AUlNkh
Class web page link: http://ift.tt/2kPyedk

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.

View on YouTube