Advanced Pivot Table Relationship -Part-2 | 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

[tejpalsain]

Very nice sir.
आपने जिस मनोरंजन ढंग से इस टफ टॉपिक समझाया हैं अब धीरे धीरे समझ में आ रहा है।
थोडी सी प्रेक्टिस रोज करनी पड़ेगी।
Thanks.

[PrateekRemoteSales-tpzx]

Amazing tutorial on Relationship concept in Pivot table. Really best tutorial related to excel on internet

[amansinha]

sir..phle to hmko pata bi nahi tha ki pivot table me bi relation lagta hai...great sir..thanks sir...

[jctevmv]

most difficult topic ko v kitta asaan bna dete ho ap sir.... hats off

[dsraghav]

Thank you so much I recommended you channel for my two colleagues

[pravinkumbhare]

Thanks for sharing such valuable Excel training Sir... Ideas for creating Relationship has been cleared.. Once again Thank You very much Sir..

[ishutiwari]

thank you sir g,
you have cleared each and every important features related to pivot tebles🥳
im eagerly waiting for the power pivot series🙏😊

[sanjaysingh-wfos]

Grt explor and very useful in office work thanks for explor

[Anil-Digital-Marketing]

Hello sir, I am watching your video last one year. Your video most knowledgeable for me. Please tell me can we manage relationship in WPS and 365 office.

[hemantsharma]

आपका example बहुत अच्छा है दोनों साडू भाई लुटे तोह एक ही घर पर हैं 😇😇😇😇

[dirghangiamit]

We don't know when we become expert in Excel with Your Style of teaching. love to see you and learnt from you. We are addicted with you and your video.Thank you so much from core of heart.

[pramodbhavsar]

Great idea for multi table creat pivot table with relationship thank you sir

[BhupendraSingh-ofqu]

Hi Sir, I am creating the DPR for our ongoing project. Wherein i have to calculate the current usage of material in specified area, and need to find out the future requirement on the basis of area(where work is done). And one querry- i am using pivot table for the same, and there is some area mentioned against the material used which is predefined. and i am not able to have it on Pivot as it is no formula on it. but unable to do it, its taking values by sum, avg, product. But i want it on actual basis. Can we?

[sachinkumarsachin]

Hi,
Can I make use Relationship in 2016 Version

[chandrabhanmishra]

Sir, Relationship karne ke bad Customer wise or Product Wise Data Seprate Sheet me karna hai to jab ham pivot table me Customer or Product ko pivot table filter me rakhte hai to analyze tab me Option tab me Show Report filter page kam nahi karta to ham product wiste saprate kase karege

[amritathakur]

Thanks 👍🙏 sir great effort ☺️👍 right ....In real life we follow these types of relation to same position same same then we create relation one person to another person and so intresting pivot also follow this 😅

[heeralalkumawat]

Sir me debt recovery tribunal me select hua hu.
Sir mujhe debt recovery tribunal ke baare me bta skte ho kya.
Sir me data entry operator ki post par select hua hu.

[syedabdulmoeez]

sir, ager jan se deceber tak data hu aur jan se deceber tak mein eik hi id same hu tu phir.

[kalpitasawant]

Mere table mein common columns ke unique values nahi hai. To connection kaise create kar sakate hai?

Mere data mein class ID common hai but ek table mein woh unique hai par attendance report mein woh multiple time ata hai toh woh duplicate hota hai.

[rahulagrawal]

How to do grouping in the data model pivot table