Use the Excel Data Model to avoid using VLOOKUPs when analyzing data

Описание

Data extracts from corporate databases often have code numbers for products, territories and the like. Data analysts use VLOOKUP to translate these codes into meaningful names. Excel's Data Model offers a much better and more robust approach. The workbook containing the starting data set for you to follow along with the video, can be downloaded from:
https://www.excelcraft.com/avoiding-vlookups-with-pivottables