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

Рет қаралды 145,392

11 ай бұрын

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 KZfaq 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 8 ай бұрын

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

@amitdoctor3677 4 ай бұрын

I am ready your teaching styles are wonderful,

@girishpatel3653 8 ай бұрын

Marvellous Sir...😊

@vikasguatm8572 10 ай бұрын

Sir aap bahut achha padate h thank sir

@auraharry7990 9 ай бұрын

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

@infoworldtv7880 10 ай бұрын

Very informative video

@deepeshsarathe529 10 ай бұрын

Excellent 👍🎉❤😊

@ramlalmahato3441 6 ай бұрын

I'm ready to learn. you r great

@syedikramullah1114 11 ай бұрын

It's amazing

@shubhangiupadhyay1206 10 ай бұрын

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

@rickykumar8595 4 ай бұрын

Yes I'm ready 👍

@janityping1938 11 ай бұрын

Nice sir❤

@zeeshanahmad4223 5 ай бұрын

Ready to learn

@rajendradeshpande3540 7 ай бұрын

Yes, I m ready

@binaybaranwalbaranwal7059 2 ай бұрын

Yes, ready

@Godlovermukeshjha 9 ай бұрын

I am ready to learn.

@parveshdobriyal6078 8 ай бұрын

I'm ready to learn.

@beautifulgoa8469 25 күн бұрын

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

@1183Master 5 ай бұрын

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

@Excel_Tutorial Ай бұрын

Thanks a lot

@syedikramullah1114 11 ай бұрын

Please make a video comparing the two workbooks.

@obsidian_the_exposure 10 ай бұрын

Ready to go 😊

@Excel_Word_Trick_08 11 ай бұрын

Nice video

@sunilbhagwat1060 7 ай бұрын

I'm ready to learn

@1183Master 5 ай бұрын

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

@Excel_Tutorial Ай бұрын

Glad to hear that

@atulkadbe4082 11 ай бұрын

Good sir

@understandthewordsfeelthes3036 5 ай бұрын

Helpful information 👍👍👌👌👌

@Excel_Tutorial 2 ай бұрын

Stay connected

@ajayverma-hn3zt 11 ай бұрын

Yes I m ready

@ryjn6529 8 ай бұрын

I m ready to learn

@user-cy3qe2pu3m 11 ай бұрын

Yes I'm ready

@bhagabanparida2285 8 ай бұрын

I am ready to learn

@rikeshthapa7497 10 ай бұрын

Yes I am ready

@user-zv9qf6fn5n 5 ай бұрын

Helpful information 👍

@Excel_Tutorial 16 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@user-ho1gj4eq4u 3 ай бұрын

thank you sir

@Excel_Tutorial Ай бұрын

Most welcome

@theinfo444 11 ай бұрын

Please make video on Power BI in Excel.

@ImranKhan-xp3nw 9 ай бұрын

I am ready

@snehadey6284 11 ай бұрын

i am ready to learn

@AbhishekMishra-bk2ph Ай бұрын

Yes

@hajizafar 9 ай бұрын

yes

@vishalyadav-bb7tr 21 күн бұрын

Yes, I'm ready

@Excel_Tutorial 17 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@TechTutorRanveer 11 ай бұрын

I'm ready

@hussainmeghani8785 8 ай бұрын

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

@pravingawade9488 10 ай бұрын

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

@Ritikasinha769 9 ай бұрын

Yes ready to leary

@AdityaKumar-hm7cb 2 ай бұрын

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?

@reetakisna 5 ай бұрын

Very nice

@Excel_Tutorial 14 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@Surajk927 11 ай бұрын

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

@budheshwarkullu2301 4 ай бұрын

Ready to Learn.

@Excel_Tutorial 17 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@pradiparya 8 ай бұрын

Ready

@ateeqahmedaa2028 28 күн бұрын

Yes 😊

@Excel_Tutorial 22 күн бұрын

Keep watching the new videos I am uploading.

@prdfgorakhpur5198 6 ай бұрын

yes i am ready

@Excel_Tutorial 13 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@subhamsingh5769 6 ай бұрын

I am learn

@psrinivasulunaik7116 9 ай бұрын

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.

@Firozk91 6 ай бұрын

im ready to learn

@Excel_Tutorial 15 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@jitendrajasani5829 10 ай бұрын

Iam ready

@sanjubadgujar5899 6 ай бұрын

I am really to learn

@Excel_Tutorial Ай бұрын

Keep watching

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

@sonumnd143 5 ай бұрын

Yes ready

@Excel_Tutorial 14 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@TechTutorRanveer 11 ай бұрын

Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya

@fiazghani4727 7 ай бұрын

ready

@BIGVIKGAMING 10 ай бұрын

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

@dhwanitravat306 10 ай бұрын

i am ready

@manojparmar4155 9 ай бұрын

yes rady

@navyakavyars1414 11 ай бұрын

I" am ready

@Tanvxxr7 11 ай бұрын

First comment sir ♥️♥️

@sureshkumarsaini1243 6 ай бұрын

YES I AM READY

@Excel_Tutorial 13 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@organic6195 11 ай бұрын

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

@arg805 Ай бұрын

I AM READY TO LEARN

@Excel_Tutorial 17 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@priyaslife2learn857 6 ай бұрын

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

@GauravKumar-ti4oc 11 ай бұрын

Sir power bi full course laiye plz

@memoriescollection2584 Ай бұрын

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

@AjayKumar-qg8hw 3 ай бұрын

merge formatting shortcut? In Ms word

@purshottamlalverma3083 6 ай бұрын

Yes I am ready to learn msexcel

@Excel_Tutorial Ай бұрын

Keep watching

@ashutoshdixit6781 10 ай бұрын

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

@RizwanAhmad-ss9eh 4 ай бұрын

Yes sir

@Excel_Tutorial 17 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@sunyanakapoor 10 ай бұрын

Imp talk start from here 3:01

@somnathnaskar7393 3 ай бұрын

Can i make it in onedrive

@rockeykumar1300 11 ай бұрын

🎉

@frgf64 7 ай бұрын

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

@Allinone-sh6cj 6 ай бұрын

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

@rajnikeshary4615 5 ай бұрын

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

@zameeransari753 3 ай бұрын

I also have the same question

@yubrajsingh2444 2 ай бұрын

Is this work possiable in excel 2013 ??

@maqsoodahmednagouri3026 Ай бұрын

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

@SHARADTJR 2 ай бұрын

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

@sureshagarwal9391 6 ай бұрын

READY

@Excel_Tutorial 14 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@sameerdixit 10 ай бұрын

windows ke liye aapka app nhi hai ?

@pandupandi_143 10 ай бұрын

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

@mahendrapurohit9091 11 ай бұрын

Sir offer kab aayega ab??

@AbuSam97 10 ай бұрын

Excel ka konsa version hai ye?

@sangeetaprajapati-yi6wl 9 ай бұрын

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

@SanjayKumar-wl2nw 11 ай бұрын

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 9 ай бұрын

Did you get the answer?

@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 6 ай бұрын

Mmm yy in custom number format easy

@santoshnaik2391 5 ай бұрын

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

@mukund6499 9 ай бұрын

2013 me kese hoga

@wanderlust_ansh_5914 4 ай бұрын

Payment date column??

@zameeransari753 3 ай бұрын

What if I don't have the same columns

@jayantirajput3020 4 ай бұрын

ready pls go ahead

@Excel_Tutorial 16 күн бұрын

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzfaq.info/get/bejne/m8WclZN3qKe-Ymg.html)

@biswas696 11 ай бұрын

Mera ek sabal hai kaya aap solve kar sakta hai ?

@skdaveskdave9798 4 ай бұрын

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

@nirbhaykumar31999 4 ай бұрын

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

@amitpalande1168 8 ай бұрын

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

@maqsoodahmednagouri3026 Ай бұрын

or school students details information

@salimali2393 2 ай бұрын

Thanks sir but date format change ho gya

@ccspgawadhesh 5 ай бұрын

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

@ccspgawadhesh 5 ай бұрын

Kindly reply soon.