Advanced Pivot Table Relationship -Part-1 | Combining Data from Multiple Sheets in Excel

Pivot Table Relationship - Combine Data from Multiple Sheets in Excel
Learn how to combine multiple worksheet into one and establish relationship between them without using thousands of vlookup.

Download the Assignment Master Practice Folder here (All Playlist Example at one place)

===========VIDEO COURSE============================
✅ Mastering Excel Video Course
✅ Mastering Power BI Video Course
✅ Mastering VBA Video Course
✅ Mastering SQL Video Course
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
====================================================
Videos in a Sequence -Basic to Advanced EXCEL

Value add-ons Playlist

Let's Connect:

#pivottable #pivottablemultisheet#Innozant #advancedpivot#excelpivottricks

[hiteshchourey]

Sirji, amazing new video best knowledge given by you.

[tejpalsain]

यह तो मेरे लिए बिल्कुल नया हैं।
आगे आने वाले वीडियो का इंतजार रहेगा।
में इसको सीखने के लिए उत्सुक हूँ।
Thanks

[abduljabbarumrani]

Ap ny meri zindagi asaan kerdi brother thank you so much 🙏🙏

[surajsinghrajput]

Ishi series ke wait tha sir 🙏 Thanks for bringing do continue this pivot and power query series

[horrorlovestories]

This topic is very interesting and turning point that i practiced today. 😀 felt awesome

[abhishekshirsekar]

Interesting hai and new hai thank a lot ..in a day m eagarly waiting for ur video 🙏🙏

[sameenarafiq]

Great lecture... Thank you so much again for uploading...

[satishojha]

Very informative video sir thanku sir good night💤💤

[KuldeepSingh-nqvi]

Best Videos Ever, I want to learn SQL how to learn. Pls suggest.

[sushantmore]

According to the data, I think all the relationships are one to one irrespective of the table. Because orderid is unique for every order so all the tables like payment, customer, order will be one to one. If we had a customerid in customers table and the payment table had the customerid who did that payment then for eg we could easily get the number of payments by each customer and here the relationship would be one to many because a customerid in customer table would be unique and that same customer must have done multiple payments so one to many

[Healthy-Wealthy]

Sir your videos very helpful i continue watching your video but i stuck....i am unable to create relationship this option is showing but unable to use 😢 kindly help

[Healthy-Wealthy]

Relationship option dikh rha h but active ni h ribon m add krne ka bhi try kiya but ni ho rha h

[tapu]

Hi sir I need your help
How can we establish relationships with duplicate values.

[ashrafeditor]

hi sir your video very usefull for for learner but one problem this exmaple
custmer inf se name ko select karne se output wrong a rha hai name ka, plz give the solution this problem and why worng plz explain