Consolidate Multiple Excel Files into One Excel File in Hindi
✔️ Join Pandrive Computer Course - offline.pcskill.in/
अगर आपके पास कई सारी Excel Files जिसमें एक जैसा Data है ताेे आप बडी आसानी से consolidate function कर इस्तेमाल कर Multiple Files को Consolidate कर सकते हैं तो आईये जानते हैं - Consolidate Multiple Excel Files into One Excel File in Hindi
हमारे टॉप 5 वीडीयो -
1- केवल Hindi Typing वाले देखें - goo.gl/fKXmvw
2- Excel में IF को नहीं सीखा तो क्या सीखा ? - goo.gl/yPh5vb
3- Excel Expert बनना है तो ये देखो - goo.gl/2W66t4
4- Excel का ये Formula अापकी सारी थकान मिटा देगा - goo.gl/LEWFgL
5- क्या आपने Excel में मैक्रो (macro) सीखा ? - goo.gl/k2HQcm
एक्सेल के सभी वीडीयो यहॉ देखें - goo.gl/aF43Hs
एक्सेस के सभी वीडीयो यहॉ देखें - goo.gl/LRohxH
वर्ड के सभी वीडीयो यहॉ देखें - goo.gl/1yKpk1
कंप्यूटर नेटवर्किंग के सभी वीडीयो यहॉ देखें - goo.gl/9qmhvL
फोटोशॉप के सभी वीडीयो यहॉ देखें - goo.gl/AVsjLZ
विंडोज 7 के सभी वीडीयो यहॉ देखें - goo.gl/z44h2d
जीमेल के सभी वीडीयो यहॉ देखें - goo.gl/h3EZzv
यूट्यूब के सभी वीडीयो यहॉ देखें - goo.gl/zqzoJW
टेक्नोलॉजी के सभी वीडीयो यहॉ देखें - goo.gl/pfQKsk
Facebook - / geekyabhimanyu
WebSite - mybigguide.com
Like us on Facebook : / mybigguide
Follow us on Twitter : / mybigguide
Android app on Play store : goo.gl/pNJWTv
हर रोज नया वीडियो ट्यूटोरियल हिन्दी में पाने के लिये हमारा यूट्यूब चैनल सबस्क्राइब करें और घर बैठे ही जॉइन करें माय बिग गाइड स्मार्ट क्लास 👈
इसके अलावा अगर आप हिंदी में और भी तकनीकी जानकारी प्राप्त करना चाहते हैं तो आप हमारी बेवसाइट mybigguide.com पर जा सकते हैं और अगर आपको कुछ पूछना है तो आप हमें Help@mybigguide.com पर मेल कर सकते हैै
Пікірлер: 158
I like your video. You teach us in a very simple and easy way. Keep it up. Thanks and upload videos always.
आप ईशी तरह अपना सफ़र जारी रखेगे पका एक दिन आप इंडिया के टॉप १० youtuber मे शामिल हो जाओगे क्योकि आप के बताने का तरीका बहूत ही साधारण और जबरदस्त है
Chha gye bro. It's very useful for me. Thanks. Please continue. Good job.
Too good boss. I used to spend lot time for tHis activity
Very useful video Sirji... Thank You very much
Sir u r great , now I enjoy excel
Best part of your video is it short and but having more content
sir Aap jaldi batane ki koshish kijiye please sir hum bhi computer padhte hai sir lekin ek baat hai jitna mujhe apne guru gyan nahi milta hai utna mujhe Aapka video dekhane se gyan milta hai hum Aapke bahut video dekhate hai
THANKS IT'S NICE VIDEO
Gud job sir bohat bDhya ji
Nice video sir very nice👌👌👌
Really ...you are awesome guru g
आप के बताने का तरीका बहूत ही साधारण और जबरदस्त है
Your videos are very useful and informative, if the description are written in English it LL help the people who don't understand written hindhi
easy to work thanks a lot
आपका बताने का तरीका और आप बहुत ही अच्छा बताते हो
Thanks sir
Great dear sir..
Thank for making nice video
Very nice...
sir Aap bahut Achchhe hai
Thanks Nyc videos
namsakar sir aap garibo ko sahara de rehe ho ,,,jinhe centero wale lutte h ,,,,,jai dharti ma ,,,shiv sarvfev
Nice video sir
Hii dear bro ur vedio is vry useful
sir please make one video of full excel tutorial and tally tutorial
Wow unbelievable
Super sir thank u
very important vedio sir
Dear Sir I watch your video & practice this. All video are great but i want a video for store work related. Video details :- i working a company and our company purchases different type row material from many contractors. I want type all summary in one excel sheet per day and automatically update individual contractors file material wise. Please create a video . thanks
Can we use Tally Erp9 ODBC and convert Trial Balance in Excel format ?is it possible that changes in Trial Balance can be refreshed in Excel Data can you guide me about preparing financial from Trial Balance converted in excel
Awesome
Very useful
बहुत अच्छा
Nice video
I love you sir bahut bahut thank you sir
nice video
Very Nice
Sir kindly tell me how we can find sum of difderent workbook of same data. And droo formula to entire colums
sir i want to merge two excel sheet into one with common column how it can be done?
v nice sir
👌
राम बाण उपाय है सर।
Nice job
Can anyone help me I have 12 months different workbooks consisting 5 sheet of salesman of sales product wise with target and ach% and 1 sheet of consolidated of all 5 sheets i want to make 1 work book linked with all 12 months work book with 6 sheets respectively.
Dear sir, How I filter single value from cell if series of values given in cell like 1,3,11,12,14 and I want to filter and Sort only one value '1' through contain method of filter but it shows all the values those contain 1 but I want to extract only 1 so kindly help me in this problem
I have a data with several column. I want to sort data automatically in different workbook with different columnwise at the same time when i entry. May it possible? If Yes, Please Immediate share me
मस्त गजब
Great
Sir how to make setting in computer such as whenever it completes download it should automatically open file
Really nice sir. i need one help 300 customers montly full details datewise full information display for just page please send videos with consolidate action thanks sir.
Very nice
Good afternoon sir,
Sir, please reply, what if data in our files is different like names are not same and one file contains 10 names other 12 like that then can we use consolidate or is there any other method to consolidate them plz reply sir
Very good video
Hello Sir.... I want to consolidate the data but don't want to do sum....I want the 2nd table should come after 1st table....please guide how to do this?
Very good
Sir picture lookup ka video banaye plz
Nice sir
very nice
Sahi bat hai
Super sir
Hello sir.. Cable operator Bhaiyo k liye ek smart table bnaye please.. Jo monthly payment ka details feel kr ske?
Print karte time page no kaise de pe ak video banana sir
Super
nice
Sir, formula tab me functional library ke bare me bataia
sir Aap bahut Achchhe samjhate mujhe bahut achchha lagta hai Aap ka video sir Aapse ek sawaal puchhana hai sir Corel draw me shadi ka kaise banaye Aur shadi ki card ka size kitna hona chahiye sir mai bahut din se pareshan hu sir please jaldi batane ki koshish kijiye sir mai Aapki video bahut like karta hu sir jaldi bataiye please sir namaskar sir
सर आप से मैं ये पूछना चाहता हु की जैसे तीन अलग-अलग एक्सेल की वर्कबुक में, तीन अलग-अलग ऑपरेटर कार्य कर रहे है। और तीनों अलग-अलग कालम को फील कर लिए है। अब इन तीनो वर्कबुक को एक शीट में सही क्रम में बिना कॉपी पेस्ट कैसे लाएं। प्लीज जल्दी से कोई उपाय बताए।
Good
Sir Excel में Access Restrict की Permission पर एक Vedio बनाने की कृपा करें
Mane boht c videos dekhi h but Jo videos aap apne channel p dalte ho.Thts superb..means ki apko boht ache se smjhana ata h kisi topic ko..so thnk u so much sir. ty mybigguide.com
Sir mere Ko excel me ek worksheet ke andar sheet1,2 jod Kar uska effect sheet no 3 me Lena like sheet 1,2 me +-*/ sari formula apply Kari to uski effect 3 me muje dikhe pls us formula ya condition ka video Bana ye ap ka answer ka or video ka wait rahega
Sir ek work sheet m multiple sheet h jan feb mar or summary data different jagah h jan a column se data h feb m c column se data start ho rha h mujhe New sheet m consolidate krna h jisme jan to Nov tak
How remove blank rows in worksheet in one time pl help us this video is helpful
@ssssingh1983
6 жыл бұрын
एक फाइल मै एंट्री करने पर वही एंट्री दूसरी फाइल मे कैसे करें।
Abhimanyu ji yadi sum nhi krna ho or sirf alg alg workbook se data hi lena ho to kya krna hoga.
Dear sir, I am from pakistan and i take many lectres about excel i cant find any formula about that i can find any value in multiple sheets plz tell me how can i find any value in multiple sheets by using search box as u teach us ..
सर कोइ ऐसा उपाए बताइए कि भौचर Entry kartehi Finance ka Sara report tyaar hojaae plz
sum required when only filter used
I want VBA code for copy past data from sheet 1 to another sheet Condition is .. 1) If Column Q have bank value then copy that to another sheet and delete rows ctrl - 2) If column c have 0,00 and E column have bank value then I want to copy this to another sheet and delete this rows (clt - ) and column E 00 and column c for blank copy past in another sheet and again delete this rows
Sir i need your help in one of my project file kay aap mere liye ex excel pe ek vba bana sakte hai. ya mujhe help kar sakte hai krpya apna mail id dijiye mail apko formate mail karta huin.
Percentile rank kese nikale ? Formula bataiye hindi me
nice video but only value copy not any text copy ... so plz help
I have a excel data in which there is space between name and surname but by misteak space removed between name and surname and i saved the file but I want there should be space between name and surname how can I do this?
Sir MS word ka bhi koi advanced link karne options Hai Kya .
Sir voice Hindi typing bhut badiya he lekin Sanskrit me typing ka farmula ho to batana thanks
Sir ek macro enable kark kuch aata hai likha hota hai can not run macro or may be disabled all macro Kabhi kabhi run time Error 76 bhi aata hai excel mein ....kisi Ko nhi pta iska kya karna h mere pass wo Excel ki sheet hai but uska macros enable karne k baad bhi create to text button par click karta hu to macros disable btata hai jabki main trust centre mein jakar k macro enable kar Chuka hu kuch idea do sir.....main apka Bhoot bda fan hu aur apss Bhoot kuch sikha hai
Sorry sir, m ni kr pai..plzz ap btay Kon c m galti kar rhi hu
Sir mara pas le drawing hai JIS ki lambae 2 meter hai,sir mai easy kaisa computer ma load karsakta hu Kya yah word or auto cad say ssmbhav hai please sir reply Karta ga
Sir please help sir mane aapko mail kiya please help
*Nice! Nice! Nice! Nice! Nice!!!!!!* 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌
सर् अगर फिल्टर लगा हो तो sr. no. ऑटो fill नही होता कुछ उपाय बताए
जैसे समय गणना मे दिनांक माह तथा वर्ष की गणना आती है वैसे ही
Sir mere pas 2 alag-2 work book h Dusari work ka kuchh data mujhe pahli work book par chahiye
Hume aap Ki help chahiye Maine excel me 4 file ready kiya A b c d Formula seat a b me work kiya Mai retail mis Ki baat kar Raha hu
सर , एक प्रशन पूछना था , मेरा सिस्टम विंडो -7 है ! मैं Excel file को CSV फाइल मैं बदलने के लिए "SAVE AS" ka use karta tha aur file csv main badal bhi ho jati thi lekin ab usey CSV karne ke baad bhi vaha EXCEL FORMAT me hi rahti ,,,,kya uske liye koi manual setting hai ! ya fir kisi app ko Install karna hoga ,,,,,,,,,,,,,,,plz Help me sir
Sir ji hamare pass 1 Excel h 12 month ki usme Kai logo k naam h but same nhi h person bhi Kam jyada h unka 1 sheet par summary banana h koi tric h Kya sir Thora jaldi bataiyega uspe kaam chalu h badi sheet h jaldi bta dege to meharbani hogi
Apki suru se Excel ki video ko dekhne ke liye Kya Karna hoga sir
Sir excel m format k under formula kaise lgae
color formula in excel kese use kare