1.1 Text Functions in Power Query | Advanced Excel - Power Query Tutorials Playlist by Pavan Lalwani

  Рет қаралды 33,030

Pavan Lalwani

Pavan Lalwani

2 жыл бұрын

1.1 Text Functions in Power Query | Advanced Excel - Power Query Tutorials Playlist by 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!
💾FREE 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 and 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.

Пікірлер: 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 ------------------------------------------------------------------
@krishnakishorepeddisetti4387
@krishnakishorepeddisetti4387 2 жыл бұрын
you are a God of teacher sir.... straight to the point... crisp explanation.... amazing
@suryavenkatachalam247
@suryavenkatachalam247 Ай бұрын
Hello pavan sir, I'm a fan of your classes sir, such a simple language you are teaching us. One request sir, can you make excel macros videos?
@samihassan2508
@samihassan2508 2 жыл бұрын
Sir Pavan Lalvani love ❤ and thanks from Pakistan
@PavanLalwani
@PavanLalwani 2 жыл бұрын
Welcome
@mrramjanalam7761
@mrramjanalam7761 2 жыл бұрын
बहुत बहुत धन्यवाद सर प्रतिदिन विडियो अपलोड करें SIR 🥀
@aptech9254
@aptech9254 7 ай бұрын
Awesome 👍
@ShahadatHossain-dc2gs
@ShahadatHossain-dc2gs Жыл бұрын
Nice and informative
@muhammadnaeem2378
@muhammadnaeem2378 2 жыл бұрын
Respect❤❤❤❤❤
@sdbnassociates1172
@sdbnassociates1172 Жыл бұрын
Good initiative , really appreciate it
@PavanLalwani
@PavanLalwani Жыл бұрын
Hi, Thank you so much !!
@sdbnassociates1172
@sdbnassociates1172 Жыл бұрын
Awaiting other courses in hindi as well
@saadatjahbahadurwalesarkar2664
@saadatjahbahadurwalesarkar2664 6 ай бұрын
Hindi mai great..sie acha hai
@mrramjanalam7761
@mrramjanalam7761 2 жыл бұрын
I am waiting next video in excel
@principaliti4515
@principaliti4515 Жыл бұрын
Which version of ms office are you using? MS Office 2016 version there is no year option in date formate?
@brijmohansinghyadav
@brijmohansinghyadav Жыл бұрын
I have Use Power Quary It is Not Work in .xls File "DataFormat.Error: External table is not in the expected format error"
@VipulJain40
@VipulJain40 Жыл бұрын
sir where is that video of 5 hrs of Power query? have you removed??
@mrramjanalam7761
@mrramjanalam7761 2 жыл бұрын
Microsoft word Microsoft Excel Microsoft power point Aapse sikhna hai
@SamehRSameh
@SamehRSameh 2 жыл бұрын
We need more functions such as list. Date. Table.
@minamishail_Tech2024
@minamishail_Tech2024 2 жыл бұрын
I wish this course in English , these seems a great lesson list.
@nishaupadhyay2282
@nishaupadhyay2282 Жыл бұрын
sir my power query is not working page of power query is not showing
@SyedMuntazirHussain
@SyedMuntazirHussain Жыл бұрын
There are only 21 videos available for Query whereas the list says 62 because the rest videos are hidden. I would really appreciate if you could please unhide the videos.
@shraddhadhakad1154
@shraddhadhakad1154 9 ай бұрын
Hi, Recently i attended a interview in which interviewer asked a question me related to power query "Does the order of queries matter in Power Query?" Please reply this question.
@fayazmuhammad5983
@fayazmuhammad5983 6 ай бұрын
yes
@saritabisht8707
@saritabisht8707 2 жыл бұрын
Sir DAX function ka wait kar rahe h
@krishnakishorepeddisetti4387
@krishnakishorepeddisetti4387 2 жыл бұрын
Me too
@PavanLalwani
@PavanLalwani 2 жыл бұрын
Me too. Coming soon In 30 days
@krishnakishorepeddisetti4387
@krishnakishorepeddisetti4387 2 жыл бұрын
@@PavanLalwani hi sir... More tutorials on M query will be really helpful... Not much content is available around it.... Even if available.... Not clearly explained... It will help a lot of people
@PavanLalwani
@PavanLalwani 2 жыл бұрын
@@krishnakishorepeddisetti4387 Sure. Will try for that as well.
@narenderkumararya7498
@narenderkumararya7498 17 күн бұрын
Hi Pavan Sir, Hi Sir, I need your help to resolve my task. i work for a travel agency my management required a how may airline fly the same date same time on the same route and mark it color in pivot table. I work manual this kindly help me on it example on below. Departure Date/Time (Leg) Airline (Segment) Origin Airport Code Destination Airport Code Remarks 2023-10-10 13:25 Lufthansa MUC AMS Duplicate British Airways BOM MAN KLM MUC AMS Duplicate 2023-10-26 02:25 KLM BOM SVG 2023-10-31 02:30 KLM BOM SVG 2023-11-19 08:50 British Airways BOM MAN Duplicate Air France BOM MAN Duplicate
@mrramjanalam7761
@mrramjanalam7761 2 жыл бұрын
Please sir excel ka video Facebook mai dalne ki koshish kare Share karna mai aasani hogi
@PavanLalwani
@PavanLalwani 2 жыл бұрын
Bilkul Kitna share karne wale ho Aap Sikh rahe ho thik se ?
@PavanLalwani
@PavanLalwani 2 жыл бұрын
@UCa8ZqqtNCzzns-9UgOtmX1g Sun kar bahut Khushi hui aur sukoon bhi. Abi Saare videos/shorts / introduction/ Interview questions recording chalu hai. Jaldi hi posting hoga. Aapke liye next week Tak Facebook pe posting bhi karwata hu taaki aap share kar paye . All the best
@mrramjanalam7761
@mrramjanalam7761 2 жыл бұрын
@@PavanLalwani ok sir 🤝🐦
@manojsuradkar9209
@manojsuradkar9209 2 жыл бұрын
Are you from Kannad, Fatima Convent High School?
@PavanLalwani
@PavanLalwani 2 жыл бұрын
Yes
@manojsuradkar9209
@manojsuradkar9209 2 жыл бұрын
@@PavanLalwani I guess when I was in 4th Std you were in 10th Std 😅 Your channel has nice stuff...👍🤟
@PavanLalwani
@PavanLalwani 2 жыл бұрын
Thank you
@mrramjanalam7761
@mrramjanalam7761 2 жыл бұрын
Finance ka video jarur upload karna Pmt Ipmt Ppmt Pv Fv Others
@dhakafady774
@dhakafady774 Жыл бұрын
@pavan lalwani sir , how could i get all of your hidden 41 videos of power query video.
@PavanLalwani
@PavanLalwani Жыл бұрын
Download Our App: For Android Users: play.google.com/store/apps/details?id=co.sheldon.unacr For iOS Users - HTTP://apps.apple.com/in/app/myinstitute/id1472483563 Use Org Code - UNACR
@dhakafady774
@dhakafady774 Жыл бұрын
@@PavanLalwani sir i am a great fan of yous , i am from bangladesh i already did. but did get the Video's there . would you mind showing me the path.
Best father #shorts by Secret Vlog
00:18
Secret Vlog
Рет қаралды 22 МЛН
That's how money comes into our family
00:14
Mamasoboliha
Рет қаралды 12 МЛН
Cool Items! New Gadgets, Smart Appliances 🌟 By 123 GO! House
00:18
123 GO! HOUSE
Рет қаралды 16 МЛН
10X Your Excel Skills with Copilot
12:51
Pavan Lalwani
Рет қаралды 273 М.
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
How to easily automate boring Excel tasks with Power Query!
17:10
MyOnlineTrainingHub
Рет қаралды 1,5 МЛН
Advanced Excel tutorial using Power Query by Pavan Lalwani
1:27:10
Pavan Lalwani
Рет қаралды 55 М.
Best father #shorts by Secret Vlog
00:18
Secret Vlog
Рет қаралды 22 МЛН