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.
#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 KZread 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
Пікірлер: 215
Marvellous Sir - Really appreciate the way of teaching and learning studies in Excel.
I am ready your teaching styles are wonderful,
Marvellous Sir...😊
THANK YOU SIR. FROM LAST WEEK I AM LOOKING FOR THE SAME PROBLEM.
I like your all videos and your amazing tricks ❣️❤
Very informative video
Please make a video comparing the two workbooks.
Sir aap bahut achha padate h thank sir
Excellent 👍🎉❤😊
I'm ready to learn. you r great
Very useful Video....Nice method of teaching.
@Excel_Tutorial
Ай бұрын
Thanks a lot
Mast ...Method of Teaching. It's very useful for me.
@Excel_Tutorial
Ай бұрын
Glad to hear that
It's amazing
Nice sir❤
Thank you very much Sir! I have a folder with 4.8k files.. you are a God sent.. 🙏
Ready to go 😊
I am ready to learn.
I'm ready to learn.
Ready to learn
Helpful information 👍👍👌👌👌
@Excel_Tutorial
Ай бұрын
Stay connected
Yes I'm ready 👍
Nice video
Yes, I m ready
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.
Helpful information 👍
@Excel_Tutorial
8 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
multiple workbooks main different column heading hai toh kaise merge kar sakte hai? pls help me.
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?
Yes, ready
Kya ye headers match na hone pe bhi use kr skte h matlab headers name same h but wo idhar udhr honge
What in adding custom cloumn step (Excel.Workbook) if we hv to merge txt filed.....
I'm ready to learn
Please make video on Power BI in Excel.
Yes I'm ready
Yes I m ready
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..
Good sir
i am ready to learn
Yes I am ready
I m ready to learn
I am ready to learn
thank you sir
@Excel_Tutorial
14 күн бұрын
Most welcome, Keep watching the new videos I am uploading.(kzread.info/dash/bejne/ZZWV0LOhh8i7hNI.html)
Sir Hum workbook ko googlesheet main bhi Kar sakti hain kya
Sir excel ka jo 8 hr ka tutorial h usme or paid bale m kya difference hai ?
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
Can I transfer one cell marks or no from 1 workbook to another workbook ...only the cell value
First comment sir ♥️♥️
Very nice
@Excel_Tutorial
6 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
I am ready
Sir apka Jo course hai ms Excel Basic to advance uski practice file kaha se milegi kripya aap mujhe bataiye
I'm ready
Yes, I'm ready
@Excel_Tutorial
9 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
Ready to Learn.
@Excel_Tutorial
8 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
im ready to learn
@Excel_Tutorial
6 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
Sir plz upload how to use form control in details. ..plz plz plz
Hi, I have extra columns in few xcl wrkst, how do we combine the data and have the uniform columns. Plz assist here
@zameeransari753
3 ай бұрын
I also have the same question
Yes ready to leary
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
8 ай бұрын
Did you get the answer?
@azradange9528
6 ай бұрын
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
6 ай бұрын
Mmm yy in custom number format easy
@santoshnaik2391
4 ай бұрын
Ko is it 0:22 ko😅 Oi 😂 oi jij i😅@@rajnipandey9901
yes i am ready
@Excel_Tutorial
5 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
Sir, I want to add one additional column from 5th row onwords.
@Allinone-sh6cj
6 ай бұрын
5th row ko select krke ctrl + press krdo select krne ka shortcut ctrl+spacebar😊
Yes ready
@Excel_Tutorial
6 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
i am ready
I" am ready
YES I AM READY
@Excel_Tutorial
5 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
Iam ready
Yes
Sir power bi full course laiye plz
yes
Yes 😊
@Excel_Tutorial
14 күн бұрын
Keep watching the new videos I am uploading.
windows ke liye aapka app nhi hai ?
merge formatting shortcut? In Ms word
Ready
I am really to learn
@Excel_Tutorial
Ай бұрын
Keep watching
🎉
ready
hello sir, I want to practice on school result and id in excel sheet
Very nice video Csv file se karne par error aa raha hai
Hello sir aapki certificate kese milte hai aur kahanse milte hai?
Is this work possiable in excel 2013 ??
Agar column aage peeche ho ya koi column ho hi na to kese karenge
Excel ka konsa version hai ye?
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
I am learn
yes rady
I AM READY TO LEARN
@Excel_Tutorial
9 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
Sir offer kab aayega ab??
Can i make it in onedrive
Yes I am ready to learn msexcel
@Excel_Tutorial
Ай бұрын
Keep watching
What if I don't have the same columns
Yes sir
@Excel_Tutorial
8 күн бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzread.info/dash/bejne/l5OgxJJ_c6TAYpc.html)
सर किसी pdf file से excel 2007 में data कैसे import करे । जब कि data table format मे नही हो । data rows and column मे है लेकिन lines नही है और हर page ke top aur bottom पर picture hai.
@ccspgawadhesh
5 ай бұрын
Kindly reply soon.
Mera ek sabal hai kaya aap solve kar sakta hai ?
Kya koi bata skta hai ki alag workbook ke data dusre workbook sheet me kaise data la sakte hai 😢
Imp talk start from here 3:01
window 7 how to combine data from multiple excel file kese kare
excel 2016 mein folder select krne k baad combine ,transform database ka option hi nhi aata!!!!!!!!
2013 me kese hoga
अन्ना जी से ही जिनको सीखना हैं वो बताए 😂
खूप छान माहिती , फक्त विनंती जमले तर मुदावर जास्त बोला, व्यफल बडबड पेक्ष
Payment date column??
🙏 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 KZread ne aapki yaad dilayi