Let’s Excel
Published in

Let’s Excel

MS Excel — PowerQuery Can Do That!

A List of Actual Work Use Cases to Get You Thinking!

PowerQuery Can Do That!

Data and data tools seem to be THE hot topic in the business world today. Accounting and finance folks work with data a lot on a daily basis, yet only a minority have heard of or utilized PowerQuery in #excel or #powerbi (that’s my experience from speaking and consulting, and Wyn Hopkins mentions this occasionally in his excellent posts). Tip — follow Wyn on LinkedIn if you don’t already!

I get the question “what does PowerQuery actually do?” My standard response is “it makes work evaporate”.

Somehow, that isn’t specific enough for many people. 🤔

So, from examining how PowerQuery is used on my consulting clients, I put together a list of 26 actual uses. These have a made a huge impact on the daily workflow at these organizations!

Maybe the list will spark a few ideas in your world. Let me know in the comments! Or give me other ways it has benefited you. 🙏

In the document below, there is a link to a shared Google Sheets spreadsheet. Take advantage of it!

You can also view the Google Sheets file from here.

About Don

“It’s time for different”

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat



Up your Excel game — Tips, tricks and efforts that have exponentially increased my productivity!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Don Tomoff

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics