Excel Power Query - 5 Case Studies Under 60 Minutes {Power Query Advanced}

Solve 5 Case Studies Using Excel Power Query Under 60 Minutes
In this tutorial, we learn about Excel Power Query in detail with 3 Case Studies HR, Sales, Finance
00:00 Introduction of Excel Power Query
01:50 Case Studies no. 1 - HR Survey Raw Data
11:34 Case Studies no. 2 - Expense_Actual vs Allowance
20:51 Case Studies no. 3 - Data Analysts Revenue
34:44 Case Studies no. 4 - Actual vs Budget - Comparison Report
41:05 Case Studies no. 5 - AMFI Portfolio (Extract Data from the Web)
Excel Power Query - 5 Case Studies Under 60 Minutes
#powerquery #exceltutorials #excelinhindi
To watch more videos visit: www.excelsuperstar.org/​​​
To Buy an Excel Course visit: www.courses.excelsuperstar.org...
Subscribe to the Channel: / excelsuperstar

[@RavindraKumar-pj6jg]

I have seen many videos on excel, but yours is out of the box. Cool techniques used . Great work.

[@kamrankhan-hh9jv]

Very, very nice my concept clear by wathing your video kindly i became a expert in Excel and power bi through you video just start the SQl truning video

[@kunikaverma72]

Very grateful for the efforts you put into designing these use cases. Keep up the excellent work. Thank you sir :)

[@halalsharesstockexchange278]

Well done Rishup, Great work in a beautiful way.

[@richardvas6384]

These videos are very valuable. . . Very well explained. . . Thank you 😊

[@SanviPatil2019]

Rishab sir.. apne to kamal kar diya.. kitni easy tarikese yeh sub kuch kiya.. sir mujhe power query aur details me sikhana hai... Aapme bahot maharath hasil hai excel.me..god bless you...

[@girishpadshala9689]

Superb love hearing in native language. Really it's so much useful and covered much more. Rishabh sir your explanation is easy to understand and worth full.

[@MrFilu13]

Mind blowing experience..to understand such complex system

[@jitabhi123]

Really it's valuable video. Thank you so much

[@vishalbhati912]

Thank u so much sir. U r real legend of excel

[@lalitthapa007]

excellent tutorial Sir, thank you so much !!

[@jaynishjain225]

Thank you for sharing your valuable experience.

[@rananouman2292]

Wow Sir Amazing. Your style of teaching is awesome. Thanks for delivering this valuable video. Sir there is a suggestion if you could also share the sample data files that you have used it'll be very useful for us to practice.

[@sintulaha8659]

Awesome video .......excellent explanation of real-life case studies.

[@thatsmeonly8320]

Awesome bro. Explained even a beginner also learn easily

[@bhaimohsin]

Just Amazing! Your Teaching Style & your way of communicating is super cool. Looking Forward to learn all of this. I will have to watch this video again and again to maste Power Query Power Query itself is so helpful. AI is future, no doubt.

[@kuljitsingh2950]

Excellent boss, like your style of explaining. Good. All clear in one time.

[@manaskumardas1683]

It was very nice. The way you teach, Superb!!!

[@charizad_bg8364]

You and your way of explaining is amazing sir . Hats of to you.

[@balveerkumar9686]

Thank you so much sir. You are genius..🙏

[@prabhatkumar2068]

Very useful, provide detailed knowledge of concept

[@manishshasank4515]

Thank you so much your videos are so amazing and interesting. includes fun way and lots of knowlegde

[@rajeevgosavi4514]

Rishabji, it is a mind blowing video on Power Query. You are , indeed, a magician and thoroughbred in excel. Hats off to you. Just one humble request. Please provide a link to download worksheets to follow along. Thank you.

[@ArmanKhan-iq3ji]

Wow I love this video 😍😍😍 thank you for teaching 😊

[@naiduvikas202]

No words to explain. Super tutorial from hyderabad

[@m.akashhafeez7620]

Marvelous teaching and very useful information. Thanks

[@ebjacob]

Really good way of explanation. Thanks a lot

[@Rajkanwersharma]

Great examples! Please kept up

[@sanjaypatkar8705]

It is very helpful to handle the office work load easily, The way you have teach is very Nice. Thank you Sir !!

[@mmgupta5207]

Rishabh u r wonderful...!! Prof. Gupta Nagpur

[@Neeraj_Kumar1981]

Yes, Rishabh ..................It was definitely "Relevant" for me. Thank You......

[@tusharramgude4951]

Very knowledgeable video sir, Thank you

[@MDYOUSUF-tl8sk]

Awesome Rishabh bhai. You really rock like an Excel Superstar.

[@SaleemKhan-hm2br]

You have done excellent job dear! Islamabad, Pakistan.

[@mohdirshadietk]

Very well elaborated......that too in our mother tongue....Thanks Rishabh

[@bandhankonai8725]

This video is very helpful ...

[@RehanShaikh-ip9hh]

Amazing Rishabh...Thanx

[@amithenry9841]

Lovely. This is what I was looking for. Thanks ...

[@sawansoni5841]

Ultimate you are.. Thankyou

[@data_analytics_study]

Wow, understood clearly with 5 different cases 😊

[@itsofficialsaini]

Woow sir amazing concept of power query 👍🙏

[@vikasshimple1131]

Useful Video...Thanks

[@ManishPal-el5cy]

Outstanding work sir

[@alokbansal3511]

No words about explanation and knowledge even like to say Awesome

[@1026neeraj]

you explain awesome.

[@Finance_Life]

Nice one sir ji. Will watch all your vids

[@DeeptiDubey1380]

Rishabh this is brill. Thansk

[@dharmeshmevada2425]

It's awesome !!!👍👍👍

[@muhammadkhurram861]

Wao sir amazing..... Too much info . Never seen this type of video

[@aalerazi9975]

Amazing teacher you are. Wowwwwwwwwww

[@sumitrathod2814]

Mind blowing sir...!!!! 💕💕💕

[@yearanimol]

Thanks for this video sir...really appreciate this..🙏🙏

[@amarpatil1002]

great teaching love u sir

[@vv9730]

VERY NICELY EXPLAINED...KEEP POSTING SUCH INFORMATIVE VIDEOS...!!!

[@naeemkhokhar8270]

Super excellent work by superstar ... Love from Pakistan... God Bless you bro .. If possible can we have the practice files as well.

[@edwinpaul7157]

Everything is nice and great, also share your Excel file so that people can learn in more better way.

[@hafizurrahman9081]

Many many thanks dear Sir.

[@BKumar6677]

thnkew so much sir 💕 thanks a lot ☺️😊🙏

[@akshaynikam6628]

It's too good... Sir please share the data for the practice

[@voksencorporatetrainings]

Excellent work Rishabh

[@paravej]

Great explanation.... 👍

[@rajeshwarpachhlor9062]

You have Great voice Rishabh like you are a voice dubbed start... Keep up the good work... Thanks to create this video ❤🎉🎉🎉

[@Iasrupali208]

Great sir, nicely explain case study

[@razashahin5691]

Bravo Outstanding Great

[@debabratakhasnabis6060]

Thanks. Excellent presentation. Request you to conduct practical classes for analyzing Income Tax Form-26AS, I. Tax Annual Information System (AIS), Capital Gains Reports etc.👍👍👍👍

[@virendrahardiya2797]

Very beautiful training sir

[@shrikantbadge3978]

EXTREMELY USEFUL

[@sonu01nilaish]

You are really helping a lot of people Sir. You have simplified most complex features of excel in most simplistic way that can now be easily understood by anyone. Can you also guide on Google Sheets as many of the formulae and features are absent in Google sheet. Also the basic things like pivot tables, slicers, filter of pivot tables act very differently and does not brings desired results. It would be a great help Sir. Although you have been a great help already to us. Thanks

[@talharashid1852]

Superb sir just love the way u teach love from pakistan. Sir Can i have your data for practice please?

[@qamarhashmi3478]

Wah Sir, Zabardast

[@vinodharsana3780]

Nice Rishup great work

[@chandrabhanmishra1898]

This video Very knowledge full Please Make Video Inventory Stock Management

[@faisalaslam1618]

look guys! I found a amazing video today 👌🙌

[@hari60700]

Great video.

[@titusmenezes58]

Very Nice explanation and presentation. Thank you. Can you share the sample data files used in your presentation. Will be helpful for practice.

[@pentamail9381]

Thank you !!!

[@rishigupta2342]

Thank you for your videos. Requesting you to please share the datasets so we can implement the concepts discussed above?

[@nazrulmalik3952]

Great video❤

[@manoj19chakote]

Super Video...

[@osamakhan6320]

Its too good best for learning

[@harishtote9573]

Very useful

[@Laxmanmane007]

very Helpful

[@DeepakG99]

Great!

[@rohitshinde8447]

Sir Amazing videos please share the Excel worksheet for the practice

[@taizoondean689]

Thank You Rishab Sir

[@ankitmaloo4689]

Superb sir

[@nitinchiluka7551]

Sir video was very informative and interesting. Thanks for that. It would be more helpful if you can add this file so that we can practice the same.

[@rashmipande5098]

Thank you sir it is very informative.....one personal comment, your voice is mesmerizing....do you sing as well?

[@harit583]

Superb learning .. thank you so much … Can we do the same exercise with shares like we did with mutual funds??

[@heeren.9]

Excellent Sirji., Plz Made Example on Material/ Itams management have Demand, Received itams, Issue, Stock, Inventory, Final accounts of Materials...

[@zkgconnect7624]

Excellent

[@EpicEatsZone]

You are tooo good thanks sir

[@simranjeetsingh4101]

Thank you sir .

[@kediasc]

Very good presentation

[@910raj]

Thanks a lot sir

[@vinodkumaryadav1787]

अद्भुत

[@1981shrikant]

Best Cases, like more cases

[@mohtarimali1802]

Behtareen

[@smtt5751]

Amazing

[@manjulapapanna5633]

This very useful video, can u please advice video on large data consolidating from multiple workbooks with different headers. Hw to do in power query Pls reply