Тёмный

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

Pavan Lalwani
Подписаться 215 тыс.
Просмотров 22 тыс.
50% 1

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...
🌍 Explore our Courses 📊:-
✔️pavanlalwani.com
📝Internship Enquiry
✔️docs.google.co...
CONNECT WITH US!
🐦 Twitter:- ✔️ / lalwanipavan
💼 LinkedIn:- ✔️ / pavanlalwani
📸 Instagram:- ✔️ / pavanlalwani
🕸 Facebook:- ✔️ / pavanlalwanitrainer
📟Telegram:- ✔️t.me/powerbi_t...
*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.c...
✔️Download Link :
drive.google.c...
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.

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

 

28 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 42   
@PavanLalwani
@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
@govindtribhuvan6344 4 месяца назад
Hii sir in no 3 step when i click custom Its shows error in
@manishpandey7579
@manishpandey7579 5 месяцев назад
After watching multiple times it becomes very easy and to do practical as well watched all 20 videos mind blowing, speechless. Thank u sir
@PradeepKumarSingh
@PradeepKumarSingh Год назад
Thank you very much Pavan Sir for this knowledge in very simple language and steps. You are doing a great job 👍
@othmanashara9382
@othmanashara9382 2 года назад
Is there explanation in English? you have done a lot for my level and my life, thanks Pavan
@gajulasandeepkumarsandeepk6881
@gajulasandeepkumarsandeepk6881 Месяц назад
Tq Sir🎉.
@niteshsonawane
@niteshsonawane Год назад
Thanks, you so much for valuable content, I have some doubt regarding Duplicate Headers also has been created.
@pranjalbhalani
@pranjalbhalani 6 месяцев назад
Sir, hame data ko total karna he to kya change karna padega?
@dorjiwangmo5310
@dorjiwangmo5310 Год назад
it didnt work for me after the steps where it i had to invoke custom function,, the table showed error
@Mohitboin
@Mohitboin 2 года назад
Sir yeh toh advance series h power query ka.......basic level ka playlist share karo na plz.......mah starting seh sikhunga 🙏🏻
@mrramjanalam7761
@mrramjanalam7761 2 года назад
Basic se ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-O_xxHyfD85Y.html
@unknown_i.m
@unknown_i.m Год назад
Excellent
@PavanLalwani
@PavanLalwani Год назад
Thank you so much !!
@shahidahmed2190
@shahidahmed2190 Год назад
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.
@SUR-NI-VARA
@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
@PavanLalwani Год назад
Thank you so much !!
@gourabchakraborty6650
@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.
@SHIVAMSINGHAL-CORP
@SHIVAMSINGHAL-CORP Месяц назад
Sir, Getting error. Expression.Error: We cannot apply field access to the type Function. Details: Value=[Function] Key=Content
@kunal221290
@kunal221290 Год назад
Your rest of video are hidden now after this.
@som8760-y7f
@som8760-y7f 2 года назад
Thanks for hindi ♥️♥️♥️♥️♥️
@kanwalsingh2802
@kanwalsingh2802 Год назад
Thank you, please advise if we can merge 2 files in the same way?
@SciFi-Hist
@SciFi-Hist 3 месяца назад
What to do if we got error, in 2-3 rows
@hissamuddin3063
@hissamuddin3063 2 года назад
how to combine if you have multiple files with multiple worksheets with inconsistent columns? kindly make a video on this.
@som8760-y7f
@som8760-y7f 2 года назад
You are soon going to touch 50k subscribers 🙂... Hurray !!
@PavanLalwani
@PavanLalwani 2 года назад
🎉 Wonderful
@adiyansfuntime
@adiyansfuntime 5 месяцев назад
nice
@ShatruGM
@ShatruGM 2 года назад
Thank sir it's easy to understand..
@PavanLalwani
@PavanLalwani 2 года назад
Always welcome
@khalidmajeed2886
@khalidmajeed2886 2 месяца назад
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
@sameersecular8922
@sameersecular8922 Год назад
Fantastic ❤
@oshneythakur2449
@oshneythakur2449 Год назад
amazing
@kapil4757
@kapil4757 7 месяцев назад
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.
@unknown_i.m
@unknown_i.m Год назад
Sample files milege kya . practice ke liye?
@PavanLalwani
@PavanLalwani Год назад
Hi, Please check in the description there is data download link. Thanks
@debabratachakraborty847
@debabratachakraborty847 3 месяца назад
Pawan lalwani Babu thank for this topics I bless you develop very soon ,my age 60
@PradeepKumarSingh
@PradeepKumarSingh Год назад
Thank you very much Pavan Sir for this knowledge in very simple language and steps. You are doing a great job 👍
@shahkhalid4092
@shahkhalid4092 Год назад
Hello sir Could u please explain also about to chose only selected tables.
@YashSharma-hf1vx
@YashSharma-hf1vx 9 месяцев назад
You always taught us well sir , thank-you
@JyotiPatra-y6w
@JyotiPatra-y6w 5 месяцев назад
thanks sir🙏
@mrramjanalam7761
@mrramjanalam7761 2 года назад
Thank you so much sir
@PavanLalwani
@PavanLalwani 2 года назад
Most welcome
Далее
+1000 Aura For This Save! 🥵
00:19
Просмотров 10 млн
Qalpoq - Amakivachcha (hajviy ko'rsatuv)
41:44
Просмотров 176 тыс.
How to Move Data Automatically Between Excel Files
11:37
Excel Time-Savers - 5 Hidden Features for Busy People
14:24