Excel Power Query Course - Power Query in Hindi (Data Analyst)

Learn Power Query from Basic for the Excel Users.
Book your seat - bit.ly/3tg9mMu
We covered the following topics:
00:00 Introduction to Power Query
00:33 Power Query Input vs. Output
03:28 Get Data and Transform Data in Power Query
03:49 How to use Get Data Function in Power Query
05:51 What is Input Query in Power Query?
07:20 How to Remove Column in Power Query
07:49 How to Undo in Power Query
08:58 How to Remove blank row in Power Query
09:19 1st Row as Header in Power Query
09:47 How to Remove Rows in Power Query
10:18 How to Change Type in Power Query
13:13 How to Remove Duplicate in Power Query
16:09 How to Unpivot Column in Power Query
18:22 How to Merge Column in Power Query
19:14 How to use Column from Selection in Power Query
26:09 Custom Column formula in Power Query
29:33 Conditional Column in Power Query
32:27 How to use Edit Setting in Power Query
33:59 Reference in Power Query
34:28 Group By Function in Power Query
37:02 Count Rows in Power Query
37:20 Close and Load To Function in Power Query
39:02 Advanced Editor in Power Query
39:38 Transform Data in Power BI
MS Excel - How to Train Flash Fill (Ctrl + E)
• MS Excel - How to Trai...
Excel Power Query - Start your Data Analyst Journey
#datanalyst #excelpowerquery #powerquery
To watch more videos visit: www.excelsuperstar.org/​​​​​
To Buy an Excel Course visit: www.courses.excelsuperstar.org​
Like us on Facebook: / excelsuperstar​​
Subscribe to the Channel: / excelsuperstar

[@mukulraj6184]

Best video lesson for power query!! 👍👍🙏🙏 Even paid courses can't teach in this awesome way.

[@jitendersharma727]

हिंदी में इतना सटीक प्रस्तुतिकरण के लिए बधाई

[@JaspalSingh-xu5io]

One of the best Power Query video i had ever seen. Proper explanation and easy language to understand.

[@VipulJain40]

Another Masterpiece from the Maestro of Excel... Thanks Rishabh 🙏🙏

[@girishkumar7367]

Excellent. Great informative. Fantastic way of teaching.

[@shahzadsiddiqui5117]

Best ever video on YT for power query, God bless...!

[@85MA]

Hello! I'm a big fan of your teaching method. May I kindly request you to create a dedicated tutorial video on bank reconciliation in power query? In the bank reconciliation process, we compare two sets of data: 1) bank statement data and 2) cash book data. We compare for unclear checks, undeposited cheques, bank charges, etc. In simple terms, we're comparing for missing entries in both sides of the statements like in bank statement and in cash book records. I'm quite optimistic about the tutorial on this topic. Thanks in advance!

[@anjankumarhembram5440]

Thanks Rishab Sir....excellent tips and tricks

[@Chandrakrati]

our teaching is clear and intresting but i need to learn it practicaly

[@mjaved701]

excellent. really appreciate your efforts 👏👏👏👏

[@digitaljas5594]

Thanks Mr. Rishabh, Really awesome

[@rishitripathi2408]

Very Informative Video for beginners.. thanks

[@devendoshi4203]

Very well explained....thank you very much

[@naneparab]

BEST video and a amazing explanation.

[@vishnuarrawatia6451]

Great.... you are a master of Excel

[@anzarkamal1]

zabardast bahut shukrya

[@devangthakkar6847]

Very superb sir...... Thanks a lot.

[@freelancing8605]

Wow Super explain Sir.. thanks

[@TRAININGTUBER]

Best way of teaching, best content

[@nabeelnaeem4846]

The best video to learn power query. The way of your teaching is amazing. Thank You

[@sudhakarbhooshan]

Thanks Rishabh, very useful session

[@virendrahardiya2797]

Wao Sir, नमस्कार, अपने बहुत काम का ज्ञान दिया, ओर बहुत उत्कृष्ट तरीके से समझाया, मैं आपका सदैव आभारी रहूंगा। धन्यवाद

[@manojmishra-lq4nh]

It was a great learning experience 👌👍

[@md.rashedrayhan5518]

Your video give me more values than others video. Thanks a lot

[@babaluyadav414]

Thankyou so much Sir. It's very helpfull

[@purbamaji123]

Excellent video... very informative 👌

[@aviationandbeyond]

The last minute was the CLIMAX.. Appreciate. Liked and Subscribed.

[@ramuluvarkala9656]

Excellent explanation....... very informative 👍👍

[@shahhaider2416]

great video dear sir..........

[@sandeshkadam7937]

Ek number...i like the way of ur using to teach

[@tanveerriem2305]

Thanks for your Efforts

[@indian35556]

Not enough words to appreciate your teaching method and your video preparing. Great

[@divyanshjain5835]

Very good video I think I learnt a lot.

[@7513747]

Until today I was avoiding power query but I have confidence now to use in future. Thank you very much for explaining details.

[@calpoltab4681]

Thank you very much you made this so simple easy to understand ......

[@mustafaashraf4012]

zabardast!

[@cutepiekk]

Very well explained 👍👍

[@excelskillsin]

This is an amazing lession for me Thanks

[@muhammadimranmoosa923]

Excellent

[@harishnagar4482]

Excellent video sir ji

[@NKGUPTA-nj1xz]

mast what a explanation sir ji salute to u

[@azadsk4497]

thank you so much sir, you did lot of favor

[@nareshchavan9812]

Thank you Sir...

[@janhvidwivedi8888]

Best video lessons for power query thanks you so much sir ❤❤

[@jayeshkumargurav8573]

Very good conceptual clarity ❤

[@wealthy_you]

Thank you. ❤

[@chhotarafi7885]

This video is very beneficial for every body, I'm just watching this, sir please make more videos on data analyst in hindi, because your teaching is unique from others.🙏🙏🙏👌👌❤️❤️

[@shrikantbadge3978]

You explain very well. Your voice is good. Your style keeps the interest intact.

[@RAKESHYADAV-ht2qp]

Excellent..plases make more videos on power query

[@goodwin.champbalia1870]

Awesome video

[@honnurswamy6292]

Thanks sir your teaching style it's very unique sir 💐💐

[@jitanshukoli4230]

Superb Rishabh Sir, Har baar ki tarah aaj fir mene kuchh new and powerful lesson sikha,... Aaj pehle kabhi bhi mene power query ka naam bhi nhi suna tha, lekin aapki yeh video dekhne ke baad, mene jana ki power query kitna powerful tool hai,.. And as an accountant mere pass kafi sara complex data aata hai e commerce ka, jise suljhane me mujhe 3-4 ghante lag jate hai. Lekin ab yeh video dekhne ke baad mera kafi sara time save hoga and thanks again. Mene excel bhi aapki hi videos dekhkar sikha hai,.. You are really one an only Excel superstar in the world for me and no one can take your this position in this world. God bless you.

[@ExcelSuperstar]

Thanks so much! - Rishabh

[@aakashjoshi6239]

Sir, Everything is good to know for Power Query, Your Teaching style is good for me to learning in easy way

[@akanshavashisth6371]

Thank you Rishabh pls share more videos abt power bi query and Dax

[@SeniorEditor]

maine ye video abhi tak dekha nahi hai par mujhe vishawas hai ki ye bahut informative hi hoga....so that i give you like in advance and wishes

[@mohitsharma3131]

That's the one learner want..not even a single time a pause this vide. Hatts off

[@ExcelSuperstar]

Keep watching

[@mdafroze6123]

he deserves like and subscribe...

[@BKumar6677]

Thanks ❤️

[@danishazeem6978]

great

[@nipunjain9411]

Super

[@Batman-sb3tn]

Thanks

[@ajitkumar8441]

Maja aa gya sir

[@prathmeshhiremath9801]

Very informative video... Sir I have one doubt .. I want to change the values in existing column by applying filter to another existing column without adding new column. Can you please help ?

[@vishalraj616]

Powar quiry & conection.FILE.HOME.TRANSFRM.ADD COLUM .VIEW KA alag alag video bana dijiye please sir

[@kordeprafulla]

Pls make full Data analytic course ...

[@anwarshahsadaat3116]

Do you have any online class of data management? I like your teaching methods

[@yugalojha2128]

please make video for power BI too

[@vishalraj616]

Please sir power query ka pura video bana dijiye

[@canirmalchoudhary8173]

I learned advanced group by feature- multi level

[@jitadhikary4398]

Sir please make a full data analytics course.. 🥺

[@krishnapriya038]

Hello sir, need a video for DAX .

[@rajesh_pote]

❣️

[@rajeshwarpachhlor9062]

Please provide a data sheet for practice 🎉🎉🎉

[@muhammadsaadme3017]

Will be saving after job yaar

[@fermion4945]

Please provide the practice sheet in the description

[@amarjeetpandey3160]

Power Query In power BI Desktop par video banayiye please

[@shirishtiwari1013]

Hi Sir from where can i get the data for practice on this video

[@KhalilAhmad74036]

Thanks, Sir, very informative video. Which software are you using to draw line and rectangular shape around specific area?

[@rishabhpugalia9281]

Epic pen

[@KhalilAhmad74036]

@@rishabhpugalia9281 Thank you Sir,

[@jaitiwari241]

Plz share dataset

[@sarthaksatapathy7222]

Sir can you please me the dataset

[@blogelogy474]

Can u give ur practice sheet

[@deepak1168]

Namste Sir Mere Pas Do Sheet Hai Unme Vlookup Se Data Import Kiay Hai .......2 Excel Sheet 5,6 Coloum Power Query Me Camparison Karna Hai to With Example App Explain Karan Sir

[@ashutoshsharma1091]

Hi

[@tausifshaikh3312]

Where is this working sheet for Practice?

[@MuhammadKashif-zo7yt]

Practice sheet to sath day

[@shubhamyadav-nd4zx]

Help me to make a VBA code to send 20 files. Just like you did it need to add up a little bit more. Let me give details a little bit. Each mail has a different attachment and mail body. Like if I am sending my 1st mail. I will open that excel file, go to a particular sheet, copy data, paste it to the email body, and attach that same file as an attachment. Once the mail is ready then that file gets closed. And then with 2nd mail and it will go on for 19 times.

[@ExcelSuperstar]

Try Power Automate

[@khaliqbhatti224]

Sir i have a question How to recover deleted duplicate values kindle reply this question

[@ExcelSuperstar]

1. Add Index No to every row (1,2,3,...n) 2. Create a duplicate query 3. Remove Duplicate from Query1 4. Then use Merge Queries (Right Anti Join) with Query2. Done

[@kamalbirha919]

Sir....Excel 2007 me power query kaise karege...plz help..

[@ExcelSuperstar]

Microsoft has no such provision. HOWEVER, you can practice with Power Bi Desktop (free).

[@MuhammadSalman-kx8lb]

No practice files again

[@spsubir1451]

Where should we Used excel ? Is excel a job oriented tool? Yeah Excel is just a shit?