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

Подписаться 385 тыс.

Просмотров 54 тыс.

50% 1

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

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

14 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 97

@mukulraj6184 2 года назад

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

@jitendersharma727 Год назад

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

@virendrahardiya2797 Год назад

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

@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 2 месяца назад

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

@85MA 7 месяцев назад

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!

@mjaved701 2 года назад

excellent. really appreciate your efforts 👏👏👏👏

@Chandrakrati Месяц назад

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

@anjankumarhembram5440 2 года назад

Thanks Rishab Sir....excellent tips and tricks

@jitanshukoli4230 4 месяца назад

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 4 месяца назад

Thanks so much! - Rishabh

@nabeelnaeem4846 Год назад

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

@md.rashedrayhan5518 2 года назад

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

@SeniorEditor 2 года назад

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

@digitaljas5594 2 года назад

Thanks Mr. Rishabh, Really awesome

@7513747 Год назад

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

@vishnuarrawatia6451 11 месяцев назад

Great.... you are a master of Excel

@babaluyadav414 8 месяцев назад

Thankyou so much Sir. It's very helpfull

@anzarkamal1 Год назад

zabardast bahut shukrya

@aviationandbeyond Год назад

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

@rishitripathi2408 Год назад

Very Informative Video for beginners.. thanks

@sudhakarbhooshan 2 года назад

Thanks Rishabh, very useful session

@naneparab Год назад

BEST video and a amazing explanation.

@devendoshi4203 Год назад

Very well explained....thank you very much

@devangthakkar6847 2 года назад

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

@freelancing8605 Год назад

Wow Super explain Sir.. thanks

@mohitsharma3131 2 года назад

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

@ExcelSuperstar 2 года назад

Keep watching

@manojmishra-lq4nh Год назад

It was a great learning experience 👌👍

@indian35556 8 месяцев назад

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

@ramuluvarkala9656 4 месяца назад

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

@purbamaji123 4 месяца назад

Excellent video... very informative 👌

@sandeshkadam7937 2 года назад

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

@tanveerriem2305 Год назад

Thanks for your Efforts

@NKGUPTA-nj1xz Год назад

mast what a explanation sir ji salute to u

@calpoltab4681 7 месяцев назад

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

@TRAININGTUBER 7 месяцев назад

Best way of teaching, best content

@divyanshjain5835 Год назад

Very good video I think I learnt a lot.

@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.🙏🙏🙏👌👌❤️❤️

@excelskillsin Год назад

This is an amazing lession for me Thanks

@janhvidwivedi8888 Год назад

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

@jayeshkumargurav8573 8 месяцев назад

Very good conceptual clarity ❤

@cutepiekk Год назад

Very well explained 👍👍

@honnurswamy6292 2 года назад

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

@shahhaider2416 Год назад

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

@harishnagar4482 2 года назад

Excellent video sir ji

@RAKESHYADAV-ht2qp 2 года назад

Excellent..plases make more videos on power query

@shrikantbadge3978 10 месяцев назад

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

@aakashjoshi6239 Год назад

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

@muhammadimranmoosa923 Год назад

Excellent

@nareshchavan9812 11 месяцев назад

Thank you Sir...

@akanshavashisth6371 2 года назад

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

@azadsk4497 Месяц назад

thank you so much sir, you did lot of favor

@wealthy_you 6 месяцев назад

Thank you. ❤

@mdafroze6123 6 месяцев назад

he deserves like and subscribe...

@mustafaashraf4012 Год назад

zabardast!

@goodwin.champbalia1870 2 года назад

Awesome video

@BKumar6677 2 года назад

Thanks ❤️

@danishazeem6978 10 месяцев назад

great

@Batman-sb3tn 2 года назад

Thanks

@nipunjain9411 8 месяцев назад

Super

@vishalraj616 Год назад

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

@vishalraj616 Год назад

Please sir power query ka pura video bana dijiye

@ajitkumar8441 2 года назад

Maja aa gya sir

@kordeprafulla 2 года назад

Pls make full Data analytic course ...

@canirmalchoudhary8173 2 года назад

I learned advanced group by feature- multi level

@anwarshahsadaat3116 Год назад

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

@yugalojha2128 2 года назад

please make video for power BI too

@prathmeshhiremath9801 2 года назад

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 ?

@jitadhikary4398 2 года назад

Sir please make a full data analytics course.. 🥺

@rajesh_pote Год назад

❣️

@krishnapriya038 Год назад

Hello sir, need a video for DAX .

@amarjeetpandey3160 Год назад

Power Query In power BI Desktop par video banayiye please

@rajeshwarpachhlor9062 2 месяца назад

Please provide a data sheet for practice 🎉🎉🎉

@muhammadsaadme3017 2 года назад

Will be saving after job yaar

@fermion4945 4 месяца назад

Please provide the practice sheet in the description

@KhalilAhmad74036 2 года назад

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

@rishabhpugalia9281 2 года назад

Epic pen

@KhalilAhmad74036 2 года назад

@@rishabhpugalia9281 Thank you Sir,

@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

@jaitiwari241 2 года назад

Plz share dataset

@shirishtiwari1013 Год назад

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

@blogelogy474 2 года назад

Can u give ur practice sheet

@sarthaksatapathy7222 Год назад

Sir can you please me the dataset

@MuhammadKashif-zo7yt Год назад

Practice sheet to sath day

@ashutoshsharma1091 2 года назад

@kamalbirha919 2 года назад

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

@ExcelSuperstar 2 года назад

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

@khaliqbhatti224 2 года назад

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

@ExcelSuperstar 2 года назад

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

@tausifshaikh3312 2 года назад

Where is this working sheet for Practice?

@shubhamyadav-nd4zx 2 года назад

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 2 года назад

Try Power Automate