Quick Steps
Make Power Query easier for longer with our library of easy-to-apply functions
Power Query is easy… until it isn’t… and then it’s really, really hard!
Here’s the truth:
Initially, we can solve a lot of problems in Power Query just by clicking the user interface. This is when we love Power Query, it makes things easy.
But suddenly, problems that are slightly more complex require significantly more complex solutions (and advanced M code skills).
Very quickly, Power Query goes from easy to hard.
And your hopes of using Power Query to save time and stop working late? Dashed.
Say hello to Quick Steps.
Quick Steps is a library of easy-to-use functions that anybody can add to Power Query and implement in seconds.
- Want to remove all empty columns? No problem, we’ve got a function for that.
- Has your input got multiple header rows? No problem, we’ve got a function for that.
- Need to perform an approximate match lookup? No problem, we’ve got a function for that.
The list could go on and on.
For anybody who just wants to get the job done as easily as possible, then this is for you.
Quick Steps makes Power Query easier for longer
THE PROBLEM
Power Query’s learning curve forces us to go from clicking buttons to understanding M code with a low level of complexity.
THE SOLUTION – QUICK STEPS
Quick Steps provides users with ridiculously easy-to-apply transformations for tricky situations.
What’s included in Quick Steps?
Quick Steps is a library of solutions you can add to any Power Query scenario.
- Simple copy and paste solution: Add the functions to Excel, Power BI, or anywhere that Power Query exists.
- Easy-to-use functions: Uses simple, Excel-type syntax, to make functions easy to use.
- Example files: Practice using the functions with example files.
- Reference guide: Syntax, arguments, and examples of each function in the full-color reference guide.
- Video lessons: Short video lessons for each function detailing the arguments and options.
With these functions, you will save months of frustration.
Quick Steps is only available within the Excel Academy.
System requirements:
Windows or Mac | Excel 2016 or later (including Excel 365)
What do others say about Quick Steps?
“I use Power Query daily. I’m capable, but far from an expert. So, when my solution requires too many steps or a solution simply eludes me, I jump to the (always open) PQ Quick Steps Reference to see how to resolve it.
I find a solution every time, whether that’s stripping all non-numerics from a phone number using fxMultiFindReplace or fixing ever-changing column headers with fxRenameColumnsByPosition.
My time is valuable. The hours I’ve saved by using it, make it a bargain at any price.” – David
“I try to do as much as possible in Power Query so I can feed dynamic array reports and PivotTables. I’m currently an intermediate Power Query user, so it can be stressful when trying to do something more advanced.
Being able to use the functions from Quick Steps in a recent project was a huge relief, ask my wife! It sped up the process and eliminated the stress so I could get on with my day.
Now that I’ve got it, I can use it in projects whenever I need to.” – Christopher
“I had been trying to automate PDF conversion for a while but I did not have all the skills to write complex M code to make the solution dynamic and reusable across files.
The use of Quick Steps functions allowed me to accomplish the transformations quickly.
Quick Steps constitutes a powerful and invaluable set of tools that now allows me to do complex transformations fast.” – Felipe
Get started with Quick Steps today.
Join the Excel Academy
Enrol today to get instant access to the Excel Automate Secrets course.
Download the Quick Steps workbook
Get the functions in a simple copy-and-paste format, with documentation, video and examples.
Apply the functions
Add the functions to your queries and start performing advanced transformations with ease.
Quick Steps is only available within the Excel Academy.