Learn POWER QUERY step by step in Hindi - Advance Excel

  Рет қаралды 37,498

Learnho

Learnho

Күн бұрын

Power Query Course for Beginner in Hindi - Advance Excel
Unlock the power of your data with Power Query! In this video, we will show you how to use this video we will learn powerful tool to clean and transform your data quickly and easily. From filtering and sorting to merging and pivoting, Power Query makes data manipulation a breeze. Plus, we'll also show you how to create your own custom functions and use them in your queries. Whether you're a beginner or a seasoned pro, this video is a must-watch for anyone looking to take their data analysis skills to the next level. We will be showing you how to use Power Query to filter, sort, and group data, as well as how to create custom calculations and pivot tables. Click play now and start mastering Power Query today!
⛔ Practice File Download From Here -
drive.google.com/drive/folder...
▶️ Timeline -
00:00 - Power Query Introduction & Installation
04:30 - Open Power Query Editor
06:45 - Split Column in Power Query
12:40 - Group by in Power Query
16:06 - Unpivot Data
20:05 - Append Query
22:48 - Merge Query
28:55 - Append Multiple Table using Power Query
33:12 - Date Function in Power Query
37:56 - Time Difference in Power Query
39:35 - Add column in Power Query
45:05 - Mini Project
____________________________________________________________________________________________
▶️ Microsoft Access Full Course in Hindi -
• MICROSOFT ACCESS TUTOR...
▶️ Advance Excel Full Course in Hindi -
• Advance Excel Full Cou...
▶️ Microsoft Word Full Course in Hindi -
• MS Word Full Course St...
▶️MS Excel Tutorial For Beginner in Hindi -
• Excel For Beginner Tut...
▶️MS Excel Full Course Step By Step -
• Excel complete tutoria...
▶️Time Saving Excel Tips (Shorts Video) -
• Time Saving Tips (Shor...
Thanks and Love
Learnho
#advance_excel #learnho #powerquery #powerbi #msexcel #data_analysis

Пікірлер: 69
@Rizwanpatanwala-zz2yz
@Rizwanpatanwala-zz2yz 8 ай бұрын
can't believe only 331 likes on this masterpiece after 11 months..to learn the same thing people pay thousands of rupees...it's true people don't value knowledge that is available for free to learn...
@aliamad8823
@aliamad8823 4 күн бұрын
Very well explained ❤
@sumankumar7215
@sumankumar7215 6 ай бұрын
Sach me itna clearly kisi ka video nahi hota. Or 1st time power quiry class dekha. Ab daily kosis karunga use Karne ka. AAPKA BAHOT BAHOT DHANYABAD ❤🎉
@minaxisharma6744
@minaxisharma6744 Жыл бұрын
Excellent tutorial with clarity.Thank you
@md.danishansari8370
@md.danishansari8370 Күн бұрын
😊thank you
@MohammedAbdulRaheem-jx3ki
@MohammedAbdulRaheem-jx3ki 16 күн бұрын
One of the best video on power query on youtube bud keep it up bro❤❤❤🎉🎉🎉
@Learnho
@Learnho 15 күн бұрын
❤️
@sejalburnwal1309
@sejalburnwal1309 2 ай бұрын
Really helpful ❤
@adityavarma461
@adityavarma461 5 ай бұрын
Thanks guru ji, apke samjhane Ka tarika Bahot Badiya hai❤️💯
@manjit.sarania
@manjit.sarania 11 ай бұрын
Very simple, understanding, and good teaching sir
@mehadialimanasiya2986
@mehadialimanasiya2986 Жыл бұрын
Marvelous effort sir
@RajuSharma-px9wf
@RajuSharma-px9wf 9 ай бұрын
it is really good content with examples for the beginner level. Thanks a lot frnd
@sunilkumarshah247
@sunilkumarshah247 5 ай бұрын
Thanks
@watchandlearn5698
@watchandlearn5698 4 ай бұрын
You teaching style is awesome
@keshariprasad1992
@keshariprasad1992 10 ай бұрын
Bhaiya Jee aapka thankful hu. TY
@UdaiKs
@UdaiKs 4 ай бұрын
Mind Blowing.
@m.farhatabbas7216
@m.farhatabbas7216 Жыл бұрын
Was waiting for it, please upload Excel Macros and VBAs full tutorials
@khalidmajeed2886
@khalidmajeed2886 Жыл бұрын
sir bohat pasand haay. we need more in power query
@mithupal4921
@mithupal4921 Жыл бұрын
Hello Bishal Sir ji. Mera namro pronam lijiye. Mey aaka video ka bahot dino se intejar kiya. Aapka e power querry wala video mey ne do bar practice kiya phir mey ne download bhi korliya. Aapko to jidna dua , jidna respect kiya jay udna hi kom hey. Ekdam complete video. Thank you sir. Thank you. God bless you. Aap bahot bahot successful n powerful bane. Paramatma ki sare devine power aap por bane rahe. Is bar ek POWER Bi ka ek full video formula dashboard creation saha ek complete video dijiye pls. Aapka video bahot confidence deta hey. Phir dil se respect n dua flow hota hey. God is allways with you. Be happy n healthy. Be positive n powerful. Stay blessed. Thank you.
@Learnho
@Learnho Жыл бұрын
Your Comment is always different Thanks 🙏🙏
@skexceltrick6858
@skexceltrick6858 4 ай бұрын
Very nice dear 👍
@vishalingle8283
@vishalingle8283 2 ай бұрын
It's really helpfull....Thank you Vishal sir
@garvit2347
@garvit2347 3 ай бұрын
Great video, quite insightful😊
@Learnho
@Learnho 3 ай бұрын
Thanks Garvit 😊
@FawadAhmad-q8e
@FawadAhmad-q8e 26 күн бұрын
thanks, amazing Tutorial
@sandeepsaini999
@sandeepsaini999 6 ай бұрын
Wonderful explanation
@Learnho
@Learnho 6 ай бұрын
❤️
@chinmaypadole59
@chinmaypadole59 24 күн бұрын
Great work bro❤
@M.HanifK
@M.HanifK 3 ай бұрын
Best Video❤
@Altaf_Alam
@Altaf_Alam 3 ай бұрын
Thanks a ton sir ji ❤😊
@cricketdekho9693
@cricketdekho9693 7 ай бұрын
Thanku sir video is very helpful aur power query ke video banayo sir
@TheShadowgaming01
@TheShadowgaming01 Ай бұрын
Bro you are so much underrated😢
@yogeshrao5924
@yogeshrao5924 25 күн бұрын
Exilent brother😊❤
@nurulhaque89
@nurulhaque89 Жыл бұрын
Nice video
@sagarkirar8578
@sagarkirar8578 3 ай бұрын
Sir apki jitni tarif ki jaye utni km h Thank you so much❤ Jai shree ram 🙏
@Learnho
@Learnho 3 ай бұрын
Jay Shree Ram 🙏
@parmarrahul2680
@parmarrahul2680 4 ай бұрын
Hello sir Please muje Power query se begin with kar ke Mr. Miss. Mrs. Remove karna hai please AAP batao kese kare qki me karta hu to table not found aata hai
@bkj1069
@bkj1069 2 ай бұрын
Good
@Tetra_Ace
@Tetra_Ace Ай бұрын
Looks like sehwag explaining excel
@simransrivastava3056
@simransrivastava3056 6 ай бұрын
Please zoom bhi whi kijiye jha pr sikha re h aap zoom khi or krte h or sikhate khi or hai khi khi pr.. actually most of us do not have this excel version do this is difficult to understand whats going on... Baki thank you so much bhut accha dikhaya ❤❤
@motivationguru741
@motivationguru741 5 ай бұрын
thank you so much sir ke tame practice sheet share kayri thank you
@Learnho
@Learnho 5 ай бұрын
Most welcome ❤️
@arungupta8444
@arungupta8444 Жыл бұрын
Sir, how do you "consolidate" in Power query. in Excel there is a function of "Consolidate" where in duplicate values are consolidated/Added to make Single item/Table. how to get this done in Power Query.
@Learnho
@Learnho Жыл бұрын
Using Group by option in power Query
@khalidmajeed2886
@khalidmajeed2886 Жыл бұрын
sir for the next videos try to zoom jazakallah
@toxic9307
@toxic9307 2 ай бұрын
Job Mil jye itna sikha do power pivot power query mis dashboard 3 topics
@user-td7tk6sr2z
@user-td7tk6sr2z 5 ай бұрын
SIR MAKE A VIDEO ON how to perform ALL LOOKUP Functions with POWER QUERY in 1 Complete Video.
@Learnho
@Learnho 5 ай бұрын
I'll try my level best.
@fermion4945
@fermion4945 5 ай бұрын
Multiple Append query me jo data apne de rakhe hai excel file me woh table me convert krke append karne me dikkat aa rahi hai .Column names change ho rahe hai .Isko kaise correct karein ?
@rajeevgosavi4514
@rajeevgosavi4514 29 күн бұрын
Can you please share the practice sheets used in here to follow along. Thanks.
@Learnho
@Learnho 28 күн бұрын
Please Check Description
@shubhammishra8686
@shubhammishra8686 Жыл бұрын
One question....in a data set i have 10 column and i have to remove the entire row if any of the cell is empty or null...how to do this????
@Learnho
@Learnho Жыл бұрын
Microsoft Excel. You can do this Using Go to special option 1. select Data 2. Go to special 3. Select Blanks 4. Delete Row
@shubhammishra8686
@shubhammishra8686 Жыл бұрын
@@Learnho Thanks.....can you tell me how to do this using Power Query
@syedabdulmoeez1736
@syedabdulmoeez1736 8 ай бұрын
multiple sheet jan to dec data summary kaisy bnaogy
@debabratachakraborty847
@debabratachakraborty847 3 ай бұрын
Power query hai lakin get and transform blank aa raha hai
@madhumitakonatkar1840
@madhumitakonatkar1840 Жыл бұрын
Thank you sir
@Learnho
@Learnho Жыл бұрын
Welcome
@rishavkandari975
@rishavkandari975 6 ай бұрын
The practice files are not working ? showing corrupted data.
@Learnho
@Learnho 6 ай бұрын
Bhai download ho Raha hai check kiya mene abhi phir se try kar lo aap
@toxic9307
@toxic9307 2 ай бұрын
Power Pivot , Power Query , MIS Dashboard Full video bana do kahi or na jana pade
@simransrivastava3056
@simransrivastava3056 6 ай бұрын
Kya power query or excel alg h?? Mgr option to excel me hi aata hai
@Learnho
@Learnho 4 ай бұрын
Power Query Power BI ka Tool hai Lekin nye wale Excel version me pahle se hi add rahta hai
@simransrivastava3056
@simransrivastava3056 4 ай бұрын
@@Learnho oh thank you..
@by7991
@by7991 Жыл бұрын
Hi pivot mey range vala option aaraha.. same active cell bhi aaraha hai
@Learnho
@Learnho Жыл бұрын
Time Stamp??
@by7991
@by7991 Жыл бұрын
@@Learnho not time stamp below search option from where we can pick attributes like product, date , qty in that area along with that I'm getting range option
@shrikantbadge3978
@shrikantbadge3978 11 ай бұрын
Thanks
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 45 МЛН
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 7 МЛН
DAD LEFT HIS OLD SOCKS ON THE COUCH…😱😂
00:24
JULI_PROETO
Рет қаралды 16 МЛН
Inside Out Babies (Inside Out Animation)
00:21
FASH
Рет қаралды 17 МЛН
Excel Power Query Course - Power Query in Hindi (Data Analyst)
41:23
Excel Superstar
Рет қаралды 54 М.
How To Compare Two Tables In Excel (Full Guide\ All ways)
13:17
Some little tips
Рет қаралды 917
How to use Microsoft Power Query
16:35
Kevin Stratvert
Рет қаралды 1,9 МЛН
Excel Power Query Course: Power Query Tutorial for Beginners
1:49:28
Simon Sez IT
Рет қаралды 822 М.
Excel to Power BI [Full Course] 📊
2:57:36
Pragmatic Works
Рет қаралды 594 М.
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 45 МЛН