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
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.
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!
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.
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
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!
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!
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!
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.
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...
شكرا جدا .. في سلسلة باور كويري المتقدمة th-cam.com/play/PL5NlUYOM2iOh1pIrQazS0hFy1eGaOk-Ht.html وفي كمان سلسلة غير مكتملة على باور بي اي th-cam.com/play/PL5NlUYOM2iOjIj8fgdAvknwyr3MgYTpWT.html
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: th-cam.com/play/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58.html and Power Query Challenges: th-cam.com/play/PL5NlUYOM2iOgYQCf0HJlwKnsXvun40YIm.html
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.
Thank you for your comment, actually I have tutorials about pivot tables end to end, please check the link below th-cam.com/video/nvW2ArEYcuA/w-d-xo.html
This is the first time i what a full video with length > 60' on youtube. Thank you for your instruction. It really helps. Is it possible if formula uses for "add new column" can be based on several specific conditions? I am highly appreciated if you can have a session on formula use inside Query. Thanks in advance
What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?
@@AAAExcel That is perfectly fine, but can one of the field values be formatted as Hyperlink that by clicking it take us to the record at the source data table?
one of the best power query video on TH-cam. In the 4th part of the video (Extracting data from csv files), in the load to button i am not getting the option to load to pivot table. I am only getting the option to load to table and when i am loading it in the table in worksheet it is showing load to worksheet failed. Reason it is showing that the work sheets only have the limit of 1048576 rows(and there are more than 2000000 rows).
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 $)
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 ...
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
I do have, check the below play lists th-cam.com/play/PL5NlUYOM2iOjGP2BI0MYQMjLb6ZB4gxWv.html th-cam.com/play/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58.html th-cam.com/play/PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if.html th-cam.com/play/PL5NlUYOM2iOgw8iAgG-DagodGryYSVtEA.html
Slowly working my way through this excellent video. Thank you for putting it together! My question: at 29:21 in the final refresh of the data for the bike shop, the sales by month chart does not update correctly. Instead of sales number in the column it updates with dates. How should this be corrected?
Awesome Sir. I have a doubt . I have two tables ex 1. Sales table (not having Revenue). 2. Product table price vary from weekly. I need to add column in sales table . That column should multiple product price with units with match of week number or patch number and product. Please explain sir.
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
thank you so much, happy that you found it useful!
Just joined you
Today I was able to complete the course.
It is the very well manner teaching of each and every step of Power Query Example.
Well done 👍
Hope was useful for you!!
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.
Thank you 🙏
You deserve a medal for this .. awesome I could not stop watching for 4hours straight
Thank you so much, happy that you like it 👍
Thank you so much for this amazing and useful course, I am so grateful that you shared this with us. Cheers from Romania!
Your most welcome, thank you for your comment
This has been on my to do list since long time ago, its golden lessons. Many thanks.
I think that this is one of the best Power Query courses on TH-cam. It's amazing, so detailed. Thank you so much!
Thank you 🙏
Honestly, all your hard work and dedication shows. Thank you so much 🙌🏼
Thank you so much for your comment 🙏🙏
I just discovered this course and channel! Amazing gem! Well presented with knowledge power! Subscribing!! Thank you very much, Sir!🙏
Thank you so much, happy that you like it
This is just the most comprehensive power query tutorial exactly I need.
Welcome to my humble channel, happy that you find it useful
ما شاء الله شغل جميل جدا ومنظم بشكل احترافي ويمكن لاي شخص ان يتعلم حتى لو كان مبتدا لسلاسة الشرح بارك الله في رزقك وعملك
شكرا جزيلا .. ربنا يكرمك
Thank you very much for the very comprehensive.... yet simplified explanation!... I now have a solid foundation to study Power Query....
Happy to hear, welcome my humble channel.
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!
Thank you Gaston, best of luck dear
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.
Thank you so much, happy that you enjoyed it and find it useful 👍
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
Absolute amazing Power Query Course. Thank You very much.
My pleasure
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!
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 🤞
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!
Thank you so much for your comment, more to come hopefully, bear with me 😉
Super helpful, great instructor!
Glad it was helpful! thank you
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!
Happy that you liked it and found it useful, best of luck
This is amazing, thank you for all the hard work!
Most welcome
Thanks a lot for such informative organized course.. Really appreciate your time and effort..🌺🌺🌺
Most welcome Hadeer 😊😊
Thank you lot of sir , lot of things learning from your videos. From Sri lanka
did start power query for long, but this is the best video i've seen so far
Happy that you found it helpful 👍
Fantastic!!! thanks so much for this wonderful training.
Most welcome dear
Can't thank you enough for the great service you do. Thanks alot.
My pleasure 😊😊
thanks to you, this course is more useful I watch it in 2023. grateful to you😊
My pleasure, happy that you enjoyed it
Heartfelt gratitude goes to the tutor for this amazing power query video....its very comprehensive detailed and easy to learn. Thank a lot.
My pleasure, happy that you found it useful
You are just amazing. Thank you for this fantastic course 🙏
Thank you so much 😊
For Real, No one can beat you on this Course this is a TOP Class course
Thank you so much for your nice comment 🙏🙏
An astounding gift of the highest quality. You are an amazing teacher and many thanks! (Subscribed😀)
Thank you so much for your comment, and welcome to my humble channel 😊😊
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.
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
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.
Happy that you found it useful, I think this is something that can auto gerenrated from the viewer side
Thanks a lot for the videos!! Terrific class! From total beginner to intermediate only with your videos
Happy to hear, best of luck
We are currently working on the advanced series, already 2 videos posted, check them out
Thanks a lot for such an informative organized course. Really appreciate your time and effort :)
My pleasure 😊😊
Thank you, this is an awesome tutorial, thank you for all the hard work you put into this.
Thank you for your comment, you are most welcome 🙏
Thank for sharing this tutorial, I have already finished it and learned a lot!. Now it's time for more advanced stuff.
best of luck and thank you for your nice comment
Superb. Thank you
Most welcome 🙏
Wow! Finally, I got it; I clearly understand the different joins. Well done! Thank you very much.
Thank you so much, happy that you like it and find it useful
All practice files in one zip folder? Awesome video. This should be on udemy
I have a separate link for each section in the description box
I am thinking about Udemy, great idea, thank you 🙏
Fantastic and incredibly clear course. Thank you very much for this resource
Glad it was helpful!
This is an awesome video. Plenty of detail, nicely organised into sections and a good pace too. Thank you!
Happy that you like it and found it helpful
I am excited to watch all the serie. Thanks for great cosolidation.
You’re welcome 😉
Excellent video. Perfectly explained. Thank you.
Most welcome 🙏
Most welcome 🙏
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.
Thank you so much Bob for your comment, you can check my website for more videos in English
Www.aaa-power.net
Thank you! Very well-made course. Brilliant clarifying!
Thank you 🙏
Thank you so much to give me comprehensive knowledge about PQB..............
It's my pleasure
Awesome tutorial video, Best video on power query ever seen on you tube, Thanks.
Thank you so much, happy that you like it 😊
One of the best tutorials for PQ ..thank you
My pleasure.. thank you 🙏
As of now this is the best Power Query for Beginners!
Thank you and happy that you recommend it
I've upgraded my skills because this Thank you!@@AAAExcel
happy to hear so
Thank you for an awesome tutorial.
Most welcome 🙏
Wow! This is a great material and Am lucky being here........ Keep up the good work
You’re welcome to my humble channel
Thank you so much 😊
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...
Excellent, happy to hear that you did well in the interview, best of luck
This is very insightful. Thank you!!!
Please, do you have any full TH-cam lesson on PowerBI ( including how to automate in powerBI) ???
My pleasure, actually I have few videos about Power BI, the link is here
th-cam.com/video/3opXIE_uJgs/w-d-xo.html
Fantastic tutorial. Very very useful with real practical examples. Thank you!
Thank you Alex 🙏
What an excellent teacher!!!!
Thank you sir 😊😊🙏🙏
ما شاء الله... عاوزين حضرتك تعملنا فيديوها تاني عن PowerQuery & Power BI tool...........جميله ومنظمه وسهله الفهم والتطبيق... ماشاء الله
شكرا جدا .. في سلسلة باور كويري المتقدمة
th-cam.com/play/PL5NlUYOM2iOh1pIrQazS0hFy1eGaOk-Ht.html
وفي كمان سلسلة غير مكتملة على باور بي اي
th-cam.com/play/PL5NlUYOM2iOjIj8fgdAvknwyr3MgYTpWT.html
Superb effort
Thank you so much 😊
Very big thanks for your efforts
again and again your efforts is very appreciated
Thank you for your comment 🙏🙏
I have finally completed the 5 hour video. Thank you so much for this amazing basic course. :)
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:
th-cam.com/play/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58.html
and Power Query Challenges:
th-cam.com/play/PL5NlUYOM2iOgYQCf0HJlwKnsXvun40YIm.html
@@AAAExcel Oh! wow. Thank you, I sure will. : )
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.
Thank you for your comment, actually I have tutorials about pivot tables end to end, please check the link below
th-cam.com/video/nvW2ArEYcuA/w-d-xo.html
Great resource and well taught!😊
Thank you, happy that you liked it
Thank you Amr! this was pretty informative and easy to follow.
Glad you enjoyed it!
Thank you so much for this amazing video! May you stay blessed!
My pleasure 😊😊
Great Job, Amazing! thanks for your hard work and effort!
Thank you so much for your comment 🙏
Extraordinario !! Thanks !!
Most welcome 🙏
Really useful videos
Thank you 🙏
this was an awesome lesson. great work done, thanks and be blessed.
You’re welcome dear, thank you for your nice words 🙏
This is very explanatory..
Thank you very much for this
Most welcome 🙏
This is the first time i what a full video with length > 60' on youtube. Thank you for your instruction. It really helps. Is it possible if formula uses for "add new column" can be based on several specific conditions? I am highly appreciated if you can have a session on formula use inside Query. Thanks in advance
Also highly recommended for other beginning/ intermediate learners about Query.
You mean conditional columns ? I will consider, thank you for feedback, appreciated
What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?
Power query would help you report on the source data and refresh reports when the sources updated, it won’t help change or update source data !!
@@AAAExcel That is perfectly fine, but can one of the field values be formatted as Hyperlink that by clicking it take us to the record at the source data table?
روح ياشيخ الله يباركلك
عظمة على عظمة
شكرا جزيلا .. ربنا يكرمك
you're such a great teacher! thanks for doing this, I've learned so much from you!
Thank you so much for the nice words 😊😊
thank you very much. It helful me very much!! Cheers from Viet Nam!
Hello dear, happy that you like it, cheers to my friend from Vietnam 🇻🇳
one of the best power query video on TH-cam. In the 4th part of the video (Extracting data from csv files), in the load to button i am not getting the option to load to pivot table. I am only getting the option to load to table and when i am loading it in the table in worksheet it is showing load to worksheet failed. Reason it is showing that the work sheets only have the limit of 1048576 rows(and there are more than 2000000 rows).
Check this short video
معلومة في دقيقة بالعربي- تحميل الكويري الي جدول محوري مباشرة
th-cam.com/video/2BR5V4kH_oE/w-d-xo.html
Insane and crazy content (in a positive way). Thumbs up and hats off.
My pleasure, thank you so much
Very nice. Thanks a lot. Wonderful training...
Most welcome 🙏
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 $)
Thank you so much for your nice words and thanks again for spotting this unintentional error, much appreciated
@@AAAExcel I was in Cairo with AUC for some time in 2008. Where do you work in Cairo?
,Great, I work for Vodafone Egypt
Alll the videos were amazing.
Thank you dear, please subscribe to my English Channel
youtube.com/@aaaexcelenglish
Thank you alot for this lovely course
My pleasure 😊
بارك الله فيك
شكرا .. بارك الله فيك
This is amazing! Thanks so much for your wonderful contents and hard work!
my pleasure
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 ...
Lot of love from India.
Thank you so much for your nice comment, happy you like it and find it useful
Lot of love to all Indian followers ❤️
Very useful tutorial, thkx from France
Thank you, and happy you find it useful
Why do we need to filter 3:49:00 (Doesnot equal to 'DailySales') before expanding the tables.
Huge Thank you for the amazing content.
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
I'm really appreciate your efforts thanks ❤
My pleasure dear
Thank you for this tutorial. Well explained!
Thank you 🙏
You are fantastic
Thank you so much dear
Excellent. Thank you
Most welcome 🙏
simply ...great
Thank you 🙏
Great Job!
thank you :)
Thank you very very much!! Would you please do some examples about Dashboard.
My pleasure
Actually I have couple of videos about dashboards, please see the link below
th-cam.com/play/PL5NlUYOM2iOgwLIzH-xlzlLUIxJA0sd8g.html
Thanks Sir for all your help
My pleasure 😊
This was extremely helpful. Thank you!
My pleasure 🙏
@@AAAExcel Lmk if you have other videos. I’d love to check them out.
I do have, check the below play lists
th-cam.com/play/PL5NlUYOM2iOjGP2BI0MYQMjLb6ZB4gxWv.html
th-cam.com/play/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58.html
th-cam.com/play/PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if.html
th-cam.com/play/PL5NlUYOM2iOgw8iAgG-DagodGryYSVtEA.html
Thank you sir. This was really good.
Most welcome 🙏
Slowly working my way through this excellent video. Thank you for putting it together!
My question:
at 29:21 in the final refresh of the data for the bike shop, the sales by month chart does not update correctly. Instead of sales number in the column it updates with dates. How should this be corrected?
Sorry for the late reply, actually you can format the cells as numbers instead of dates, it will work
Big effort 🤝
Thank you 🙏
Awesome Sir. I have a doubt . I have two tables ex 1. Sales table (not having Revenue). 2. Product table price vary from weekly. I need to add column in sales table . That column should multiple product price with units with match of week number or patch number and product. Please explain sir.
Great Job
Thank you 🙏
thanks so much, great jobs.
Thank you so much 😊
Thanks a lot for the course.
Most welcome 🙏