4.8 Combine Multiple Excel files in Power Query | Advanced Excel-Power Query Tutorials Pavan Lalwani
ฝัง
- เผยแพร่เมื่อ 5 มิ.ย. 2022
- 4.8 Combine Multiple Excel files in Power Query | Advanced Excel-Power Query Tutorials Pavan Lalwani
"Namaste India! Are you tired of spending countless hours manually preparing your data for analysis in Microsoft Excel? Introducing the game-changing solution that will revolutionize the way you work with data - Microsoft Excel Power Query!
"नमस्ते भारत! क्या आप माइक्रोसॉफ्ट एक्सेल में विश्लेषण के लिए अपने डेटा को मैन्युअल रूप से तैयार करने में अनगिनत घंटे खर्च करने से थक गए हैं? गेम-चेंजिंग सॉल्यूशन पेश करते हैं जो आपके डेटा के साथ काम करने के तरीके में क्रांति लाएगा - माइक्रोसॉफ्ट एक्सेल पावर क्वेरी!
GROW WITH US!
🎥 Join our Webinar’s:-
✔️webinarkit.com/webinar/regist...
🌍 Explore our Courses 📊:-
✔️pavanlalwani.com
📝Internship Enquiry
✔️docs.google.com/forms/d/e/1FA...
CONNECT WITH US!
🐦 Twitter:- ✔️ / lalwanipavan
💼 LinkedIn:- ✔️ / pavanlalwani
📸 Instagram:- ✔️ / pavanlalwani
🕸 Facebook:- ✔️ / pavanlalwanitrainer
📟Telegram:- ✔️t.me/powerbi_tutorial_1
*CHECK THIS OUT!
🎬 Studio Gear:- ✔️amzn.to/3Yn5GFW
💻 Office Box:- ✔️amzn.to/3Hzu2W5
🎧 Personal Mantra:- ✔️amzn.to/3Xcnhzk
🏍 Travel Gear:- ✔️amzn.to/3JILgmA
🎻 Amazing Music:- ✔️amzn.to/3X57l1W
📖 Lovely Books:- ✔️amzn.to/3wWYVPp
* The links above are affiliate links, which means that if you make a purchase using these links, we will receive a small commission at no additional cost to you. It encourages us to keep making videos!
😍 Thank you for being a part of this channel and for your continued support!
💾 Data Download :
=====================================
✔️Download (Zip) : drive.google.com/file/d/192kd...
✔️Download Link :
drive.google.com/drive/folder...
With this dual language course in Hindi and English, you'll learn how to quickly and easily connect to a wide range of data sources, clean, shape, and transform your data, and load it into your Excel workbook for analysis and reporting.
इस हिंदी और अंग्रेजी दोहरी भाषा पाठ्यक्रम के साथ, आप सीखेंगे कि डेटा स्रोतों की एक विस्तृत श्रृंखला से जल्दी और आसानी से कैसे जुड़ें, अपने डेटा को साफ करें, आकार दें और रूपांतरित करें, और विश्लेषण और रिपोर्टिंग के लिए इसे अपनी एक्सेल कार्यपुस्तिका में लोड करें।
Say goodbye to the tedious and time-consuming data preparation process, and hello to more time for analysis and insights! Join us now for a comprehensive and easy-to-follow journey into the world of Power Query!
थकाऊ और समय लेने वाले को अलविदा कहें डेटा तैयार करने की प्रक्रिया, और विश्लेषण और अंतर्दृष्टि के लिए और अधिक समय देने के लिए नमस्कार! Power Query की दुनिया में एक व्यापक और अनुसरण करने में आसान यात्रा के लिए अभी हमसे जुड़ें!
"With our comprehensive Excel Power Query videos, you'll receive step-by-step tutorials that cover everything from the basics to advanced Power Query techniques. Our Excel Power Query tutorial covers all the essential functions and features of the tool, as well as some of the most advanced Power Query techniques for transforming data. From Excel basics for beginners to advanced Excel in Hindi, we've got you covered. Plus, our expert Excel tutoring in Hindi will give you tips and tricks to help you master Excel like a pro! Looking for Excel functions, or simply want to brush up Excel skills, our Excel tutorial series is the perfect resource. So join us now and transform your data like never before with Power Query Excel and Power Query Advanced!"
🔴Q: What is Microsoft Excel Power Query?
✔️A: Microsoft Excel Power Query is a powerful data connection & transformation tool that allows you to connect to a wide range of data sources, clean, shape, and transform the data, and load the transformed data into your Excel workbook for analysis and reporting.
🔴Q: What are the benefits of using Power Query in Excel?
✔️A: Power Query streamlines the data preparation process, allowing you to spend more time analyzing and reporting on your data, rather than preparing it. It also provides an easy-to-use interface for creating reusable data connections and handling large amounts of data with ease. Additionally, Power Query allows you to perform complex data transformations and connect to multiple data sources at once.
🔴Q: Is Power Query suitable for beginners in Excel?
✔️A: Yes, Power Query is suitable for Excel users of all levels, from beginners to advanced users.
Use #powerquery 📊 📈 #businessintelligence 💼 #pavanlalwani 👨💼 to stay updated.
![CAMPปลิ้น | EP.79[1/2] แก๊งไทบ้านพาบุกเมืองบั้งไฟโก้ ยโสธรรรร!!!](http://i.ytimg.com/vi/Ldr3_fvTEXk/mqdefault.jpg)
------------------------------------------------------------------
🎥 Join our Webinar’s: bitly.ws/zFNL.
------------------------------------------------------------------
💻Explorer our courses: pavanlalwani.com
------------------------------------------------------------------
🍎Apple App Store: bitly.ws/zFNW
📱Android PlayStore: bitly.ws/zFPn
------------------------------------------------------------------
📂Free Practice Files : www.bitly.ws/yxFK
------------------------------------------------------------------
Hii sir in no 3 step when i click custom
Its shows error in
sir aap naay jitni bhi koshish key haaay english videos ,,,,,,,,,,,aap saay ye request hay kaay ,,,,,ab tamam advance lecture urdu maay bhi kertay rahaay,,,,,,,,,,,,,,,,,,,,,
Allah aap ko apnay naik maqasid maay success daay.......................Aameen
Sir, your complete Power Query Tutorial video for 6hrs was just speechless. I have learned a lot from that video, but now that video seems unavailable in your channel. Please upload the same for my learning. It will be great helpful for me.
Most Valuable process, Nicely explained - Rest can be easily tackelled if one who knows excel - Keep up the good work. Have a nice day👍
Thank you so much !!
Pawan lalwani Babu thank for this topics I bless you develop very soon ,my age 60
After watching multiple times it becomes very easy and to do practical as well watched all 20 videos mind blowing, speechless. Thank u sir
Thank you very much Pavan Sir for this knowledge in very simple language and steps. You are doing a great job 👍
Thanks for hindi ♥️♥️♥️♥️♥️
Fantastic ❤
You always taught us well sir , thank-you
Is there explanation in English? you have done a lot for my level and my life, thanks Pavan
thanks sir🙏
amazing
Thank sir it's easy to understand..
Always welcome
Sir yeh toh advance series h power query ka.......basic level ka playlist share karo na plz.......mah starting seh sikhunga 🙏🏻
Basic se
th-cam.com/video/O_xxHyfD85Y/w-d-xo.html
nice
Thank you, please advise if we can merge 2 files in the same way?
You are soon going to touch 50k subscribers 🙂... Hurray !!
🎉 Wonderful
Thanks, you so much for valuable content, I have some doubt regarding Duplicate Headers also has been created.
Thank you so much sir
Most welcome
Hi Pavan,
This is an amazing tutorial, short yet quite informative, keep up the good work.
I wanted to highlight one point though, in the data files, the sales.xlsx files (e.g. north, south) are missing. Would you please provide those as it will be highly effective to practise along with those files, thanks.
Excellent
Thank you so much !!
Hello sir
Could u please explain also about to chose only selected tables.
how to combine if you have multiple files with multiple worksheets with inconsistent columns? kindly make a video on this.
What to do if we got error, in 2-3 rows
it didnt work for me after the steps where it i had to invoke custom function,, the table showed error
Sir, hame data ko total karna he to kya change karna padega?
I have a doubt about Power Query. Kindly clear the doubt by making a new video or sharing a link of old video only.
Actually, the doubt is I want to import data from the folder in power query Excel, and every file has more than 1 or 2 sheets. Likewise, I have 12 files with more than 1 sheet every file.
Now, here I want all files, but I need only selected sheets from each file, and I want to clean the data of those data sheets, which I'm gonna analyze, but I'm not getting how to do that kindly do the needful by providing exact solution to the problem what I'm trying to find.
Sample files milege kya . practice ke liye?
Hi,
Please check in the description there is data download link.
Thanks
Your rest of video are hidden now after this.
Thank you very much Pavan Sir for this knowledge in very simple language and steps. You are doing a great job 👍