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.
Attend Satish sir's Online Webinar Free: courses.skillc...
#exceltricks
#excelpowerquery
#exceltutorial
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_c...
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...
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/le...
------------------------------------------------------------------------------------------------------------------------------
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 TH-cam 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

[@Excel_Tutorial]

Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

[@amitdoctor3677]

I am ready your teaching styles are wonderful,

[@yawarbakht7215]

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

[@sachinbhalla767]

Agar jun ke file same folder main add karege to kya it append automatically to the master file or we can follow the the whole process again

[@snehalwaghmare7387]

Yes. I am ready.

[@darpanchavda8017]

I HAVE ONE QUESTION SIR , IF I HAVE EXPENSES DATA, MONTH DATA IN ONE COLUM AND I WANT REPORT MONTH WISE WITHOUT PIVOT TABLE IN COLUMER FORM.

[@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?

[@psrinivasulunaik7116]

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.

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

[@surajitmaji1348]

Bahut accha.. Thankyou for this video....

[@Excel_Tutorial]

Thanks and welcome 🥳🥳🥳🥳🥳🥳

[@syedikramullah1114]

Please make a video comparing the two workbooks.

[@sanjibmondal5906]

Mere pass ek data hai jo is tara hai ek he excel k sheet main mera book ka data, aur gst portal se 2A, 2B ka data hai, ab mhuje data me se ye karna hai k agar tino me check kare agar mil jata hai tho match' agar books main nai magar 2A aur 2B hai tho not found in books, is tara 2b nahi magar books Aur 2A main tho not in 2b is ka formula kasi hoga?
,

[@chef2460093]

Sir ek colum main drop down se month select Kiya hain muje us sheet ki date bhi automatically change ho jaye uske liye kya karna chaiye

[@ShakeelKhan-sx7og]

Sir ji practice file bhi diya kro taki hum bhi try kar ske

[@1183Master]

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

[@Excel_Tutorial]

Glad to hear that

[@frgf64]

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

[@Allinone-sh6cj]

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

[@mohammedabdulhaleem7194]

i am ready to learn

[@yubrajsingh2444]

Is this work possiable in excel 2013 ??

[@maqsoodahmednagouri3026]

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

[@1183Master]

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

[@Excel_Tutorial]

Thanks a lot

[@priyaslife2learn857]

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

[@TechTutorRanveer]

Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya

[@hussainmeghani8785]

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

[@ramlalmahato3441]

I'm ready to learn. you r great

[@pigeonshow77]

I'm ready to learn

[@memoriescollection2584]

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

[@somnathnaskar7393]

Can i make it in onedrive

[@thems444]

Please make video on Power BI in Excel.

[@zameeransari753]

What if I don't have the same columns

[@girishpatel3653]

Marvellous Sir...😊

[@nishikant541]

Yes

[@rajusawant7209]

I am ready to learn EXCEL

[@deepikapathak4134]

Bro close and load to ka option nhi aaraha hai

[@dayanidhimishra4980]

yes

[@sanjibmondal5906]

Mhuje ek help chayee

[@muhammedriaz3086]

I am getting an error while combining the file. How to fix it? Please advise

[@Excel_Tutorial]

Sir please watch the whole video carefully once. 😊

[@arg805]

I AM READY TO LEARN

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@binaybaranwalbaranwal7059]

Yes, ready

[@understandthewordsfeelthes3036]

Helpful information 👍👍👌👌👌

[@Excel_Tutorial]

Stay connected

[@KaaliBanga]

Yes ready

[@zeeshanahmad4223]

Ready to learn

[@ARTAGRA-mi8ii]

Ready

[@budheshwarkullu2301]

Ready to Learn.

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@skdaveskdave9798]

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

[@sameerdixit]

windows ke liye aapka app nhi hai ?

[@rajendrakumarrajbhar]

Yes

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@sangeetaprajapati-yi6wl]

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

[@vishalyadav-bb7tr]

Yes, I'm ready

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@SanjayKumar-wl2nw]

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]

Did you get the answer?

[@azradange9528]

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]

Mmm yy in custom number format easy

[@santoshnaik2391]

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

[@ryjn6529]

I m ready to learn

[@SHARADTJR]

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

[@SurprisedBigWaterfall-yd1ln]

Ready

[@infoworldtv7880]

Very informative video

[@ZubairAhmed-k8b]

thank you sir

[@Excel_Tutorial]

Most welcome

[@purshottamlalverma3083]

Yes I am ready to learn msexcel

[@Excel_Tutorial]

Keep watching

[@atulpandey632]

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

[@PushpaVaskar-r3y]

I am ready

[@rikeshthapa7497]

Yes I am ready

[@AbuSam97]

Excel ka konsa version hai ye?

[@sandeeppathak522]

इस काम को गूगल शीट और ड्राइव में कैसे करेंगे।
मान लीजिए ड्राइव में एक फोल्डर है और 12 csv फ़ाइल है उस 12फ़ाइल को अलग अलग शीट में लिंक करना है और फिर अगले दिन उन 12 csv फ़ाइल को रिप्लेस कर देना है। इस तरह से अगर रोज करना है तो क्या गूगल शीट में संभव है।

[@RizwanAhmad-ss9eh]

Yes sir

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@nirbhaykumar31999]

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

[@hiteshkumarprajapati5006]

I m ready to learn

[@sadiqinbox]

ready

[@pandupandi_143]

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

[@NIKHILLOKHANDE-nk9sl]

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

[@wajahatsaeed2946]

Yes i am ready

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@syedikramullah1114]

It's amazing

[@deepeshsarathe529]

Excellent 👍🎉❤😊

[@Ritikasinha769]

Yes ready to leary

[@sureshkumarsaini1243]

YES I AM READY

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@atulkadbe4082]

Good sir

[@obsidian_the_exposure]

Ready to go 😊

[@Excel_Word_Trick_08]

Nice video

[@biswas696]

Mera ek sabal hai kaya aap solve kar sakta hai ?

[@sonumnd143]

Yes ready

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@reetakisna]

Very nice

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@sanjubadgujar5899]

I am really to learn

[@Excel_Tutorial]

Keep watching

[@kalpeshshewale7137]

I am ready

[@TechTutorRanveer]

I'm ready

[@amitpalande1168]

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

[@Tanvxxr7]

First comment sir ♥️♥️

[@sureshagarwal9391]

READY

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@jayantirajput3020]

ready pls go ahead

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@mahendrapurohit9091]

Sir offer kab aayega ab??

[@mukund6499]

2013 me kese hoga

[@jitendrajasani5829]

Iam ready

[@varungautam9743]

Yes

[@maqsoodahmednagouri3026]

or school students details information

[@navyakavyars1414]

I" am ready

[@rajkumarpanwar7396]

Ready

[@amitaryan6792]

Kya bana raha h bhai..har koi USA ka map hi dikhate h...India ka map nhi h kya..

[@SaranSafar.]

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

[@rockeykumar1300]

🎉

[@vkeditor12]

First comment for vk editor

[@dinabandhudas9598]

IAM READY TO LERN

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)

[@QariQuranSunnah]

Yes

[@TheAbdulkhan]

yes

[@thems444]

Please make video on Power BI in Excel.

[@nagamanickamarthanariraju7891]

Ready