Тёмный

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

Excel Tutorial
Подписаться 301 тыс.
Просмотров 157 тыс.
50% 1

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 RU-vid 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

Опубликовано:

 

20 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 226   
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
@amitdoctor3677
@amitdoctor3677 6 месяцев назад
I am ready your teaching styles are wonderful,
@yawarbakht7215
@yawarbakht7215 10 месяцев назад
Marvellous Sir - Really appreciate the way of teaching and learning studies in Excel.
@beautifulgoa8469
@beautifulgoa8469 2 месяца назад
Thank you very much Sir! I have a folder with 4.8k files.. you are a God sent.. 🙏
@auraharry7990
@auraharry7990 10 месяцев назад
THANK YOU SIR. FROM LAST WEEK I AM LOOKING FOR THE SAME PROBLEM.
@ShakeelKhan-sx7og
@ShakeelKhan-sx7og 5 часов назад
Sir ji practice file bhi diya kro taki hum bhi try kar ske
@vikasguatm8572
@vikasguatm8572 Год назад
Sir aap bahut achha padate h thank sir
@pigeonshow77
@pigeonshow77 2 часа назад
I'm ready to learn
@Seemas1201
@Seemas1201 4 дня назад
I m ready to learn
@muhammadumershivaniaboobak4416
@muhammadumershivaniaboobak4416 Месяц назад
Yes I am ready
@syedikramullah1114
@syedikramullah1114 Год назад
Please make a video comparing the two workbooks.
@sourabh372
@sourabh372 2 месяца назад
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..
@1183Master
@1183Master 7 месяцев назад
Mast ...Method of Teaching. It's very useful for me.
@Excel_Tutorial
@Excel_Tutorial 3 месяца назад
Glad to hear that
@AdityaKumar-hm7cb
@AdityaKumar-hm7cb 3 месяца назад
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?
@vishalyadav-bb7tr
@vishalyadav-bb7tr 2 месяца назад
Yes, I'm ready
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@user-ii9il4xo6o
@user-ii9il4xo6o 17 дней назад
Yes ready
@sunyanakapoor
@sunyanakapoor Год назад
Imp talk start from here 3:01
@1183Master
@1183Master 7 месяцев назад
Very useful Video....Nice method of teaching.
@Excel_Tutorial
@Excel_Tutorial 3 месяца назад
Thanks a lot
@user-ho1gj4eq4u
@user-ho1gj4eq4u 4 месяца назад
thank you sir
@Excel_Tutorial
@Excel_Tutorial 3 месяца назад
Most welcome
@girishpatel3653
@girishpatel3653 10 месяцев назад
Marvellous Sir...😊
@BIGVIKGAMING
@BIGVIKGAMING 11 месяцев назад
Sir excel ka jo 8 hr ka tutorial h usme or paid bale m kya difference hai ?
@chef2460093
@chef2460093 27 дней назад
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
@ramlalmahato3441
@ramlalmahato3441 7 месяцев назад
I'm ready to learn. you r great
@rickykumar8595
@rickykumar8595 5 месяцев назад
Yes I'm ready 👍
@psrinivasulunaik7116
@psrinivasulunaik7116 10 месяцев назад
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.
@AbhishekMishra-bk2ph
@AbhishekMishra-bk2ph 2 месяца назад
Yes
@namitatalukdar1958
@namitatalukdar1958 Месяц назад
Ready to learn
@rosariocoutinho8690
@rosariocoutinho8690 2 месяца назад
I am ready to learn
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@shashikantchaudhari1378
@shashikantchaudhari1378 8 месяцев назад
I am ready
@shubhangiupadhyay1206
@shubhangiupadhyay1206 11 месяцев назад
I like your all videos and your amazing tricks ❣️❤
@understandthewordsfeelthes3036
@understandthewordsfeelthes3036 6 месяцев назад
Helpful information 👍👍👌👌👌
@Excel_Tutorial
@Excel_Tutorial 3 месяца назад
Stay connected
@memoriescollection2584
@memoriescollection2584 3 месяца назад
Sir plz upload how to use form control in details. ..plz plz plz
@ateeqahmedaa2028
@ateeqahmedaa2028 2 месяца назад
Yes 😊
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Keep watching the new videos I am uploading.
@dayanidhimishra4980
@dayanidhimishra4980 Месяц назад
yes
@binaybaranwalbaranwal7059
@binaybaranwalbaranwal7059 4 месяца назад
Yes, ready
@SanjayKumar-wl2nw
@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
@rajnipandey9901 10 месяцев назад
Did you get the answer?
@azradange9528
@azradange9528 8 месяцев назад
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
@Allinone-sh6cj 7 месяцев назад
Mmm yy in custom number format easy
@santoshnaik2391
@santoshnaik2391 6 месяцев назад
Ko is it 0:22 ko😅 Oi 😂 oi jij i😅​@@rajnipandey9901
@arg805
@arg805 3 месяца назад
I AM READY TO LEARN
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@amitpalande1168
@amitpalande1168 9 месяцев назад
खूप छान माहिती , फक्त विनंती जमले तर मुदावर जास्त बोला, व्यफल बडबड पेक्ष
@infoworldtv7880
@infoworldtv7880 Год назад
Very informative video
@rajendradeshpande3540
@rajendradeshpande3540 9 месяцев назад
Yes, I m ready
@frgf64
@frgf64 9 месяцев назад
Sir, I want to add one additional column from 5th row onwords.
@Allinone-sh6cj
@Allinone-sh6cj 7 месяцев назад
5th row ko select krke ctrl + press krdo select krne ka shortcut ctrl+spacebar😊
@user-zv9qf6fn5n
@user-zv9qf6fn5n 6 месяцев назад
Helpful information 👍
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@janityping1938
@janityping1938 Год назад
Nice sir❤
@budheshwarkullu2301
@budheshwarkullu2301 5 месяцев назад
Ready to Learn.
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@parveshdobriyal6078
@parveshdobriyal6078 10 месяцев назад
I'm ready to learn.
@Godlovermukeshjha
@Godlovermukeshjha 11 месяцев назад
I am ready to learn.
@thems444
@thems444 Год назад
Please make video on Power BI in Excel.
@mukeshkrgupta3412
@mukeshkrgupta3412 Год назад
🙏 sir aap best teacher hai. Aapse request hai ki aap video ko idhar udhar ki jyada bato se video lamba na kare Thora time bache. Detailed video ke liye thankyou again. Maine aapki bahut videos kafi time pahle dekha hai Aaj fir RU-vid ne aapki yaad dilayi
@purshottamlalverma3083
@purshottamlalverma3083 7 месяцев назад
Yes I am ready to learn msexcel
@Excel_Tutorial
@Excel_Tutorial 3 месяца назад
Keep watching
@Tanvxxr7
@Tanvxxr7 Год назад
First comment sir ♥️♥️
@Surajk927
@Surajk927 Год назад
Kya ye headers match na hone pe bhi use kr skte h matlab headers name same h but wo idhar udhr honge
@syedikramullah1114
@syedikramullah1114 Год назад
It's amazing
@AjayKumar-qg8hw
@AjayKumar-qg8hw 4 месяца назад
merge formatting shortcut? In Ms word
@wajahatsaeed2946
@wajahatsaeed2946 7 месяцев назад
Yes i am ready
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@organic6195
@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
@deepeshsarathe529
@deepeshsarathe529 11 месяцев назад
Excellent 👍🎉❤😊
@SHARADTJR
@SHARADTJR 4 месяца назад
Very nice video Csv file se karne par error aa raha hai
@RizwanAhmad-ss9eh
@RizwanAhmad-ss9eh 5 месяцев назад
Yes sir
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@prdfgorakhpur5198
@prdfgorakhpur5198 7 месяцев назад
yes i am ready
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@obsidian_the_exposure
@obsidian_the_exposure Год назад
Ready to go 😊
@ajayverma-hn3zt
@ajayverma-hn3zt Год назад
Yes I m ready
@saimtechdc5109
@saimtechdc5109 3 дня назад
If every different range one 100 another one is 150 name also different
@TechTutorRanveer
@TechTutorRanveer Год назад
Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya
@user-cy3qe2pu3m
@user-cy3qe2pu3m Год назад
Yes I'm ready
@pravingawade9488
@pravingawade9488 Год назад
multiple workbooks main different column heading hai toh kaise merge kar sakte hai? pls help me.
@sureshkumarsaini1243
@sureshkumarsaini1243 7 месяцев назад
YES I AM READY
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@hussainmeghani8785
@hussainmeghani8785 9 месяцев назад
What in adding custom cloumn step (Excel.Workbook) if we hv to merge txt filed.....
@atulkadbe4082
@atulkadbe4082 Год назад
Good sir
@SurprisedBigWaterfall-yd1ln
@SurprisedBigWaterfall-yd1ln 4 месяца назад
Ready
@Excel_Word_Trick_08
@Excel_Word_Trick_08 Год назад
Nice video
@reetakisna
@reetakisna 7 месяцев назад
Very nice
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@maqsoodahmednagouri3026
@maqsoodahmednagouri3026 3 месяца назад
hello sir, I want to practice on school result and id in excel sheet
@yubrajsingh2444
@yubrajsingh2444 4 месяца назад
Is this work possiable in excel 2013 ??
@subhendu012
@subhendu012 11 месяцев назад
i am ready to learn
@priyaslife2learn857
@priyaslife2learn857 7 месяцев назад
Can I transfer one cell marks or no from 1 workbook to another workbook ...only the cell value
@Firozk91
@Firozk91 7 месяцев назад
im ready to learn
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@ashutoshdixit6781
@ashutoshdixit6781 Год назад
Sir apka Jo course hai ms Excel Basic to advance uski practice file kaha se milegi kripya aap mujhe bataiye
@nirbhaykumar31999
@nirbhaykumar31999 5 месяцев назад
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
@sanjubadgujar5899
@sanjubadgujar5899 7 месяцев назад
I am really to learn
@Excel_Tutorial
@Excel_Tutorial 3 месяца назад
Keep watching
@Ritikasinha769
@Ritikasinha769 10 месяцев назад
Yes ready to leary
@TechTutorRanveer
@TechTutorRanveer Год назад
I'm ready
@sadiqinbox
@sadiqinbox 4 месяца назад
ready
@zameeransari753
@zameeransari753 4 месяца назад
What if I don't have the same columns
@somnathnaskar7393
@somnathnaskar7393 4 месяца назад
Can i make it in onedrive
@jayantirajput3020
@jayantirajput3020 6 месяцев назад
ready pls go ahead
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@rajnikeshary4615
@rajnikeshary4615 6 месяцев назад
Hi, I have extra columns in few xcl wrkst, how do we combine the data and have the uniform columns. Plz assist here
@zameeransari753
@zameeransari753 4 месяца назад
I also have the same question
@muhammedriaz3086
@muhammedriaz3086 3 дня назад
I am getting an error while combining the file. How to fix it? Please advise
@Excel_Tutorial
@Excel_Tutorial 2 дня назад
Sir please watch the whole video carefully once. 😊
@deepikapathak4134
@deepikapathak4134 Месяц назад
Bro close and load to ka option nhi aaraha hai
@dhwanitravat306
@dhwanitravat306 Год назад
i am ready
@sureshagarwal9391
@sureshagarwal9391 7 месяцев назад
READY
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@jitendrajasani5829
@jitendrajasani5829 Год назад
Iam ready
@GauravKumar-ti4oc
@GauravKumar-ti4oc Год назад
Sir power bi full course laiye plz
@skdaveskdave9798
@skdaveskdave9798 5 месяцев назад
window 7 how to combine data from multiple excel file kese kare
@ccspgawadhesh
@ccspgawadhesh 7 месяцев назад
सर किसी pdf file से excel 2007 में data कैसे import करे । जब कि data table format मे नही हो । data rows and column मे है लेकिन lines नही है और हर page ke top aur bottom पर picture hai.
@ccspgawadhesh
@ccspgawadhesh 7 месяцев назад
Kindly reply soon.
@sandeeppathak522
@sandeeppathak522 4 месяца назад
इस काम को गूगल शीट और ड्राइव में कैसे करेंगे। मान लीजिए ड्राइव में एक फोल्डर है और 12 csv फ़ाइल है उस 12फ़ाइल को अलग अलग शीट में लिंक करना है और फिर अगले दिन उन 12 csv फ़ाइल को रिप्लेस कर देना है। इस तरह से अगर रोज करना है तो क्या गूगल शीट में संभव है।
@sangeetaprajapati-yi6wl
@sangeetaprajapati-yi6wl 10 месяцев назад
Agar column aage peeche ho ya koi column ho hi na to kese karenge
@sameerdixit
@sameerdixit Год назад
windows ke liye aapka app nhi hai ?
@NIKHILLOKHANDE-nk9sl
@NIKHILLOKHANDE-nk9sl 3 месяца назад
excel 2016 mein folder select krne k baad combine ,transform database ka option hi nhi aata!!!!!!!!
@manojparmar4155
@manojparmar4155 11 месяцев назад
yes rady
@SaranSafar.
@SaranSafar. 10 месяцев назад
अन्ना जी से ही जिनको सीखना हैं वो बताए 😂
Далее
МАМА И ВАЛДБЕРИС
00:48
Просмотров 590 тыс.