Part-03-How to Apply 2D Lookup (Matrix Lookup/2 Dimensional Lookup) By POWER QUERY | Excel Tutorial скачать в хорошем качестве

Part-03-How to Apply 2D Lookup (Matrix Lookup/2 Dimensional Lookup) By POWER QUERY | Excel Tutorial

Hello all excel lovers, Welcome to my channel @digital walkway. In this part 3 of 2D lookup related video we are going to learn how to apply 2D lookup by using power query. Power query is the most powerful tool of Excel and power query will help us to solve our problem for 2D lookup in a dynamic way. By using power query for applying 2D lookup we don't need to use any lookup formula of Excel. Along with power query to apply 2D lookup we are going to learn how to convert a crosstab file into a flat tab file. This is called unpivot of table or data. This is a comprehensive video related to 2D lookup by using power query and I request you to watch this video till the end to understand all the concepts related with this video and the learning explained in this video. Outcomes of this video as per below……. 1// How to apply 2D lookup by using power query. 2// Learn to understand what is unpivot of data or tables. There are part-01 and part-02 made related with 2D lookup and links for both parts are below. Part-01    • Part-01-How to Apply 2D Lookup (Matrix Loo...   Part-02    • Part-02-How to Apply 2D Lookup (Matrix Loo...   Below is the link of excel file used to make this part-03 https://1drv.ms/x/s!Ao9d5ES2qEkZglRMQ... So now enjoy excel learning through our @digital walkway channel. If you really like the content of our channel then please do like and share this video to others and don't forget to subscribe to our channel, this will give us motivation to make similar kinds of educational videos. Start watching this video and I will catch you there goodbye have a nice day. Your Search//--- power query,excel power query,power bi,power query excel,power query tutorial,power query in excel,what is power query,power query editor,power query for beginners,how to use power query,learn power query,power query in excel 2013,excel power query tutorial,introduction to power query,query,power query tips,what power query can do,power query functions,microsoft power query,pavan lalwani power query,power query advance excel Excel searchable keywords//--- power query,power bi,power query lookup,power query vlookup,power query xlookup,power query in excel,power query tutorial,vlookup,merge queries in power query,power query two way lookup,combine data with power query,power query for beginners,power bi for beginners,lookup,power bi tutorial,power query editor,power bi desktop,power query m code,learn power query,excel power query,power bi training,powerbi,vlookup in power query Excel learning keywords//--- excel,microsoft excel,vlookup in excel,3d lookup,3d vlookup,vlookup,excel xlookup,excel lookup tutorial,excel tips and tricks,ms excel,excel 3d formula,excel vlookup function,excel 3d formulas,lookup excel,excel lookup,lookup,excel tutorial,excel formulas,excel 2016,excel left lookup,excel 3d,3d lookup in excel,lookup formula in excel,lookup function in excel,xlookup,excel vlookup tricks,excel for analysts,excel 3d lookup formulas Excel/Word/PowerPoint//--- excel,word,power point,instalar power point,instalar word,microsoft word,microsoft excel,word excel powerpoint tricks,ms excel,word to powerpoint,office 2019 word excel powerpoint,word excel & powerpoint me kya antar h,excel for beginners,using powerpoint excel and word online,convert word to powerpoint,copy excel into word,how to insert excel into word,power point 2021,how to insert excel in word,link excel to word,baixar power point #Excel #2Dlookup #DigitaLWalkwaY