Log In
Register
Home
New Member
June 7, 2022
Offline
Hi everyone! I am a decent excel user here who is not super advanced but knows most of the easy functions and is interested in using power query at work. However I’m struggling to find the right reward vs. time spent threshold to actually use this. Does anyone here have a great example of using power query in a Corp role to automate daily or weekly routines? Hopefully this will give me some inspiration on what to use this for 🙂
July 16, 2010
Offline
Hi Khunsu,
Welcome to our forum! Please see my introduction to Power Query video where I demonstrate a few uses for it. Hope that gives you some inspiration. It's definitely worth learning. When you're ready you can get started with my comprehensive Power Query course.
Mynda
Trusted Members
February 13, 2021
Offline
Hi Khunsu,
I used it just the other day for inventory. I took a report after some things were received and I needed older totals, I uploaded a spreadsheet with the old totals that I needed, did some transformations and what would have taken me forever to re-input numbers and make sure they were all correct and then doing calculations, etc. took a couple of hours. That's an example of a single-use query, I won't use that query again so I deleted the query to just use the table.
I have another query that brings in tables from the workbook to create a list of vendors, amounts, and a brief description of the invoices to send to the city, I no longer have to enter information twice.
I have a spreadsheet I made for a co-worker where he marks tasks to get done by certain employees and refreshes the query and that makes its transformations and spits it out onto a pivot table so he can view and print his tasks by employee, day of the week, or week number.
Power Query is the one Excel tool that I haven't had to find ways to use, the projects come in and I have said from the get-go "I can use PQ for this task!" And BOOM! Just like that my work life is better!
You won't regret learning this tool, it's amazing!
1 Guest(s)
