41 - How to Refresh Queries in Excel Power Query

preview_player
Показать описание
In this video, I will show you how to refresh the queries in Power Query.

While you can always manually force a refresh for a query, I will also show you how to use VBA to refresh the query with a button click or even when you make a change in a cell or a drop-down selection.

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

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.

Swizzletwice
Автор

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. 🙌

navinm
Автор

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.

redherring
Автор

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

grzegorz
Автор

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.

Thor_Underdunk_Caballerial
Автор

Thanks for almost entire things about Power query all package in one channel ❤❤❤❤ truly learned a lot Thanks TrumpExcel

nazarkamal
Автор

Very helpful course. It's straightforward and well structured. Thank you!

jing
Автор

Congratulations and thanks - your tuition here saved me a huge amount of time. Really excellent stuff.

poruatokin
Автор

I have been looking for this solution for over a month! Thank you for your instruction. So easy to understand.

alparkson
Автор

Short and simple.. Very useful trick for self learners.. Thank you so much. 🙌🏻

kewal
Автор

One of the Best Playlist 1 Needs to follow if he is interested in Learning Power Query. Thanks Alot Sumit

tabishkhan
Автор

Thank you so much. Exactly what I need.

RamachandranS
Автор

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.

udayteja
Автор

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.

margad-erdeneboldbaatar
Автор

Honestly, great videos and explanation of concepts

vitalisifiokamasi
Автор

great course, watched from beginning to end!

michafabich
Автор

Very useful and well explained. Thank you... !

bessyvalayil
Автор

Learned a lot from the whole series. Thank you very much. Keep up the good work :)

LinhPhan-skti
Автор

Awesome Sir I have finished all your playlist....Hope we will have Part 2 of Power Query.. Thank you Very Much

rtrbs
Автор

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😢

sravankumar