Office 2016 33

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

DESCRIPTION

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.

NOTES

WORKBOOKS

Download “Office 2016 33” Office-2016-33.zip – Downloaded 4 times – 13 MB







Be the first to comment

Leave a Reply