Wow😲! Epic trick of Excel to combine data from multiple excel files.

Wow😲! Epic trick of Excel to combine data from multiple excel files.
In this video you will learn Excel trick to combine data from multiple excel files, example you have 100 excel files that contains a data and you want merge all these files dynamically then here the trick for that, combine all the excel files from one folder using Excel PowerQuery.
#exceltricks
#excelpowerquery
#exceltutorial
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My KZread Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

Пікірлер: 215

  • @yawarbakht7215
    @yawarbakht72158 ай бұрын

    Marvellous Sir - Really appreciate the way of teaching and learning studies in Excel.

  • @amitdoctor3677
    @amitdoctor36774 ай бұрын

    I am ready your teaching styles are wonderful,

  • @girishpatel3653
    @girishpatel36538 ай бұрын

    Marvellous Sir...😊

  • @auraharry7990
    @auraharry79908 ай бұрын

    THANK YOU SIR. FROM LAST WEEK I AM LOOKING FOR THE SAME PROBLEM.

  • @shubhangiupadhyay1206
    @shubhangiupadhyay120610 ай бұрын

    I like your all videos and your amazing tricks ❣️❤

  • @infoworldtv7880
    @infoworldtv788010 ай бұрын

    Very informative video

  • @syedikramullah1114
    @syedikramullah111411 ай бұрын

    Please make a video comparing the two workbooks.

  • @vikasguatm8572
    @vikasguatm857210 ай бұрын

    Sir aap bahut achha padate h thank sir

  • @deepeshsarathe529
    @deepeshsarathe52910 ай бұрын

    Excellent 👍🎉❤😊

  • @ramlalmahato3441
    @ramlalmahato34416 ай бұрын

    I'm ready to learn. you r great

  • @1183Master
    @1183Master5 ай бұрын

    Very useful Video....Nice method of teaching.

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Thanks a lot

  • @1183Master
    @1183Master5 ай бұрын

    Mast ...Method of Teaching. It's very useful for me.

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Glad to hear that

  • @syedikramullah1114
    @syedikramullah111411 ай бұрын

    It's amazing

  • @janityping1938
    @janityping193811 ай бұрын

    Nice sir❤

  • @beautifulgoa8469
    @beautifulgoa846917 күн бұрын

    Thank you very much Sir! I have a folder with 4.8k files.. you are a God sent.. 🙏

  • @obsidian_the_exposure
    @obsidian_the_exposure10 ай бұрын

    Ready to go 😊

  • @Godlovermukeshjha
    @Godlovermukeshjha9 ай бұрын

    I am ready to learn.

  • @parveshdobriyal6078
    @parveshdobriyal60788 ай бұрын

    I'm ready to learn.

  • @zeeshanahmad4223
    @zeeshanahmad42234 ай бұрын

    Ready to learn

  • @understandthewordsfeelthes3036
    @understandthewordsfeelthes30364 ай бұрын

    Helpful information 👍👍👌👌👌

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Stay connected

  • @rickykumar8595
    @rickykumar85954 ай бұрын

    Yes I'm ready 👍

  • @Excel_Word_Trick_08
    @Excel_Word_Trick_0811 ай бұрын

    Nice video

  • @rajendradeshpande3540
    @rajendradeshpande35407 ай бұрын

    Yes, I m ready

  • @psrinivasulunaik7116
    @psrinivasulunaik71169 ай бұрын

    Hello sir, i am trying to convert multiple excel file into single file but the all-file format is in csv extensions where are it asking xlsx format how I can convert them into xlsx because i have huge file which can't convert them in online can we merge with csv extension file.

  • @user-zv9qf6fn5n
    @user-zv9qf6fn5n4 ай бұрын

    Helpful information 👍

  • @Excel_Tutorial

    @Excel_Tutorial

    8 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @pravingawade9488
    @pravingawade948810 ай бұрын

    multiple workbooks main different column heading hai toh kaise merge kar sakte hai? pls help me.

  • @AdityaKumar-hm7cb
    @AdityaKumar-hm7cbАй бұрын

    Hello sir, Is it necessary to have the same headings on the sheets of each work book to transport multiple work books after keeping them in one folder?

  • @binaybaranwalbaranwal7059
    @binaybaranwalbaranwal70592 ай бұрын

    Yes, ready

  • @Surajk927
    @Surajk92711 ай бұрын

    Kya ye headers match na hone pe bhi use kr skte h matlab headers name same h but wo idhar udhr honge

  • @hussainmeghani8785
    @hussainmeghani87858 ай бұрын

    What in adding custom cloumn step (Excel.Workbook) if we hv to merge txt filed.....

  • @sunilbhagwat1060
    @sunilbhagwat10606 ай бұрын

    I'm ready to learn

  • @theinfo444
    @theinfo44411 ай бұрын

    Please make video on Power BI in Excel.

  • @user-cy3qe2pu3m
    @user-cy3qe2pu3m10 ай бұрын

    Yes I'm ready

  • @ajayverma-hn3zt
    @ajayverma-hn3zt10 ай бұрын

    Yes I m ready

  • @sourabh372
    @sourabh372Ай бұрын

    Thank u Sir, Just a question regarding same.. How to merge Sales and stock data from different Sheets .. columns are same just one is sales another is stock.. row lines more than 10 Lacs..

  • @atulkadbe4082
    @atulkadbe408211 ай бұрын

    Good sir

  • @snehadey6284
    @snehadey628410 ай бұрын

    i am ready to learn

  • @rikeshthapa7497
    @rikeshthapa749710 ай бұрын

    Yes I am ready

  • @ryjn6529
    @ryjn65298 ай бұрын

    I m ready to learn

  • @abidnawaz8527
    @abidnawaz852710 ай бұрын

    I am ready to learn

  • @ndtiwariii
    @ndtiwariii6 ай бұрын

    thank you sir

  • @Excel_Tutorial

    @Excel_Tutorial

    14 күн бұрын

    Most welcome, Keep watching the new videos I am uploading.(kzread.info/dash/bejne/ZZWV0LOhh8i7hNI.html)

  • @TechTutorRanveer
    @TechTutorRanveer11 ай бұрын

    Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya

  • @BIGVIKGAMING
    @BIGVIKGAMING10 ай бұрын

    Sir excel ka jo 8 hr ka tutorial h usme or paid bale m kya difference hai ?

  • @organic6195
    @organic619511 ай бұрын

    Guru g stock p video bna do jisme kg , ltr, box ho plz sir apki wjh s main Aaj job kr pa rha hu thx learn more

  • @priyaslife2learn857
    @priyaslife2learn8576 ай бұрын

    Can I transfer one cell marks or no from 1 workbook to another workbook ...only the cell value

  • @Tanvxxr7
    @Tanvxxr711 ай бұрын

    First comment sir ♥️♥️

  • @reetakisna
    @reetakisna5 ай бұрын

    Very nice

  • @Excel_Tutorial

    @Excel_Tutorial

    6 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @nimaydey6466
    @nimaydey64669 ай бұрын

    I am ready

  • @ashutoshdixit6781
    @ashutoshdixit678110 ай бұрын

    Sir apka Jo course hai ms Excel Basic to advance uski practice file kaha se milegi kripya aap mujhe bataiye

  • @TechTutorRanveer
    @TechTutorRanveer11 ай бұрын

    I'm ready

  • @vishalyadav-bb7tr
    @vishalyadav-bb7tr13 күн бұрын

    Yes, I'm ready

  • @Excel_Tutorial

    @Excel_Tutorial

    9 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @budheshwarkullu2301
    @budheshwarkullu23014 ай бұрын

    Ready to Learn.

  • @Excel_Tutorial

    @Excel_Tutorial

    8 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @Firozk91
    @Firozk916 ай бұрын

    im ready to learn

  • @Excel_Tutorial

    @Excel_Tutorial

    6 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @memoriescollection2584
    @memoriescollection2584Ай бұрын

    Sir plz upload how to use form control in details. ..plz plz plz

  • @rajnikeshary4615
    @rajnikeshary46154 ай бұрын

    Hi, I have extra columns in few xcl wrkst, how do we combine the data and have the uniform columns. Plz assist here

  • @zameeransari753

    @zameeransari753

    3 ай бұрын

    I also have the same question

  • @Ritikasinha769
    @Ritikasinha7699 ай бұрын

    Yes ready to leary

  • @SanjayKumar-wl2nw
    @SanjayKumar-wl2nw10 ай бұрын

    I had an interview in which there was a question from date format written 06/08/2023 ESS date should be changed to AuG-23

  • @rajnipandey9901

    @rajnipandey9901

    8 ай бұрын

    Did you get the answer?

  • @azradange9528

    @azradange9528

    6 ай бұрын

    On Home Tab, Select Number, then under Category Tab on left side select Custom. Below Type options on right side look for mmm-yy. Select this option and you will see the date as Aug-23. There are many options which can be used or you can simply create a new option. Hope this helps.

  • @Allinone-sh6cj

    @Allinone-sh6cj

    6 ай бұрын

    Mmm yy in custom number format easy

  • @santoshnaik2391

    @santoshnaik2391

    4 ай бұрын

    Ko is it 0:22 ko😅 Oi 😂 oi jij i😅​@@rajnipandey9901

  • @prdfgorakhpur5198
    @prdfgorakhpur51985 ай бұрын

    yes i am ready

  • @Excel_Tutorial

    @Excel_Tutorial

    5 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @frgf64
    @frgf647 ай бұрын

    Sir, I want to add one additional column from 5th row onwords.

  • @Allinone-sh6cj

    @Allinone-sh6cj

    6 ай бұрын

    5th row ko select krke ctrl + press krdo select krne ka shortcut ctrl+spacebar😊

  • @sonumnd143
    @sonumnd1435 ай бұрын

    Yes ready

  • @Excel_Tutorial

    @Excel_Tutorial

    6 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @dhwanitravat306
    @dhwanitravat30610 ай бұрын

    i am ready

  • @navyakavyars1414
    @navyakavyars141411 ай бұрын

    I" am ready

  • @sureshkumarsaini1243
    @sureshkumarsaini12436 ай бұрын

    YES I AM READY

  • @Excel_Tutorial

    @Excel_Tutorial

    5 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @jitendrajasani5829
    @jitendrajasani582910 ай бұрын

    Iam ready

  • @AbhishekMishra-bk2ph
    @AbhishekMishra-bk2phАй бұрын

    Yes

  • @GauravKumar-ti4oc
    @GauravKumar-ti4oc10 ай бұрын

    Sir power bi full course laiye plz

  • @dayanidhimishra4980
    @dayanidhimishra49804 күн бұрын

    yes

  • @ateeqahmedaa2028
    @ateeqahmedaa202819 күн бұрын

    Yes 😊

  • @Excel_Tutorial

    @Excel_Tutorial

    14 күн бұрын

    Keep watching the new videos I am uploading.

  • @sameerdixit
    @sameerdixit10 ай бұрын

    windows ke liye aapka app nhi hai ?

  • @AjayKumar-qg8hw
    @AjayKumar-qg8hw2 ай бұрын

    merge formatting shortcut? In Ms word

  • @SurprisedBigWaterfall-yd1ln
    @SurprisedBigWaterfall-yd1ln2 ай бұрын

    Ready

  • @sanjubadgujar5899
    @sanjubadgujar58995 ай бұрын

    I am really to learn

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching

  • @rockeykumar1300
    @rockeykumar130011 ай бұрын

    🎉

  • @faisalbashir8871
    @faisalbashir88713 ай бұрын

    ready

  • @maqsoodahmednagouri3026
    @maqsoodahmednagouri3026Ай бұрын

    hello sir, I want to practice on school result and id in excel sheet

  • @SHARADTJR
    @SHARADTJR2 ай бұрын

    Very nice video Csv file se karne par error aa raha hai

  • @pandupandi_143
    @pandupandi_14310 ай бұрын

    Hello sir aapki certificate kese milte hai aur kahanse milte hai?

  • @yubrajsingh2444
    @yubrajsingh24442 ай бұрын

    Is this work possiable in excel 2013 ??

  • @sangeetaprajapati-yi6wl
    @sangeetaprajapati-yi6wl9 ай бұрын

    Agar column aage peeche ho ya koi column ho hi na to kese karenge

  • @AbuSam97
    @AbuSam9710 ай бұрын

    Excel ka konsa version hai ye?

  • @nirbhaykumar31999
    @nirbhaykumar319994 ай бұрын

    Mera pas ek folder me 40 Excel ki alag alag sheet hai to main ye chahta hu ki meri 40 Excel sheet ek hi Excel me alag alag create ho jaye .... Kya yah possible hai

  • @subhamsingh5769
    @subhamsingh57696 ай бұрын

    I am learn

  • @manojparmar4155
    @manojparmar41559 ай бұрын

    yes rady

  • @arg805
    @arg805Ай бұрын

    I AM READY TO LEARN

  • @Excel_Tutorial

    @Excel_Tutorial

    9 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @mahendrapurohit9091
    @mahendrapurohit909111 ай бұрын

    Sir offer kab aayega ab??

  • @somnathnaskar7393
    @somnathnaskar73932 ай бұрын

    Can i make it in onedrive

  • @purshottamlalverma3083
    @purshottamlalverma30835 ай бұрын

    Yes I am ready to learn msexcel

  • @Excel_Tutorial

    @Excel_Tutorial

    Ай бұрын

    Keep watching

  • @zameeransari753
    @zameeransari7533 ай бұрын

    What if I don't have the same columns

  • @RizwanAhmad-ss9eh
    @RizwanAhmad-ss9eh3 ай бұрын

    Yes sir

  • @Excel_Tutorial

    @Excel_Tutorial

    8 күн бұрын

    Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)

  • @ccspgawadhesh
    @ccspgawadhesh5 ай бұрын

    सर किसी pdf file से excel 2007 में data कैसे import करे । जब कि data table format मे नही हो । data rows and column मे है लेकिन lines नही है और हर page ke top aur bottom पर picture hai.

  • @ccspgawadhesh

    @ccspgawadhesh

    5 ай бұрын

    Kindly reply soon.

  • @biswas696
    @biswas69610 ай бұрын

    Mera ek sabal hai kaya aap solve kar sakta hai ?

  • @atulpandey632
    @atulpandey632Ай бұрын

    Kya koi bata skta hai ki alag workbook ke data dusre workbook sheet me kaise data la sakte hai 😢

  • @sunyanakapoor
    @sunyanakapoor10 ай бұрын

    Imp talk start from here 3:01

  • @skdaveskdave9798
    @skdaveskdave97984 ай бұрын

    window 7 how to combine data from multiple excel file kese kare

  • @NIKHILLOKHANDE-nk9sl
    @NIKHILLOKHANDE-nk9slАй бұрын

    excel 2016 mein folder select krne k baad combine ,transform database ka option hi nhi aata!!!!!!!!

  • @mukund6499
    @mukund64999 ай бұрын

    2013 me kese hoga

  • @SaranSafar.
    @SaranSafar.8 ай бұрын

    अन्ना जी से ही जिनको सीखना हैं वो बताए 😂

  • @amitpalande1168
    @amitpalande11688 ай бұрын

    खूप छान माहिती , फक्त विनंती जमले तर मुदावर जास्त बोला, व्यफल बडबड पेक्ष

  • @wanderlust_ansh_5914
    @wanderlust_ansh_59144 ай бұрын

    Payment date column??

  • @mukeshkrgupta3412
    @mukeshkrgupta341211 ай бұрын

    🙏 sir aap best teacher hai. Aapse request hai ki aap video ko idhar udhar ki jyada bato se video lamba na kare Thora time bache. Detailed video ke liye thankyou again. Maine aapki bahut videos kafi time pahle dekha hai Aaj fir KZread ne aapki yaad dilayi