I'm watching this is in 2024. what a series it is. trust this person and finish this series, you all going to learn a lot from this. also practice along with the chapter. thnkyou
@AAAExcel8 ай бұрын
thank you so much, happy that you found it useful!
@ousmanesidibe9518 ай бұрын
Just joined you
@haleylearnАй бұрын
Me too
@hishamoo222 Жыл бұрын
ما شاء الله شغل جميل جدا ومنظم بشكل احترافي ويمكن لاي شخص ان يتعلم حتى لو كان مبتدا لسلاسة الشرح بارك الله في رزقك وعملك
@AAAExcel Жыл бұрын
شكرا جزيلا .. ربنا يكرمك
@PURVESHPRAJAPATI-tm7ds3 жыл бұрын
Today I was able to complete the course. It is the very well manner teaching of each and every step of Power Query Example.
@AAAExcel3 жыл бұрын
Well done 👍 Hope was useful for you!!
@walteramayi23739 күн бұрын
You are, by far and away, the best I have encountered. Thank you!
@AAAExcel8 күн бұрын
Happy that you found my videos useful, thank you for the compliment 🙏
@sszzVipeRzzss3 жыл бұрын
You deserve a medal for this .. awesome I could not stop watching for 4hours straight
@AAAExcel3 жыл бұрын
Thank you so much, happy that you like it 👍
@arnoldschwartz1144 жыл бұрын
This course is a much appreciated educational experience related to PQ - It's well organized, has clear and understandable language, great back-up resources ... a real gem for learning some more advanced PQ skills.
@AAAExcel4 жыл бұрын
Thank you 🙏
@terrencepasanting2697 Жыл бұрын
This is just the most comprehensive power query tutorial exactly I need.
@AAAExcel Жыл бұрын
Welcome to my humble channel, happy that you find it useful
@MobinulHaq3 жыл бұрын
I think that this is one of the best Power Query courses on KZbin. It's amazing, so detailed. Thank you so much!
@AAAExcel3 жыл бұрын
Thank you 🙏
@klarawijs4 жыл бұрын
Thank you so much for this amazing and useful course, I am so grateful that you shared this with us. Cheers from Romania!
@AAAExcel4 жыл бұрын
Your most welcome, thank you for your comment
@mahmah81263 ай бұрын
First of all, from the bottom of my heart, I would like to thank you very much for the video uploaded on KZbin. Sir, you have no idea how many people are getting beneficiated through your videos. In fact, many people. This is one of the best video. :) A week ago, I was zero in PQ, but now I am confident enough to use PQ. A big thank you so much again.
@AAAExcel2 ай бұрын
Appreciate that you spend time to write this kind compliment, and happy that you get benefited from my humble work Best of luck
@BenDieselBasicAutomotive Жыл бұрын
Thank you very much for the very comprehensive.... yet simplified explanation!... I now have a solid foundation to study Power Query....
@AAAExcel Жыл бұрын
Happy to hear, welcome my humble channel.
@shrikantbadge3978 Жыл бұрын
I just wanted to take a moment to express my sincere gratitude for your exceptional Power Query tutorials. Your teaching style is incredibly effective, and your dedication to providing clear, practical explanations is truly commendable. Thanks to your videos, I've gained a much deeper understanding of Power Query, and I feel more confident using it in my projects. Your real-world examples and step-by-step guidance have been invaluable. I genuinely appreciate the time and effort you invest in creating these tutorials. Your passion for Power Query shines through, and it's inspiring for all of us eager learners. Looking forward to more fantastic content from your channel. Keep up the fantastic work! Warm regards
@Gastonag872 жыл бұрын
Thank you so much for this tutorial, I’m trying to switch professions from BA to data analyst and Power Query - Power Pivot are a good starting point. Great Job!
@AAAExcel2 жыл бұрын
Thank you Gaston, best of luck dear
@RajeshChaulkar-c4fАй бұрын
I sincerely appreciate your efforts in creating this exceptional video. It serves as an incredibly useful and insightful guide for anyone seeking expertise in Power Query. I truly admire your teaching skills and the patience you demonstrate in your commitment to sharing knowledge. Salute to your dedication!
@AAAExcelАй бұрын
Thank you so much, appreciate your kind words and support
@hskalsi8323 жыл бұрын
Simply put..... it’s awesome. Standing clearly out from many stuff on this subject available in YT. I spend months to understand the PQ without success, but this one is working. Great. Thanks.
@AAAExcel3 жыл бұрын
Thank you so much, happy that you enjoyed it and find it useful 👍
@shadowman.HH22 Жыл бұрын
انا بشكر حضرتك جدا على المجهود اللى بذلته وعلى طريقة الشرح الوافيه الكافيه ❤
@AAAExcel Жыл бұрын
عفوا .. وشكرا جدا لتعليقك 🙏
@InsightfulJourney1233 жыл бұрын
I just discovered this course and channel! Amazing gem! Well presented with knowledge power! Subscribing!! Thank you very much, Sir!🙏
@AAAExcel3 жыл бұрын
Thank you so much, happy that you like it
@user-if5qy8tc3lАй бұрын
really amazing course for power query, i finished this course nowdays, as we need to learn this tools, thanks you again for grateful efforts and great in such amazing course Mr.Amr Mostafa
@AAAExcel29 күн бұрын
So happy that you liked it and found it useful, best of luck dear
@simohnkanyiri3103 Жыл бұрын
Heartfelt gratitude goes to the tutor for this amazing power query video....its very comprehensive detailed and easy to learn. Thank a lot.
@AAAExcel9 ай бұрын
My pleasure, happy that you found it useful
@BabakRoumiani2 жыл бұрын
Thanks for this great excel course. I'm Bob from Iran, Thanks for your videos again, I hope you continue making tutorial videos like this.
@AAAExcel2 жыл бұрын
Thank you so much Bob for your comment, you can check my website for more videos in English Www.aaa-power.net
@azwarmzafar4 ай бұрын
This has been on my to do list since long time ago, its golden lessons. Many thanks.
@AAAExcel16 күн бұрын
My pleasure
@khurramshahzad78474 ай бұрын
One of the best video and great tutor found ever on youtube, Thank and Best regards to the teacher, God Bless you more. Best Regards, Khurram from Pakistan
@AAAExcel16 күн бұрын
Jazakallahu Khairan (May Allah reward you with good) - Thank you for the lovely words, Khurram!
@TheJdelgomes3 жыл бұрын
Absolute amazing Power Query Course. Thank You very much.
@AAAExcel3 жыл бұрын
My pleasure
@mixtape8476 Жыл бұрын
Thank for sharing this tutorial, I have already finished it and learned a lot!. Now it's time for more advanced stuff.
@AAAExcel10 ай бұрын
best of luck and thank you for your nice comment
@NikVilluri3 жыл бұрын
Honestly, all your hard work and dedication shows. Thank you so much 🙌🏼
@AAAExcel3 жыл бұрын
Thank you so much for your comment 🙏🙏
@winstonchen11732 жыл бұрын
I am so excited that I have learned all the solutions to my challenges currently I am facing in my work from this full course. The lecturer is amazing. He had well organized the content of this PQ video lectures. He is thorough in the knowledge and his presentation is very clear and almost perfect from my point of view. He connects to the real world, so the PQ he teaches is very practical. Thank you so much!
@AAAExcel2 жыл бұрын
Thank you so much for your comment, and so glad to hear that it made difference to the way you do your work .. best of luck 🤞
@GosCee3 жыл бұрын
Wow! Finally, I got it; I clearly understand the different joins. Well done! Thank you very much.
@AAAExcel3 жыл бұрын
Thank you so much, happy that you like it and find it useful
@vanillasoda8454 Жыл бұрын
Wow thank you so much sir you are truly a godsend, im still at PQB04 and this is already very useful and interesting, definitely gonna learn all of it!
@AAAExcel Жыл бұрын
Happy that you liked it and found it useful, best of luck
@smccabe Жыл бұрын
This is an awesome video. Plenty of detail, nicely organised into sections and a good pace too. Thank you!
@AAAExcel Жыл бұрын
Happy that you like it and found it helpful
@0886-v4p2 жыл бұрын
Super helpful, great instructor!
@AAAExcel2 жыл бұрын
Glad it was helpful! thank you
@jawadahmadehssan62513 жыл бұрын
Can't thank you enough for the great service you do. Thanks alot.
@AAAExcel3 жыл бұрын
My pleasure 😊😊
@lindalai14063 жыл бұрын
Just came across your channel, I know instantly that I found treasures. Hope I can see more coming. Thank you very much for your efforts that make complex stuff sound so easy!
@AAAExcel3 жыл бұрын
Thank you so much for your comment, more to come hopefully, bear with me 😉
@ilkercalsr81302 жыл бұрын
I am excited to watch all the serie. Thanks for great cosolidation.
@AAAExcel2 жыл бұрын
You’re welcome 😉
@marwaomar3804 Жыл бұрын
thanks to you, this course is more useful I watch it in 2023. grateful to you😊
@AAAExcel Жыл бұрын
My pleasure, happy that you enjoyed it
@deepaknagar56973 жыл бұрын
Awesome tutorial video, Best video on power query ever seen on you tube, Thanks.
@AAAExcel3 жыл бұрын
Thank you so much, happy that you like it 😊
@FinanceIbiscus11 ай бұрын
Fantastic and incredibly clear course. Thank you very much for this resource
@AAAExcel10 ай бұрын
Glad it was helpful!
@ousmanesidibe9518 ай бұрын
did start power query for long, but this is the best video i've seen so far
@AAAExcel8 ай бұрын
Happy that you found it helpful 👍
@hadeerhasan84814 жыл бұрын
Thanks a lot for such informative organized course.. Really appreciate your time and effort..🌺🌺🌺
@AAAExcel4 жыл бұрын
Most welcome Hadeer 😊😊
@havylenguyen54622 ай бұрын
Thank you for your sharing, i really appreciate your dedication in this video. Looking forward to your new videos about this powerful tool.
@AAAExcel2 ай бұрын
My pleasure, you can check the advanced power query series Advanced Power Query kzbin.info/aero/PLX4tbThHdEDcNr-BWK_7aJ2TJgizL3b8k
@lolaadeoye35843 жыл бұрын
Fantastic!!! thanks so much for this wonderful training.
@AAAExcel3 жыл бұрын
Most welcome dear
@syedmurtaaza16163 ай бұрын
A meaningful contribution and support. Thank you so much.
@AAAExcel2 ай бұрын
Thank you too!
@RealMAK3453 ай бұрын
شكرًا
@AAAExcel3 ай бұрын
عفوا .. شكرا جدا لك 🙏
@thanhnguyentien27093 жыл бұрын
thank you very much. It helful me very much!! Cheers from Viet Nam!
@AAAExcel3 жыл бұрын
Hello dear, happy that you like it, cheers to my friend from Vietnam 🇻🇳
@ewhen89033 жыл бұрын
Thanks a lot for the videos!! Terrific class! From total beginner to intermediate only with your videos
@AAAExcel3 жыл бұрын
Happy to hear, best of luck We are currently working on the advanced series, already 2 videos posted, check them out
@deeliyanage-de8mj5 ай бұрын
Thank you lot of sir , lot of things learning from your videos. From Sri lanka
@AAAExcel16 күн бұрын
Happy to hear so, you’re welcome
@jaaze13 жыл бұрын
Thank you so much to give me comprehensive knowledge about PQB..............
@AAAExcel3 жыл бұрын
It's my pleasure
@ShabnamKhan-vk7fj4 жыл бұрын
This is amazing, thank you for all the hard work!
@AAAExcel4 жыл бұрын
Most welcome
@Corinthian0Feliz3 жыл бұрын
You are just amazing. Thank you for this fantastic course 🙏
@AAAExcel3 жыл бұрын
Thank you so much 😊
@rufusonoyinki72812 жыл бұрын
Wow! This is a great material and Am lucky being here........ Keep up the good work
@AAAExcel2 жыл бұрын
You’re welcome to my humble channel Thank you so much 😊
@ExcelTradicional Жыл бұрын
I suggest that you should add Spanish subtitles to the videos. The way of explaining is very clear and that is why I am a follower.
@AAAExcel Жыл бұрын
Happy that you found it useful, I think this is something that can auto gerenrated from the viewer side
@DrK999993 жыл бұрын
Insane and crazy content (in a positive way). Thumbs up and hats off.
@AAAExcel3 жыл бұрын
My pleasure, thank you so much
@raziulhnur3 жыл бұрын
Excellent video. Perfectly explained. Thank you.
@AAAExcel3 жыл бұрын
Most welcome 🙏
@AAAExcel3 жыл бұрын
Most welcome 🙏
@axion87883 жыл бұрын
An astounding gift of the highest quality. You are an amazing teacher and many thanks! (Subscribed😀)
@AAAExcel3 жыл бұрын
Thank you so much for your comment, and welcome to my humble channel 😊😊
@mohamedhosny-uh7ux2 жыл бұрын
Very big thanks for your efforts again and again your efforts is very appreciated
@AAAExcel2 жыл бұрын
Thank you for your comment 🙏🙏
@reazahmed2181 Жыл бұрын
I have finally completed the 5 hour video. Thank you so much for this amazing basic course. :)
@AAAExcel Жыл бұрын
Excellent, happy that you find it useful, hurry up and go to the next level, I have two series that might help you to move forward: Advanced Power Query: kzbin.info/aero/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 and Power Query Challenges: kzbin.info/aero/PL5NlUYOM2iOgYQCf0HJlwKnsXvun40YIm
@reazahmed2181 Жыл бұрын
@@AAAExcel Oh! wow. Thank you, I sure will. : )
@Will.Tru8 Жыл бұрын
Thank you Amr! this was pretty informative and easy to follow.
@AAAExcel Жыл бұрын
Glad you enjoyed it!
@AirIndiaAnand3 жыл бұрын
Thanks for a fantastic demonstration of PQ. I thorougly enjoyed your narration filled with Tips and Tricks. Keep it up. Looking forward to more videos fom you. Thanks (Suggestion - Please check the video at 29:30, the Column 'Sales' is formatted to Date and not Sales Value in $)
@AAAExcel3 жыл бұрын
Thank you so much for your nice words and thanks again for spotting this unintentional error, much appreciated
@AirIndiaAnand3 жыл бұрын
@@AAAExcel I was in Cairo with AUC for some time in 2008. Where do you work in Cairo?
@AAAExcel3 жыл бұрын
,Great, I work for Vodafone Egypt
@datascientists03 жыл бұрын
Superb Excellent Sir because of your course I cracked the interview they give m the task to combing worksheet into One and its should be automated , very tedious through vba...but with PQ is super easy...
@AAAExcel3 жыл бұрын
Excellent, happy to hear that you did well in the interview, best of luck
@anindyamaiti39673 жыл бұрын
One of the best tutorials for PQ ..thank you
@AAAExcel3 жыл бұрын
My pleasure.. thank you 🙏
@saromijuwon71513 жыл бұрын
This is very explanatory.. Thank you very much for this
@AAAExcel3 жыл бұрын
Most welcome 🙏
@8713407303 жыл бұрын
Thank you so much for this amazing video! May you stay blessed!
@AAAExcel3 жыл бұрын
My pleasure 😊😊
@yasserless3 жыл бұрын
For Real, No one can beat you on this Course this is a TOP Class course
@AAAExcel3 жыл бұрын
Thank you so much for your nice comment 🙏🙏
@alexrosen87622 жыл бұрын
Fantastic tutorial. Very very useful with real practical examples. Thank you!
@AAAExcel2 жыл бұрын
Thank you Alex 🙏
@2wheels.explorer3 жыл бұрын
Thanks a lot for such an informative organized course. Really appreciate your time and effort :)
@AAAExcel3 жыл бұрын
My pleasure 😊😊
@abrahimovic13 жыл бұрын
Thank you, this is an awesome tutorial, thank you for all the hard work you put into this.
@AAAExcel3 жыл бұрын
Thank you for your comment, you are most welcome 🙏
@ezralakya3295Ай бұрын
Great video, you explain really well. thank you
@AAAExcel16 күн бұрын
Thank you so much 🙏
@kimsanov3 жыл бұрын
Thank you! Very well-made course. Brilliant clarifying!
@AAAExcel3 жыл бұрын
Thank you 🙏
@srentos8 ай бұрын
Great resource and well taught!😊
@AAAExcel8 ай бұрын
Thank you, happy that you liked it
@EmmanuelGidudu-k3t2 жыл бұрын
this was an awesome lesson. great work done, thanks and be blessed.
@AAAExcel2 жыл бұрын
You’re welcome dear, thank you for your nice words 🙏
@sunilvashist29032 ай бұрын
Just Wow..... Completed three chapters..... Fabulous
@AAAExcel15 күн бұрын
Excellent, keep going
@mbunweemmanuel1092 жыл бұрын
Thank you very much, sir. Succinct and life-transforming tutorial. I will be glad if there are any excel tutorials from basics to advance skills levels like this.
@AAAExcel2 жыл бұрын
Thank you for your comment, actually I have tutorials about pivot tables end to end, please check the link below kzbin.info/www/bejne/pKe6Y3Soer6Wq6M
@nairobi203 Жыл бұрын
Very nice. Thanks a lot. Wonderful training...
@AAAExcel Жыл бұрын
Most welcome 🙏
@owenfrancisco7464 Жыл бұрын
As of now this is the best Power Query for Beginners!
@AAAExcel Жыл бұрын
Thank you and happy that you recommend it
@owenfrancisco7464 Жыл бұрын
I've upgraded my skills because this Thank you!@@AAAExcel
@AAAExcel Жыл бұрын
happy to hear so
@nedoshivin3 жыл бұрын
you're such a great teacher! thanks for doing this, I've learned so much from you!
@AAAExcel3 жыл бұрын
Thank you so much for the nice words 😊😊
@rajeevgosavi45143 жыл бұрын
Sir, all your videos are superb and entail each concept very clearly. I could not understand very clearly about left anti, right anti, etc as enumerated by you in PQB10. May I please request you to clarify them further. Thank you once again for your most comprehensive tutorial.
@AAAExcel3 жыл бұрын
Hi Rajeev, sorry for the late reply, the left anti is simply what in left table does not exist in the right table and vise versa
@manojshivankar3 жыл бұрын
Superb. Thank you
@AAAExcel3 жыл бұрын
Most welcome 🙏
@christabelajaero79833 жыл бұрын
This is very insightful. Thank you!!! Please, do you have any full KZbin lesson on PowerBI ( including how to automate in powerBI) ???
@AAAExcel3 жыл бұрын
My pleasure, actually I have few videos about Power BI, the link is here kzbin.info/www/bejne/aaDTiXx7lNp9ndU
@ivy9161 Жыл бұрын
This is amazing! Thanks so much for your wonderful contents and hard work!
@AAAExcel Жыл бұрын
my pleasure
@MyRockMyFortress3 ай бұрын
Excellent tutorial! Thank you :)
@AAAExcel3 ай бұрын
Most welcome 🙏
@bibekpangeni68363 күн бұрын
Thankyou so much for your efforts it was very helpful
@AAAExcel2 күн бұрын
Thank you, happy you found it useful
@NEHACHHAPOLIA Жыл бұрын
All practice files in one zip folder? Awesome video. This should be on udemy
@AAAExcel Жыл бұрын
I have a separate link for each section in the description box I am thinking about Udemy, great idea, thank you 🙏
@abaderefs4 жыл бұрын
روح ياشيخ الله يباركلك عظمة على عظمة
@AAAExcel4 жыл бұрын
شكرا جزيلا .. ربنا يكرمك
@AnilKumar-dt7ns3 ай бұрын
excellent ,there are no words
@AAAExcel2 ай бұрын
Thank you 🙏
@kumarcamukesh3 жыл бұрын
DEar Sir Thanks from the core of my heart for this wonderfull work done by you....really helpfull and informative and concepts made easy to understand. Again thank you very much sir ...
@kumarcamukesh3 жыл бұрын
Lot of love from India.
@AAAExcel3 жыл бұрын
Thank you so much for your nice comment, happy you like it and find it useful
@AAAExcel3 жыл бұрын
Lot of love to all Indian followers ❤️
@TheLaopi Жыл бұрын
Very useful tutorial, thkx from France
@AAAExcel Жыл бұрын
Thank you, and happy you find it useful
@karthick22543 жыл бұрын
Great Job, Amazing! thanks for your hard work and effort!
@AAAExcel3 жыл бұрын
Thank you so much for your comment 🙏
@kgediya60523 жыл бұрын
What an excellent teacher!!!!
@AAAExcel3 жыл бұрын
Thank you sir 😊😊🙏🙏
@masekelaisaacmaake76013 жыл бұрын
Thank you for an awesome tutorial.
@AAAExcel3 жыл бұрын
Most welcome 🙏
@junejaundoo38272 жыл бұрын
This was extremely helpful. Thank you!
@AAAExcel2 жыл бұрын
My pleasure 🙏
@junejaundoo38272 жыл бұрын
@@AAAExcel Lmk if you have other videos. I’d love to check them out.
@AAAExcel2 жыл бұрын
I do have, check the below play lists kzbin.info/aero/PL5NlUYOM2iOjGP2BI0MYQMjLb6ZB4gxWv kzbin.info/aero/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 kzbin.info/aero/PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if kzbin.info/aero/PL5NlUYOM2iOgw8iAgG-DagodGryYSVtEA
@JayantShettigar-pt6uo Жыл бұрын
Alll the videos were amazing.
@AAAExcel Жыл бұрын
Thank you dear, please subscribe to my English Channel youtube.com/@aaaexcelenglish
@freedomofspeechlb3 жыл бұрын
Thank you alot for this lovely course
@AAAExcel3 жыл бұрын
My pleasure 😊
@amroali1456 Жыл бұрын
I'm really appreciate your efforts thanks ❤
@AAAExcel Жыл бұрын
My pleasure dear
@175off66 Жыл бұрын
Why do we need to filter 3:49:00 (Doesnot equal to 'DailySales') before expanding the tables. Huge Thank you for the amazing content.
@AAAExcel Жыл бұрын
3:50:10 the output of the query will be a new table in the same worksheet, the filter will prevent the excel.currentworkbook from reprocess DailySales table