How to use Excel DATA MODEL explained in Tamil

This video explains the best method of using Excel DATA MODEL in Tamil. The important difference of using DATA MODEL over the native VLOOKUP function is explained in simple manner in this tutorial. Make sure to download and use the practice file from the following path for better understanding : https://prabastech.com/downloadable-excel-supporting-files-archived-2/ #HowTo #DataModel #VLookUp #PowerQuery #PowerBI #PowerPivot #PowerApps Join us to show your love and support: https://www.youtube.com/channel/UCE37kYsUhsxDB0-IlB6zwMQ/join https://youtu.be/wW-AylK48M8 Topics Covered in this video: 0:00 Introduction of VLOOKUP vs DATA MODEL 0:47 What is Power Query vs. Power Pivot vs. Data Model 1:51 Phase 1 - Traditionally join data using the legacy VLOOKUP Function 5:16 Phase 2 - Benefits of using Data Model over the native VLOOKUP Function 7:37 Phase 3 - Join data using the new Data Model Concept 10:59 Creating Relationship between table using Manage Data Module 14:42 Final Experiment using Native VLOOKUP 14:42 Final Experiment using the new DATA MODEL All Videos of Prabas Microsoft Office in Tamil – தமிழ்: https://www.youtube.com/watch?v=w1QvylCR9TI&list=PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH #ExcelTamil #PrabasMSOffice #PrabasTech #PowerQueryTamil #FreeDownloads #Office365