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

[@Excel_Tutorial]

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

[@prajaktakale6503]

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

[@amitdoctor3677]

I am ready your teaching styles are wonderful,

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

[@yawarbakht7215]

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

[@beautifulgoa8469]

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

[@vikasguatm8572]

Sir aap bahut achha padate h thank sir

[@PuranKumarBhuwanta]

Great Sir...Thank you

[@auraharry7990]

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

[@surajitmaji1348]

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

[@Excel_Tutorial]

Thanks and welcome 🥳🥳🥳🥳🥳🥳

[@rkgupta8250]

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

[@akshayfuke8411]

IOS me available nhi hai sir skill course application

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

[@1183Master]

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

[@Excel_Tutorial]

Thanks a lot

[@1183Master]

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

[@Excel_Tutorial]

Glad to hear that

[@ramlalmahato3441]

I'm ready to learn. you r great

[@syedikramullah1114]

Please make a video comparing the two workbooks.

[@bijukalita4584]

ready to learn

[@saraiqbal5473]

Good lesson

[@Excel_Tutorial]

Thanks! 😃

[@rickykumar8595]

Yes I'm ready 👍

[@ShakeelKhan-sx7og]

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

[@pasangsherpa6489]

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

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

[@understandthewordsfeelthes3036]

Helpful information 👍👍👌👌👌

[@Excel_Tutorial]

Stay connected

[@snehalwaghmare7387]

Yes. I am ready.

[@saraiqbal5473]

I am going to learn

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

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

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

[@abc123-c4j]

Helpful information 👍

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@Surajk927]

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

[@Seemas1201]

I m ready to learn

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

[@TechTutorRanveer]

Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya

[@girishpatel3653]

Marvellous Sir...😊

[@muhammadatharkhurshid7077]

Yes. Ready.

[@zeeshanahmad4223]

Ready to learn

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

[@priyaslife2learn857]

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

[@BIGVIKGAMING]

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

[@ajaycomputercare]

merge formatting shortcut? In Ms word

[@rajendradeshpande3540]

Yes, I m ready

[@vikas036]

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

[@hussainmeghani8785]

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

[@yubrajsingh2444]

Is this work possiable in excel 2013 ??

[@janityping1938]

Nice sir❤

[@shubhangiupadhyay1206]

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

[@Mannat_str]

First comment sir ♥️♥️

[@somnathnaskar7393]

Can i make it in onedrive

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

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

[@ndtiwariii]

thank you sir

[@Excel_Tutorial]

Most welcome, Keep watching the new videos I am uploading.(kzbin.info/www/bejne/aZLEn4SejMqIitE)

[@pravingawade9488]

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

[@thems444]

Please make video on Power BI in Excel.

[@reetakisna]

Very nice

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@Godlovermukeshjha]

I am ready to learn.

[@infoworldtv7880]

Very informative video

[@sameerdixit]

windows ke liye aapka app nhi hai ?

[@deepeshsarathe529]

Excellent 👍🎉❤😊

[@obsidian_the_exposure]

Ready to go 😊

[@rajusawant7209]

I am ready to learn EXCEL

[@maqsoodahmednagouri3026]

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

[@KaaliBanga]

Yes ready

[@Firozk91]

im ready to learn

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@CleverjitEngti]

Yes I'm ready

[@memoriescollection2584]

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

[@nimaydey6466]

I am ready

[@binaybaranwalbaranwal7059]

Yes, ready

[@atulkadbe4082]

Good sir

[@prdfgorakhpur5198]

yes i am ready

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@Excel_Word_Trick_08]

Nice video

[@sureshkumarsaini1243]

YES I AM READY

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@syedikramullah1114]

It's amazing

[@sanjibmondal5906]

Mhuje ek help chayee

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

[@narayanswain3948]

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.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@kalpeshshewale7137]

I am ready

[@ateeqahmedaa2028]

Yes 😊

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@budheshwarkullu2301]

Ready to Learn.

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@purshottamlalverma3083]

Yes I am ready to learn msexcel

[@Excel_Tutorial]

Keep watching

[@snehadey6284]

i am ready to learn

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

[@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.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)

[@AbuSam97]

Excel ka konsa version hai ye?

[@SHARADTJR]

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

[@sanjubadgujar5899]

I am really to learn

[@Excel_Tutorial]

Keep watching

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

[@pandupandi_143]

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

[@pujamurmu5450]

❤❤❤❤❤❤

[@Excel_Tutorial]

Thanks for watching 🥳🥳🥳🥳🥳🥳🥳🥳

[@zameeransari753]

What if I don't have the same columns

[@suganbajracharya5067]

If not then power query doesn't work

[@sunyanakapoor]

Imp talk start from here 3:01

[@jitendrajasani5829]

Iam ready

[@mahendrapurohit9091]

Sir offer kab aayega ab??

[@GauravKumar-ti4oc]

Sir power bi full course laiye plz

[@Ritikasinha769]

Yes ready to leary

[@ReviewTake-fn2im]

Sir mere "From file " Ke section me "from pdf" Ka option nai aa raha hai jiske wjh se filr ka pdf show nahi ho pa raha yaha.. Plzz help kijiye kaise ayega wo.. 2019 Excel use kar raha hu mai.

[@sangeetaprajapati-yi6wl]

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