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.skillcourse.in/webinars/
#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 UA-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/

[@yawarbakht7215]

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

[@amitdoctor3677]

I am ready your teaching styles are wonderful,

[@vikasguatm8572]

Sir aap bahut achha padate h thank sir

[@shubhangiupadhyay1206]

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

[@girishpatel3653]

Marvellous Sir...😊

[@auraharry7990]

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

[@infoworldtv7880]

Very informative video

[@ramlalmahato3441]

I'm ready to learn. you r great

[@deepeshsarathe529]

Excellent 👍🎉❤😊

[@beautifulgoa8469]

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

[@syedikramullah1114]

Please make a video comparing the two workbooks.

[@1183Master]

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

[@Excel_Tutorial]

Thanks a lot

[@hussainmeghani8785]

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

[@syedikramullah1114]

It's amazing

[@pravingawade9488]

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

[@1183Master]

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

[@Excel_Tutorial]

Glad to hear that

[@janityping1938]

Nice sir❤

[@Godlovermukeshjha]

I am ready to learn.

[@rickykumar8595]

Yes I'm ready 👍

[@zeeshanahmad4223]

Ready to learn

[@Surajk927]

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

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

[@parveshdobriyal6078]

I'm ready to learn.

[@rajendradeshpande3540]

Yes, I m ready

[@obsidian_the_exposure]

Ready to go 😊

[@binaybaranwalbaranwal7059]

Yes, ready

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

[@Excel_Word_Trick_08]

Nice video

[@sunilbhagwat1060]

I'm ready to learn

[@understandthewordsfeelthes3036]

Helpful information 👍👍👌👌👌

[@Excel_Tutorial]

Stay connected

[@TechTutorRanveer]

Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya

[@priyaslife2learn857]

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

[@muhammadumershivaniaboobak4416]

Yes I am ready

[@user-zv9qf6fn5n]

Helpful information 👍

[@Excel_Tutorial]

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

[@atulkadbe4082]

Good sir

[@ryjn6529]

I m ready to learn

[@ajayverma-hn3zt]

Yes I m ready

[@bhagabanparida2285]

I am ready to learn

[@user-cy3qe2pu3m]

Yes I'm ready

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

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

[@snehadey6284]

i am ready to learn

[@ashutoshdixit6781]

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

[@thems444]

Please make video on Power BI in Excel.

[@BIGVIKGAMING]

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

[@organic6195]

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

[@user-ho1gj4eq4u]

thank you sir

[@Excel_Tutorial]

Most welcome

[@shashikantchaudhari1378]

I am ready

[@AjayKumar-qg8hw]

merge formatting shortcut? In Ms word

[@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.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)

[@AbhishekMishra-bk2ph]

Yes

[@TechTutorRanveer]

I'm ready

[@reetakisna]

Very nice

[@Excel_Tutorial]

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

[@Ritikasinha769]

Yes ready to leary

[@rajnikeshary4615]

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

[@zameeransari753]

I also have the same question

[@wajahatsaeed2946]

Yes i am ready

[@Excel_Tutorial]

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

[@budheshwarkullu2301]

Ready to Learn.

[@Excel_Tutorial]

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

[@hajizafar]

yes

[@Tanvxxr7]

First comment sir ♥️♥️

[@sangeetaprajapati-yi6wl]

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

[@prdfgorakhpur5198]

yes i am ready

[@Excel_Tutorial]

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

[@maqsoodahmednagouri3026]

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

[@Firozk91]

im ready to learn

[@Excel_Tutorial]

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

[@yubrajsingh2444]

Is this work possiable in excel 2013 ??

[@sonumnd143]

Yes ready

[@Excel_Tutorial]

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

[@memoriescollection2584]

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

[@ateeqahmedaa2028]

Yes 😊

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@somnathnaskar7393]

Can i make it in onedrive

[@sureshkumarsaini1243]

YES I AM READY

[@Excel_Tutorial]

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

[@pandupandi_143]

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

[@sunyanakapoor]

Imp talk start from here 3:01

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

[@dhwanitravat306]

i am ready

[@jitendrajasani5829]

Iam ready

[@sanjubadgujar5899]

I am really to learn

[@Excel_Tutorial]

Keep watching

[@GauravKumar-ti4oc]

Sir power bi full course laiye plz

[@pradiparya]

Ready

[@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.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)

[@navyakavyars1414]

I" am ready

[@sameerdixit]

windows ke liye aapka app nhi hai ?

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

[@AbuSam97]

Excel ka konsa version hai ye?

[@manojparmar4155]

yes rady

[@fiazghani4727]

ready

[@SHARADTJR]

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

[@rockeykumar1300]

🎉

[@purshottamlalverma3083]

Yes I am ready to learn msexcel

[@Excel_Tutorial]

Keep watching

[@mahendrapurohit9091]

Sir offer kab aayega ab??

[@mukund6499]

2013 me kese hoga

[@zameeransari753]

What if I don't have the same columns

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

[@deepikapathak4134]

Bro close and load to ka option nhi aaraha hai

[@RizwanAhmad-ss9eh]

Yes sir

[@Excel_Tutorial]

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

[@skdaveskdave9798]

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

[@NIKHILLOKHANDE-nk9sl]

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

[@biswas696]

Mera ek sabal hai kaya aap solve kar sakta hai ?

[@wanderlust_ansh_5914]

Payment date column??

[@ccspgawadhesh]

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

[@ccspgawadhesh]

Kindly reply soon.

[@sureshagarwal9391]

READY

[@Excel_Tutorial]

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