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 RUclips 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,

[@beautifulgoa8469]

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

[@PuranKumarBhuwanta]

Great Sir...Thank you

[@yawarbakht7215]

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

[@vikasguatm8572]

Sir aap bahut achha padate h thank sir

[@hemantramteke]

Ready to learn

[@rkgupta8250]

Love You Satish..........

[@prajaktakale6503]

Thank you Sir for this video however if data has different headers how the consolidation can be done

[@luckyearninginfoodisha9766]

Thanks sir for this video

[@auraharry7990]

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

[@SceneStealers919]

I am ready sir.

[@bijukalita4584]

ready to learn

[@1183Master]

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

[@Excel_Tutorial]

Glad to hear that

[@surajitmaji1348]

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

[@Excel_Tutorial]

Thanks and welcome 🥳🥳🥳🥳🥳🥳

[@1183Master]

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

[@Excel_Tutorial]

Thanks a lot

[@saraiqbal5473]

Good lesson

[@Excel_Tutorial]

Thanks! 😃

[@understandthewordsfeelthes3036]

Helpful information 👍👍👌👌👌

[@Excel_Tutorial]

Stay connected

[@rickykumar8595]

Yes I'm ready 👍

[@snehalwaghmare7387]

Yes. I am ready.

[@naraharigodase9860]

This is a fantastic!!!! I have tried it and my data got transferred in to one file.
However in folder when I added new workbooks, it doesn't get transferred automatically.... please advise for the same....

[@muhammadatharkhurshid7077]

Yes. Ready.

[@ramlalmahato3441]

I'm ready to learn. you r great

[@saraiqbal5473]

I am going to learn

[@upendraprasad422]

yes

[@abc123-c4j]

Helpful information 👍

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@girishpatel3653]

Marvellous Sir...😊

[@Seemas1201]

I m ready to learn

[@zeeshanahmad4223]

Ready to learn

[@akshayfuke8411]

IOS me available nhi hai sir skill course application

[@rajendradeshpande3540]

Yes, I m ready

[@KaaliBanga]

Yes ready

[@janityping1938]

Nice sir❤

[@syedikramullah1114]

Please make a video comparing the two workbooks.

[@CleverjitEngti]

Yes I'm ready

[@shubhangiupadhyay1206]

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

[@TechTutorRanveer]

Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya

[@binaybaranwalbaranwal7059]

Yes, ready

[@obsidian_the_exposure]

Ready to go 😊

[@infoworldtv7880]

Very informative video

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

[@BIGVIKGAMING]

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

[@ndtiwariii]

thank you sir

[@Excel_Tutorial]

Most welcome, Keep watching the new videos I am uploading.(ruclips.net/video/3aanQhWeUTo/видео.html)

[@ateeqahmedaa2028]

Yes 😊

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@deepeshsarathe529]

Excellent 👍🎉❤😊

[@Surajk927]

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

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

[@ShakeelKhan-sx7og]

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

[@somnathnaskar7393]

Can i make it in onedrive

[@Mannat_str]

First comment sir ♥️♥️

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

[@narayanswain3948]

Ready.....

[@vikas036]

Data field similar na hone per kya karenge agar file combined karni hai

[@reetakisna]

Very nice

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@atulkadbe4082]

Good sir

[@kalpeshshewale7137]

I am ready

[@nimaydey6466]

I am ready

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

[@sureshkumarsaini1243]

YES I AM READY

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@yubrajsingh2444]

Is this work possiable in excel 2013 ??

[@Godlovermukeshjha]

I am ready to learn.

[@syedikramullah1114]

It's amazing

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

[@sanjibmondal5906]

Mhuje ek help chayee

[@priyaslife2learn857]

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

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

[@sameerdixit]

windows ke liye aapka app nhi hai ?

[@pujamurmu5450]

❤❤❤❤❤❤

[@Excel_Tutorial]

Thanks for watching 🥳🥳🥳🥳🥳🥳🥳🥳

[@prdfgorakhpur5198]

yes i am ready

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

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

[@ashutoshdixit6781]

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

[@Excel_Word_Trick_08]

Nice video

[@Firozk91]

im ready to learn

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@memoriescollection2584]

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

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

[@thems444]

Please make video on Power BI in Excel.

[@hussainmeghani8785]

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

[@ajaycomputercare]

merge formatting shortcut? In Ms word

[@TechTutorRanveer]

I'm ready

[@sonumnd143]

Yes ready

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@maqsoodahmednagouri3026]

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

[@budheshwarkullu2301]

Ready to Learn.

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

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

[@pravingawade9488]

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

[@AbuSam97]

Excel ka konsa version hai ye?

[@nagamanickamarthanariraju7891]

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.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@Sunainasuneja1]

Imp talk start from here 3:01

[@pasangsherpa6489]

Hi, here one clarification, if each workbook has multiple sheet then how we combine, pls advise

[@TusharsVlogs888]

Ye ek mahenga sawal hai bhai 😅

[@snehadey6284]

i am ready to learn

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

[@jitendrajasani5829]

Iam ready

[@purshottamlalverma3083]

Yes I am ready to learn msexcel

[@Excel_Tutorial]

Keep watching

[@pandupandi_143]

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

[@QariQuranSunnah]

Yes

[@Ritikasinha769]

Yes ready to leary

[@RizwanAhmad-ss9eh]

Yes sir

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)

[@sanjubadgujar5899]

I am really to learn

[@Excel_Tutorial]

Keep watching

[@rajusawant7209]

I am ready to learn EXCEL

[@SHARADTJR]

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