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

Опубликовано: 28 Июль 2026
на канале: excelisfun

164,203

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel Finished File: https://people.highline.edu/mgirvin/Y...
Download Excel VLOOKUP File: https://people.highline.edu/mgirvin/Y...
Download Full Written Notes: https://people.highline.edu/mgirvin/Y...
Class web page link: https://people.highline.edu/mgirvin/A...

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.