4.8 Combine Multiple Excel files in Power Query | Advanced Excel-Power Query Tutorials Pavan Lalwani

Рет қаралды 18,007

2 жыл бұрын

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.

Пікірлер: 39

@PavanLalwani Жыл бұрын

------------------------------------------------------------------ 🎥 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 ------------------------------------------------------------------

@govindtribhuvan6344 Ай бұрын

Hii sir in no 3 step when i click custom Its shows error in

@debabratachakraborty847 Ай бұрын

Pawan lalwani Babu thank for this topics I bless you develop very soon ,my age 60

@gourabchakraborty6650 Жыл бұрын

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.

@manishpandey7579 2 ай бұрын

After watching multiple times it becomes very easy and to do practical as well watched all 20 videos mind blowing, speechless. Thank u sir

@SUR-NI-VARA Жыл бұрын

Most Valuable process, Nicely explained - Rest can be easily tackelled if one who knows excel - Keep up the good work. Have a nice day👍

@PavanLalwani Жыл бұрын

Thank you so much !!

@PradeepKumarSingh 10 ай бұрын

Thank you very much Pavan Sir for this knowledge in very simple language and steps. You are doing a great job 👍

@sb47820 2 жыл бұрын

Thanks for hindi ♥️♥️♥️♥️♥️

@othmanashara9382 Жыл бұрын

Is there explanation in English? you have done a lot for my level and my life, thanks Pavan

@YashSharma-hf1vx 6 ай бұрын

You always taught us well sir , thank-you

@kapil4757 5 ай бұрын

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.

@sameersecular8922 Жыл бұрын

Fantastic ❤

@adiyansfuntime 2 ай бұрын

nice

@ShatruGM 2 жыл бұрын

Thank sir it's easy to understand..

@PavanLalwani 2 жыл бұрын

Always welcome

@sb47820 2 жыл бұрын

You are soon going to touch 50k subscribers 🙂... Hurray !!

@PavanLalwani 2 жыл бұрын

🎉 Wonderful

@oshneythakur2449 11 ай бұрын

amazing

@user-xl4zd8yu1e 2 ай бұрын

thanks sir🙏

@kanwalsingh2802 Жыл бұрын

Thank you, please advise if we can merge 2 files in the same way?

@subho7484 2 жыл бұрын

Sir yeh toh advance series h power query ka.......basic level ka playlist share karo na plz.......mah starting seh sikhunga 🙏🏻

@mrramjanalam7761 2 жыл бұрын

Basic se kzfaq.info/get/bejne/hcWoq6uqy6qcZY0.html

@niteshsonawane 9 ай бұрын

Thanks, you so much for valuable content, I have some doubt regarding Duplicate Headers also has been created.

@mrramjanalam7761 2 жыл бұрын

Thank you so much sir

@PavanLalwani 2 жыл бұрын

Most welcome

@unknown_i.m Жыл бұрын

Excellent

@PavanLalwani Жыл бұрын

Thank you so much !!

@shahkhalid4092 10 ай бұрын

Hello sir Could u please explain also about to chose only selected tables.

@hissamuddin3063 2 жыл бұрын

how to combine if you have multiple files with multiple worksheets with inconsistent columns? kindly make a video on this.

@dorjiwangmo5310 10 ай бұрын

it didnt work for me after the steps where it i had to invoke custom function,, the table showed error

@SciFi-Hist 4 күн бұрын

What to do if we got error, in 2-3 rows

@pranjalbhalani 3 ай бұрын

Sir, hame data ko total karna he to kya change karna padega?

@shahidahmed2190 11 ай бұрын

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.

@unknown_i.m Жыл бұрын

Sample files milege kya . practice ke liye?

@PavanLalwani Жыл бұрын

Hi, Please check in the description there is data download link. Thanks