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.
Thanks Amaninder for such a vat feedback.. We welcome you to experience the taste of success with Innozant-Seed of success.. Happy Learning dear 👍❤️❤️🙏🙏 Must Watch today's Interview Cracker Hatke Episode(Learning with Fun)🙂🙏
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.
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?
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 😅
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
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.
Sir, when ever I am going to built relationships its showing " we couldn't load the data model. This may be because the data model in this workbook is damaged.". Please help me sir
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.
After basic excel Playlist...Start watching playlist ..Sort & Filter then what if Analysis Aap latest upload kiye gye Kisi video ke description me Jaise ..Video in sequence likha hua hai playlist usi sequence me learn kijiye
Sir assignment master mein pivot table relationship part 2 hai pivot table folder mein. Part 1 nahi mila mughko practice karna hai sir main part1 kahaan dhundoo?
👌🏻 😊 Sir ek question hai plz help My Cell is formatted, if I type less than zero it shows $5.00DR and if Is more than equal to zero it show $0.00 CR (CR Credit balance or DR debit Balance) or Ek cell main kuch text hai. Ab sir jab main text or amount ko concatenate karta hu to decimal k baad .00 .01 ya .10 nahi aa rha or naa hi CR/DR par. 1.11, 2.55 le leta hai but Cr/dr tab bhi nahi aa raha ye problem kese fix hogi It should be like "Total amount $10.00 CR" 🙏
@@Innozantsir taxt se aa to gaya par value jo minus hai vo abhi bhi $-50.00 DR dikh rha hai it should be $50.00 Dr. ="total amount $"&if(c2>=0,taxt(c2,"0.00"),text(c2, "#, ##. 00))
I am very worried because Right Now I am in BSC 2nd year( IGNOU open University). Since it's a open University Mostly MNC company does not hire Graduates from Open University. I have read about it on Google, Quora. And l found this as a fact. So I am worried as l am thinking to do Mis executive course in future ( right now learning Advanced Excel from your channel). But I will not have opportunities to work in big companies. What should I do now?? What you say about this, l will really not have opportunities to work in big companies just because I am graduate from open University ??? Please tell me truth even if it is harsh . 🙏🙏🙏
Who said you that if the person from correspondence background are not working in MNC.Mohit Ji chalo aapki hi baat man Lete h ki MNC nhi krti h hire correspondence background student ko( dear wo criteria FRESHER ke liye HOTA hai na ki experienced candidates ke liye) kya jarurri hai ki main job ki shuruwat sidhenbirlsoft ya Google se Kru ye bhi to ho sakta hai ki start ke chote se company se Karu ek ya 2 saal Ka experience ho Jane ke baad badi company me apply Karu phir wo rakhega ya tab bhi apke 10th ke marks puchega..dear bht saare simple graduate Hain mere students Jo bht ache position par Hain aaj big companies or Saath..ye befaltu ke discussion Google aur quora se padhna band kijiye aur focus kijiye apni Learning par..best of luck👍❤️❤️❤️
Sir apki sabi video MAi se sirf yahi relationship wala vedio bilkul samj ni aarahi hai.... Ab dekho Mere pas 4 table ex.. Name jan feb A 8 87 B 88 86 C 85 84 Name mar apr A 66 78 B 87 86 C 55 56 Name may june A 86 86 B 83 46 C 86 64 Name jul aug A 76 67 B 44 86 C 46 86 Aur jab mai relation leta hai jaise Maine kara Table 1...........name Table2............ Name Fir maine kiya Table1....... Name Table3........ Name Fir Table1........name Table4........ Name Aur mai output aysa chata hu Name jan feb mar ap may jun A 77 777 B ;;;; son on....... C Matlb sabhi month combine ho jaye oibit mai Lakin jab may drag karta hu... To fir ye error aa jata hai.... Relationship between tables may be needed? Pls help karo...!. Ye video ya concept pls samjha do.... Ya kisi bhi video mai mere ye wala question pls karao.. Ap pls sir
@@Innozant sir mai kam se km 50 bar kar chuka. Hu.. Pta. Ni... Kya issue aa raha hai... Kuch samj ni aa raha hai...ap pls yahi question ek video mai daldo pls
Very nice sir.
आपने जिस मनोरंजन ढंग से इस टफ टॉपिक समझाया हैं अब धीरे धीरे समझ में आ रहा है।
थोडी सी प्रेक्टिस रोज करनी पड़ेगी।
Thanks.
Thanks Tejpal Ji..tc
gn
sir..phle to hmko pata bi nahi tha ki pivot table me bi relation lagta hai...great sir..thanks sir...
Haha..abhi to aage bht saare awesome topic dikhega aapko pivot me❤️🙏👍
Amazing tutorial on Relationship concept in Pivot table. Really best tutorial related to excel on internet
Thanks dear
sir, you are beyond word--------------------------
Thanks Majeed ..love you dear
most difficult topic ko v kitta asaan bna dete ho ap sir.... hats off
Thanks Aftab .. love you all❤️👍
@@Innozant anand sir.... plzzz.... not aftaab.... 😊 😊
@@user-jc6te1vm8v Main to abtak aftab hi samhta aaya hu
Thank you so much I recommended you channel for my two colleagues
Thanks Raghav Ji.Krrp Learning ❤️👍
Thanks for sharing such valuable Excel training Sir... Ideas for creating Relationship has been cleared.. Once again Thank You very much Sir..
You're most welcome
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.
Love you Amit for such a lovely appreciation 🙏🙏👍❤️❤️Keep learning.
आपका example बहुत अच्छा है दोनों साडू भाई लुटे तोह एक ही घर पर हैं 😇😇😇😇
Hahahaha.Yes Hemant Ji.Thanks
Grt explor and very useful in office work thanks for explor
Thanks Sanjay
Examples to explain are perfect 👍
Thanks Amaninder for such a vat feedback.. We welcome you to experience the taste of success with Innozant-Seed of success.. Happy Learning dear 👍❤️❤️🙏🙏
Must Watch today's Interview Cracker Hatke Episode(Learning with Fun)🙂🙏
thank you sir g,
you have cleared each and every important features related to pivot tebles🥳
im eagerly waiting for the power pivot series🙏😊
Thanks Ishu..Abhi Pivot Table Ka 2 bht hi important video aayega isi week then Power Pivot serries starts 👍❤️🙏
great concept of relation Sir ji.😂🤣😍
Thanks Pavan Ji.❤️🙏HV a nice day
Great Learning.....
Thank You, Sir.
Excellent Sir Amazing thanks alot Sir
Thanks dear
Amazing.. video on relationship 🙏🙏
Thanks dear👍♥️
Thank you so much sir, you are great
Great idea for multi table creat pivot table with relationship thank you sir
Thanks Pramod Ji..🙏👍❤️
Brilliant Sir
Thanks dear
Woow concept🙏
Thanks Abhishek Ji🙏❤️👍
Thank you for this information 🙂
Thanks dear🙏❤️
you are amazing sir
Thanks dear
Thank You Sir
very useful sir
Thanks ❤️🙏
Great sir
Thanks dear
Nice one
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.
🙏nice video sir 🙏
Thanks Manish Ji🙏❤️
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?
Hi,
Can I make use Relationship in 2016 Version
👍👍👍
👍❤️🙏
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 😅
Hahahaha 😊 Thanks..Learn in sequence each and every playlist.M sure you feel much confident after some time and able to crack any interview.
How to do grouping in the data model pivot table
Great
Thanks Rajdeep Ji
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
Thnq sir
Thanks dear👍❤️🙏
Nice sir 🙏🙏
Thanks Suraj👍❤️🙏
Add THIS Data to the Data model option nahi aa Raha hai excel 2007 me
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.
Sir, when ever I am going to built relationships its showing " we couldn't load the data model. This may be because the data model in this workbook is damaged.".
Please help me sir
Which version of Excel you are using now..?try to upload simple table in your data model and check.
❤
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.
sir, ager jan se deceber tak data hu aur jan se deceber tak mein eik hi id same hu tu phir.
SIR 1 PROBLEM HAI MERE EXCEL ME RELATIONSHIPS KA OPTIONS NAHI AARHA HAI
Sir apka basic excel course khatam kar diya hai ab agey kis hisab se video search karu
After basic excel Playlist...Start watching playlist ..Sort & Filter then what if Analysis
Aap latest upload kiye gye Kisi video ke description me Jaise ..Video in sequence likha hua hai playlist usi sequence me learn kijiye
Thank you sir
Sir direct workbook link nahi open ho raha plz help
Assignment master main link diya hua use download kar lein..it's working fine
Sir assignment master mein pivot table relationship part 2 hai pivot table folder mein. Part 1 nahi mila mughko practice karna hai sir main part1 kahaan dhundoo?
Base Table is Sales table
Beauty
Thanks dear Rajdeep
🙏🙏🙏🙏❤️
👌🏻 😊
Sir ek question hai plz help
My Cell is formatted, if I type less than zero it shows $5.00DR and if Is more than equal to zero it show $0.00 CR
(CR Credit balance or DR debit Balance) or Ek cell main kuch text hai.
Ab sir jab main text or amount ko concatenate karta hu to decimal k baad .00 .01 ya .10 nahi aa rha or naa hi CR/DR par. 1.11, 2.55 le leta hai but Cr/dr tab bhi nahi aa raha ye problem kese fix hogi
It should be like "Total amount $10.00 CR"
🙏
Text Function pass krke aapko his format me chaiye data concatenate kriye ..kyu issue aa Ra h👍
@@Innozantsir taxt se aa to gaya par value jo minus hai vo abhi bhi $-50.00 DR dikh rha hai it should be $50.00 Dr.
="total amount $"&if(c2>=0,taxt(c2,"0.00"),text(c2, "#, ##. 00))
Sadhu bhae
😊😊😊
I am very worried because Right Now
I am in BSC 2nd year( IGNOU open University). Since it's a open University Mostly MNC company does not hire Graduates from Open University. I have read about it on Google, Quora. And l found this as a fact. So I am worried as l am thinking to do Mis executive course in future ( right now learning Advanced Excel from your channel). But I will not have opportunities to work in big companies.
What should I do now??
What you say about this, l will really not have opportunities to work in big companies just because I am graduate from open University ???
Please tell me truth even if it is harsh . 🙏🙏🙏
Who said you that if the person from correspondence background are not working in MNC.Mohit Ji chalo aapki hi baat man Lete h ki MNC nhi krti h hire correspondence background student ko( dear wo criteria FRESHER ke liye HOTA hai na ki experienced candidates ke liye) kya jarurri hai ki main job ki shuruwat sidhenbirlsoft ya Google se Kru ye bhi to ho sakta hai ki start ke chote se company se Karu ek ya 2 saal Ka experience ho Jane ke baad badi company me apply Karu phir wo rakhega ya tab bhi apke 10th ke marks puchega..dear bht saare simple graduate Hain mere students Jo bht ache position par Hain aaj big companies or Saath..ye befaltu ke discussion Google aur quora se padhna band kijiye aur focus kijiye apni Learning par..best of luck👍❤️❤️❤️
@@Innozant Thanks a lot sir. I was very worried . Thanks to genuine answer.
Sales table then customer, product
🙏🙏🙏🙏
Thanks Ashish Ji
Sir mera relationship ka option hi band hai kab chalu hota hai ye ☹️1 Ghante se dimag kharab hai
Sadhu bhai🤣🤣
Hahahaha 😀❤️
Duplicate values hone pr relationship nhi ban rha
Kyu banega ..kya concept sikhaya hai..
Primary key aur foreign key ka concept karaya hai na aapko
@@Innozant sir pls share link
Sales
Saadu
😊❤️
Sir apki sabi video MAi se sirf yahi relationship wala vedio bilkul samj ni aarahi hai.... Ab dekho
Mere pas 4 table ex..
Name jan feb
A 8 87
B 88 86
C 85 84
Name mar apr
A 66 78
B 87 86
C 55 56
Name may june
A 86 86
B 83 46
C 86 64
Name jul aug
A 76 67
B 44 86
C 46 86
Aur jab mai relation leta hai jaise
Maine kara
Table 1...........name
Table2............ Name
Fir maine kiya
Table1....... Name
Table3........ Name
Fir
Table1........name
Table4........ Name
Aur mai output aysa chata hu
Name jan feb mar ap may jun
A 77 777
B ;;;; son on.......
C
Matlb sabhi month combine ho jaye oibit mai
Lakin jab may drag karta hu... To fir ye error aa jata hai....
Relationship between tables may be needed?
Pls help karo...!. Ye video ya concept pls samjha do.... Ya kisi bhi video mai mere ye wala question pls karao.. Ap pls sir
Aisa kyu..again repeat kriye video ko dear
@@Innozant sir mai kam se km 50 bar kar chuka. Hu.. Pta. Ni... Kya issue aa raha hai... Kuch samj ni aa raha hai...ap pls yahi question ek video mai daldo pls
Sir 2 table tak to aata hai by jaise hi 3 tables ho jate hai to jab mai drag karta hu to bolta hai relationship needed..??
Bahut pakatu ho sir ji
Bina concept clear hue bouncer hi jaat hai Nirmal Kumar Ji,In Sequence hi learn karna hota hai yahan .Randaom video dekhenge to sir dird hi hoga 😀