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

  • @anuradhakushwaha5695
    @anuradhakushwaha56955 жыл бұрын

    I like your video. You teach us in a very simple and easy way. Keep it up. Thanks and upload videos always.

  • @moderntiles414
    @moderntiles4146 жыл бұрын

    आप ईशी तरह अपना सफ़र जारी रखेगे पका एक दिन आप इंडिया के टॉप १० youtuber मे शामिल हो जाओगे क्योकि आप के बताने का तरीका बहूत ही साधारण और जबरदस्त है

  • @DineshYadav-cn5yt
    @DineshYadav-cn5yt6 жыл бұрын

    Chha gye bro. It's very useful for me. Thanks. Please continue. Good job.

  • @AshokKumar-sy2qt
    @AshokKumar-sy2qt6 жыл бұрын

    Too good boss. I used to spend lot time for tHis activity

  • @rajeshbiswakarma7189
    @rajeshbiswakarma71896 жыл бұрын

    Very useful video Sirji... Thank You very much

  • @maheshasodia4960
    @maheshasodia49606 жыл бұрын

    Sir u r great , now I enjoy excel

  • @narendrarawat7764
    @narendrarawat77646 жыл бұрын

    Best part of your video is it short and but having more content

  • @saifansari6268
    @saifansari62686 жыл бұрын

    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

  • @imrandivan750
    @imrandivan7506 жыл бұрын

    THANKS IT'S NICE VIDEO

  • @sarbjeetkaur2978
    @sarbjeetkaur29786 жыл бұрын

    Gud job sir bohat bDhya ji

  • @TravelAndheri
    @TravelAndheri6 жыл бұрын

    Nice video sir very nice👌👌👌

  • @divyanshyadav9226
    @divyanshyadav92266 жыл бұрын

    Really ...you are awesome guru g

  • @shaktisinghpunas7231
    @shaktisinghpunas72315 жыл бұрын

    आप के बताने का तरीका बहूत ही साधारण और जबरदस्त है

  • @imnasirjan
    @imnasirjan5 жыл бұрын

    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

  • @mhdndm13
    @mhdndm136 жыл бұрын

    easy to work thanks a lot

  • @sagramnetam8027
    @sagramnetam80276 жыл бұрын

    आपका बताने का तरीका और आप बहुत ही अच्छा बताते हो

  • @souravsinghbolt9933
    @souravsinghbolt99336 жыл бұрын

    Thanks sir

  • @DhiruJi02
    @DhiruJi026 жыл бұрын

    Great dear sir..

  • @d.likhita2930
    @d.likhita29306 жыл бұрын

    Thank for making nice video

  • @appa1855
    @appa18556 жыл бұрын

    Very nice...

  • @saifansari6268
    @saifansari62686 жыл бұрын

    sir Aap bahut Achchhe hai

  • @Rajkumarsharma-xj2pu
    @Rajkumarsharma-xj2pu5 жыл бұрын

    Thanks Nyc videos

  • @DineshKumar-ug3vr
    @DineshKumar-ug3vr6 жыл бұрын

    namsakar sir aap garibo ko sahara de rehe ho ,,,jinhe centero wale lutte h ,,,,,jai dharti ma ,,,shiv sarvfev

  • @mukeshkumarsharma8447
    @mukeshkumarsharma84476 жыл бұрын

    Nice video sir

  • @deepgupta3188
    @deepgupta31885 жыл бұрын

    Hii dear bro ur vedio is vry useful

  • @sadhuram4277
    @sadhuram42776 жыл бұрын

    sir please make one video of full excel tutorial and tally tutorial

  • @Dipendrakk
    @Dipendrakk5 жыл бұрын

    Wow unbelievable

  • @hindiclasses1586
    @hindiclasses15865 жыл бұрын

    Super sir thank u

  • @haridaskhutte8154
    @haridaskhutte81546 жыл бұрын

    very important vedio sir

  • @malketpareek4446
    @malketpareek44466 жыл бұрын

    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

  • @kamlesh1421973
    @kamlesh14219736 жыл бұрын

    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

  • @rizwanmemon6933
    @rizwanmemon69335 жыл бұрын

    Awesome

  • @deepakkumarofficial7353
    @deepakkumarofficial73535 жыл бұрын

    Very useful

  • @nikhileshsharma3672
    @nikhileshsharma36725 жыл бұрын

    बहुत अच्छा

  • @AdeshKumar-hn2ke
    @AdeshKumar-hn2ke6 жыл бұрын

    Nice video

  • @saifansari6268
    @saifansari62686 жыл бұрын

    I love you sir bahut bahut thank you sir

  • @indrajeet2259
    @indrajeet22596 жыл бұрын

    nice video

  • @asmrindia
    @asmrindia5 жыл бұрын

    Very Nice

  • @waseemzafar6775
    @waseemzafar67756 жыл бұрын

    Sir kindly tell me how we can find sum of difderent workbook of same data. And droo formula to entire colums

  • @RAJESHSHAHnirankar
    @RAJESHSHAHnirankar6 жыл бұрын

    sir i want to merge two excel sheet into one with common column how it can be done?

  • @bharatkachhadia8117
    @bharatkachhadia81176 жыл бұрын

    v nice sir

  • @anjaransari5183
    @anjaransari51836 жыл бұрын

    👌

  • @arijeetkumarsharma226
    @arijeetkumarsharma2265 жыл бұрын

    राम बाण उपाय है सर।

  • @sandeepsutarp
    @sandeepsutarp6 жыл бұрын

    Nice job

  • @rizwanmemon6933
    @rizwanmemon69335 жыл бұрын

    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.

  • @cpvirani9865
    @cpvirani98656 жыл бұрын

    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

  • @trickysportsbesttricks7383
    @trickysportsbesttricks73836 жыл бұрын

    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

  • @shahgangani6510
    @shahgangani65106 жыл бұрын

    मस्त गजब

  • @alihasanreshamwala
    @alihasanreshamwala6 жыл бұрын

    Great

  • @manojjagtap1095
    @manojjagtap10955 жыл бұрын

    Sir how to make setting in computer such as whenever it completes download it should automatically open file

  • @ramang662
    @ramang6626 жыл бұрын

    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.

  • @rishikesh243
    @rishikesh2436 жыл бұрын

    Very nice

  • @anjaneyulukodam9961
    @anjaneyulukodam99616 жыл бұрын

    Good afternoon sir,

  • @kirandeepchoudhry9232
    @kirandeepchoudhry92325 жыл бұрын

    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

  • @Shyam1472
    @Shyam14726 жыл бұрын

    Very good video

  • @manojaher2217
    @manojaher22175 жыл бұрын

    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?

  • @mubassiralia.saiyed3017
    @mubassiralia.saiyed30175 жыл бұрын

    Very good

  • @arvindtiwari7586
    @arvindtiwari75866 жыл бұрын

    Sir picture lookup ka video banaye plz

  • @deepaksingh6184
    @deepaksingh61845 жыл бұрын

    Nice sir

  • @haridaskhutte8154
    @haridaskhutte81546 жыл бұрын

    very nice

  • @santoshsaraswat2851
    @santoshsaraswat28516 жыл бұрын

    Sahi bat hai

  • @muralisree1536
    @muralisree15366 жыл бұрын

    Super sir

  • @dhirajnirala599
    @dhirajnirala5996 жыл бұрын

    Hello sir.. Cable operator Bhaiyo k liye ek smart table bnaye please.. Jo monthly payment ka details feel kr ske?

  • @LalitSharma-sq4hi
    @LalitSharma-sq4hi6 жыл бұрын

    Print karte time page no kaise de pe ak video banana sir

  • @xlpointacademy5127
    @xlpointacademy51275 жыл бұрын

    Super

  • @snpandey007
    @snpandey0076 жыл бұрын

    nice

  • @coolsciencemath161
    @coolsciencemath1615 жыл бұрын

    Sir, formula tab me functional library ke bare me bataia

  • @saifansari6268
    @saifansari62686 жыл бұрын

    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

  • @dvmovies1982
    @dvmovies19826 жыл бұрын

    सर आप से मैं ये पूछना चाहता हु की जैसे तीन अलग-अलग एक्सेल की वर्कबुक में, तीन अलग-अलग ऑपरेटर कार्य कर रहे है। और तीनों अलग-अलग कालम को फील कर लिए है। अब इन तीनो वर्कबुक को एक शीट में सही क्रम में बिना कॉपी पेस्ट कैसे लाएं। प्लीज जल्दी से कोई उपाय बताए।

  • @jalilahmed1182
    @jalilahmed11826 жыл бұрын

    Good

  • @itsajjanexcellencehssumari3932
    @itsajjanexcellencehssumari39326 жыл бұрын

    Sir Excel में Access Restrict की Permission पर एक Vedio बनाने की कृपा करें

  • @RajuAli00488
    @RajuAli004886 жыл бұрын

    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

  • @AnkitChauhan-fb1qn
    @AnkitChauhan-fb1qn5 жыл бұрын

    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

  • @bharatsingh9516
    @bharatsingh95165 жыл бұрын

    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

  • @vinayakbhandare1180
    @vinayakbhandare11806 жыл бұрын

    How remove blank rows in worksheet in one time pl help us this video is helpful

  • @ssssingh1983

    @ssssingh1983

    6 жыл бұрын

    एक फाइल मै एंट्री करने पर वही एंट्री दूसरी फाइल मे कैसे करें।

  • @kpnalshj
    @kpnalshj6 жыл бұрын

    Abhimanyu ji yadi sum nhi krna ho or sirf alg alg workbook se data hi lena ho to kya krna hoga.

  • @luqmanmehmood9779
    @luqmanmehmood97796 жыл бұрын

    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 ..

  • @Lovewithnature
    @Lovewithnature6 жыл бұрын

    सर कोइ ऐसा उपाए बताइए कि भौचर Entry kartehi Finance ka Sara report tyaar hojaae plz

  • @RakeshKumar-fy3bi
    @RakeshKumar-fy3bi5 жыл бұрын

    sum required when only filter used

  • @tambolisadik
    @tambolisadik6 жыл бұрын

    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

  • @abhay423
    @abhay4236 жыл бұрын

    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.

  • @darbarsir5257
    @darbarsir52576 жыл бұрын

    Percentile rank kese nikale ? Formula bataiye hindi me

  • @lalitkhatri9836
    @lalitkhatri98366 жыл бұрын

    nice video but only value copy not any text copy ... so plz help

  • @AwadheshKumar-hv6em
    @AwadheshKumar-hv6em6 жыл бұрын

    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?

  • @soundbooster8235
    @soundbooster82355 жыл бұрын

    Sir MS word ka bhi koi advanced link karne options Hai Kya .

  • @nirmalpatel3615
    @nirmalpatel36156 жыл бұрын

    Sir voice Hindi typing bhut badiya he lekin Sanskrit me typing ka farmula ho to batana thanks

  • @Arvindkumar-hh3mc
    @Arvindkumar-hh3mc5 жыл бұрын

    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

  • @farhakhan470
    @farhakhan4706 жыл бұрын

    Sorry sir, m ni kr pai..plzz ap btay Kon c m galti kar rhi hu

  • @d.likhita2930
    @d.likhita29306 жыл бұрын

    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

  • @nilecrocodile6906
    @nilecrocodile69066 жыл бұрын

    Sir please help sir mane aapko mail kiya please help

  • @SEEYOUATTOP
    @SEEYOUATTOP6 жыл бұрын

    *Nice! Nice! Nice! Nice! Nice!!!!!!* 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌 👌

  • @yogeshwaykos9547
    @yogeshwaykos95476 жыл бұрын

    सर् अगर फिल्टर लगा हो तो sr. no. ऑटो fill नही होता कुछ उपाय बताए

  • @drshivgargg5182
    @drshivgargg51826 жыл бұрын

    जैसे समय गणना मे दिनांक माह तथा वर्ष की गणना आती है वैसे ही

  • @khetramPatel
    @khetramPatel6 жыл бұрын

    Sir mere pas 2 alag-2 work book h Dusari work ka kuchh data mujhe pahli work book par chahiye

  • @rajeshkumarshukla3436
    @rajeshkumarshukla34365 жыл бұрын

    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

  • @sanjaysoni3443
    @sanjaysoni34436 жыл бұрын

    सर , एक प्रशन पूछना था , मेरा सिस्टम विंडो -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

  • @sanjayshukla9523
    @sanjayshukla95236 жыл бұрын

    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

  • @kkkkrishna1477
    @kkkkrishna14776 жыл бұрын

    Apki suru se Excel ki video ko dekhne ke liye Kya Karna hoga sir

  • @priyaverma3007
    @priyaverma30076 жыл бұрын

    Sir excel m format k under formula kaise lgae

  • @chandannayak4185
    @chandannayak41855 жыл бұрын

    color formula in excel kese use kare