Hello Sumit, I've watched all 41 power query training videos and learnt a lot. Just want to say that your videos are very clear to understand and well structured, probably the best training videos I've come across on youtube. These videos were uploaded about 4 years ago, but are still so relevant today and helpful for those struggling to figure out how to use power query. A very big thanks, this will definitely help me to be more productive at work. 🙌
@Swizzletwice
Ай бұрын
July 2024 -- I finished all 41 videos in this PQ course. Imo, it's among the very best courses I've ever taken in my entire life. This course is very well-structured in the form of short videos which emphasize a single aspect of PQ. By the time I was done, I won't say I'm an expert, but I have an excellent understanding of PQ. Everything is well-explained. There is a practice file for every video (except #40). I took extensive notes. If I want to review a concept, it's easy to find the concept and the file and practice it again. Sumit Bansal has a nice voice, good pacing, and doesn't meander. The emphasis is entirely on the content with no irritating picture-in-picture or gimmicks. The course is 4 yrs old as of this date and is still as relevant today as the day it was produced. Less than a handful of things were different in my newer version of PQ, and it was easy to figure out and carry on. This is all available for free and for some of the best teaching available. Ten gold stars to Sumit Bansal, the talented instructor & creator of the course.
@trumpexcel
Ай бұрын
Thank you so much for the kind words. I am happy you found the course helpful 🙂
@sohaybemad623
11 күн бұрын
Best PQ playlist on youtube♥
@IARM1
2 ай бұрын
Thanks for so valuable playlist.
@tabishkhan9559
3 ай бұрын
One of the Best Playlist 1 Needs to follow if he is interested in Learning Power Query. Thanks Alot Sumit
@trumpexcel
3 ай бұрын
Thanks for the kind words Tabish
@nazarkamal8831
9 ай бұрын
Thanks for almost entire things about Power query all package in one channel ❤❤❤❤ truly learned a lot Thanks TrumpExcel
@grzegorz2852
4 жыл бұрын
I did all you videos in only 4 days, great examples, super great source of knowledge, thank you very much. I have learned a lot from this course, which was so interesting. U have been doing a great job. For me now it's time for VBA course
@udayteja6595
Жыл бұрын
This is the last video of the playlist. Completed watching all the videos in the playlist. Really very informative videos, and helpful. Thankyou very very much for the content. I have learnt many new things from this series of power quires.
@redherring4119
2 жыл бұрын
Great course. Straight to the point but very comprehensive. Would be nice if you did more courses on other features such as Power Pivot and PowerBI.
@Thor_Underdunk_Caballerial
3 жыл бұрын
I'm impressed with the concise, yet complete nature of this video and your effective language skills. The production is decent also, top stuff, very helpful. Thank You.
@LinhPhan-sk6ti
3 ай бұрын
Learned a lot from the whole series. Thank you very much. Keep up the good work :)
@alparkson5494
2 жыл бұрын
I have been looking for this solution for over a month! Thank you for your instruction. So easy to understand.
@margad-erdeneboldbaatar4704
2 жыл бұрын
Thanks so much for this all free course. I just finished all your Excel courses. These lessons are very simple explained, easy to understand and very practical.
@jing7350
Жыл бұрын
Very helpful course. It's straightforward and well structured. Thank you!
@sravankumar4860
10 ай бұрын
Hi Bro. I really love your video. I learnt a lot from ur lectures. I see less videos these days truly missing. Hope u bounce back and do lot more videos to help others😢
@kewal229
2 жыл бұрын
Short and simple.. Very useful trick for self learners.. Thank you so much. 🙌🏻
@michafabich9213
2 жыл бұрын
great course, watched from beginning to end!
@bessyvalayil1831
2 жыл бұрын
Very useful and well explained. Thank you... !
@poruatokin
3 жыл бұрын
Congratulations and thanks - your tuition here saved me a huge amount of time. Really excellent stuff.
@vitalisifiokamasi2679
2 жыл бұрын
Honestly, great videos and explanation of concepts
@rtrbs8383
Жыл бұрын
Awesome Sir I have finished all your playlist....Hope we will have Part 2 of Power Query.. Thank you Very Much
@AnushkaStatusVideos
3 жыл бұрын
Hi Sumit Bansal, Had seen all the 41 videos of this power query play list, all are well explained in detail, thanks for your time and effort in creating this kind of a very useful playlist. One request, is it possible for you to create a playlist for POWER PIVOT with DAX FORMULAS from basic to advanced as after completing Power Query, we have to learn DAX, then only we can get in to Power BI, I think. This is my humble view and request. If possible please upload, else ok. Anyways, thanks for your contribution to Excel and its allied subjects, May God bless you with good health and happiness always. Stay Safe and Stay Healthy. Thanks
@SndfOmar
Жыл бұрын
Thank you very much Sumit.👏
@prudhvilanka
3 ай бұрын
Graet Insights Brother..!!
@arsalankahan568
10 ай бұрын
Thanks so much very helpful 😀
@user-yx6tn3rd3q
3 жыл бұрын
Very useful If Target.Address = … Thank you!
@luishaka88
2 жыл бұрын
lifesaver!!
@faithfinancemath
3 жыл бұрын
Thanks for the course.
@sohaybemad623
11 күн бұрын
Sorry i have a question, so isn't it better to just use the right click and hit refresh instead of right a VBA code and then you have to run it also!?
@Sk-ew7cn
3 жыл бұрын
THANKS A LOT 🙏
@DerekMorgan1
3 жыл бұрын
Thanks, this is a very good course
@RamachandranS20
3 жыл бұрын
Thank you so much. Exactly what I need.
@study4734
2 жыл бұрын
This is helpful.
@russo6770
3 жыл бұрын
Thank you!! very useful
@meteora8888
Жыл бұрын
thx for the video. one question. i update my source data which powerquery pulls into my data model but the changes i made in the source table flow thru via powerquery no matter what i do. any ideas where im going wrong?
@niritcaspi9013
9 ай бұрын
is there a way to refresh (by office scripts) a few power query connections sorted ?i was not able to do "action recorder" for power query , so i have to write it , can you help?
@CarlitoAugust
3 жыл бұрын
how can you make the dropdown to select multiple options so the filtered table works for more than one selection? is there a way to make it work with several filters?
@alexrosen8762
3 жыл бұрын
Very useful tutorial.Thanks :-)
@loveprosen
3 жыл бұрын
Very helpful!!!
@TheMthegr8
Жыл бұрын
This is super impressive. I have one question though - my source data in excel is connected to an online application. When I click on refresh button every month it refreshes my data with live status as at that moment on the application. Now, if I create power query out of my source data, and load data sheet from power query into same workbook, will my power query data be also refreshed whenever I refresh my source data? Pls reply.
@mikelennon1078
3 жыл бұрын
What is the best way to update the records in the source table/sheet directly 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?
@AmP_BYD
Жыл бұрын
in my excel, when query properties is selected, only the Query Name and Description are shown. All other options like, refresh control, server Formatting are absent. Is there any way to enable them?
@ExceluniForAll
Жыл бұрын
very gooood
@sivas9443
4 жыл бұрын
wonderful 41 videos and waiting for more . !!! thanks a lot
@allanjunior9198
3 жыл бұрын
Dont know if anyone gives a shit but if you're bored like me atm you can watch pretty much all the latest movies on instaflixxer. I've been streaming with my brother for the last few months xD
@caspianayaan1502
3 жыл бұрын
@Allan Junior Yea, I've been watching on instaflixxer for since november myself =)
@rexjuelz7229
3 жыл бұрын
@Allan Junior Yup, I have been using InstaFlixxer for months myself :)
@dustinjamison3031
3 жыл бұрын
@Allan Junior Yup, I've been using instaflixxer for months myself :)
@hendrixnathan1008
3 жыл бұрын
@Allan Junior definitely, been using instaflixxer for months myself =)
@grantw1465
3 жыл бұрын
Thanks for this and I was wondering if you can automate refreshing multiple excel documents. I.e. I update all my source files and then I run one "parent" query (using PQ), save and close it and then open another, reliant on the previous parent document, and run another query here. Then I have multiple "child-like" queries that I run separately as they feed off these initially refreshed queries (parents). Point being, is there a way to automate this entire process instead of manually opening each document and running the queries manually? I would suppose one could combine refresh on opening the "child' documents but can one manipulate it so that the "parent" document/s are first completed, one after the other, in order and then the children opened and set to update on opening?
@lionels839
Жыл бұрын
I believe data/refresh all can refresh both queries and pivot tables. Right?
@hiezellechan31
2 жыл бұрын
I have a question. what if i update my raw file, how can i make sure it is updated on my power query ?
@user-uk6kx8yl8u
Жыл бұрын
this is great! i have an issue with my query. When i remove a line from my data source workbook, it stays in my query workbook. I cannot figure out how to get that row to remove from my query also
@abuena73
3 жыл бұрын
you can still save your file as xlsx even though you have vba script? is macro-enabled worksheet can run under file type xlsx???
@lalitchavan519
3 жыл бұрын
I appended 4 sheets to create a data model in power query and created a pivot to fetch all data at once. But when i update sources data and refresh data model, there are no changes. And pivot goes blank after refresh. Can you help please.
@briandennehy6380
4 жыл бұрын
Hi Sumit, is it possible to create a macro that runs daily to refresh the connection without any manual intervention to start the macro?
@ShaibulHoqueMozumder
4 жыл бұрын
THANK YOU SIR
@kalmkrew
Жыл бұрын
The table is connected but when I add data to the source is doesn't show the new data after refresh
@rashidkhan8161
2 жыл бұрын
Please refer best book for learn M language
@v11890
4 жыл бұрын
Can we link Query of one workbook to other workbook.. Here I'm talking about linking (Not copy paste ) and when Query in source file is updated then Query of destination workbook should also get updated
@madhusudanbehera1651
Жыл бұрын
does not refresh the query table
@loidaasar487
4 жыл бұрын
in the zipped file, why don't you have the practice files for playlist no. 40?
@vasimuddinsheikh3766
3 жыл бұрын
You can make multiple folder containing empty files that's the only requirement for that video.....
@WealthofStocks4
4 жыл бұрын
Sir ek vedio banao refresh karte hi permission karne ke liye mag raha wo hum kahan se sahi kar sakte hai
@apsarshaik9407
4 жыл бұрын
Hi sir, thank you for your videos, which is vary helpfull, i have one challange.. everyday i have to send the cdr (calls count) report every hour, i have tried with power query but the problem is wen ever i replace the data in table the power query piot counting histry(yesturday) count also need help on this plz
@jodhvirsingh8677
3 жыл бұрын
Hello Apsar. I think you would need to make 2 tables (since you need two days data). Table 1 contains todays data and Table 2 contains yesterdays data. Now tomorrow your data needs to shift from table 1 to 2 and new data needs to be added to Table 1. What you can do is record a macro for this and then erase all the hardcoded elements in the vba. Then when you refresh the data your table 1 data would go automatically to table 2 and new data would get entered in table 2. Then refresh the pivot table. Hope it helps.
@nvcworld6423
3 жыл бұрын
How resolve connection issues by VBA ? Every time need to click on connect button 🙄🙄🙄🙄
@emre-cil
3 жыл бұрын
king
@alterchannel2501
Жыл бұрын
The only bad thing about the Selection Change is that you don:t have the "undo" in excel
@madhusudanbehera1651
Жыл бұрын
code = ActiveWorkbook.Connections("Query - invoked_function").Refresh does not work
Пікірлер: 76