Power Query Tricks: Filter & Sort Data Like a Pro

Excel gives you many ways to do similar things and when it comes to Power Query it's no exception. You might be familiar with simple filters or using the Advanced filter capabilities. You may also be familiar with sorting and doing multi level sorts in Excel. You can do similar things with Power Query, but the nice thing is that if you have data that gets refreshed often, once you set up the filter or sorting criteria it just become a one button refresh to do the filter or sort.

Say goodbye to the headaches of unmanageable data and hello to smooth, streamlined data processes. In this video, we'll walk you through the most efficient techniques to organize your information, making it more accessible and useful for your projects. Get ready to transform your data into a powerful asset with ease.

0:00 Intro
2:19 Sorting in Power Query
5:36 Filtering in Power Query

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[SyedUsman]

You could do the OR sorting with advance filter.

[robsherman]

I don't have the Custom Filter option available? Is there a setting that will allow it to be presented as an option for me?

[ericerickson]

Great video, just please slow down your speech. I kow I can slow it down myself but then you sound drunk. I take away alot from your tutorials and really appreciate your effort, just please slow down a little.