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!

Recommended from Medium

CS 371p Fall 2020 Jonathan Granier

Women in Tech: Started from the top, now we’re here

Weeknote 1 — South of the river calls

If you read one article about opportunities using DIGITAL MARKETING, Read this one!

No more experts. Learners instead.

*CUPOM DE 100% DE DESCONTO* — A introdução completa à criação de cursos online / The Complete…

How to Get Recruiters to Contact You

From The Inside Out: An Interview with Model Sandra Martens

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

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

More from Medium

Data Entry in Excel

A Beginner’s Guide to Power BI

Google Sheets Functions — NOW, TODAY, DAY, MONTH, YEAR

MS Excel and Power BI: My Jump-start Tools to Data Analytics