Power Query vs. Excel Functions Cheat Sheet

I often get questions such as “Is Excel function XYZ available in Power Query as well?”. Well, you are now about to find out. Let’s focus on functions which we frequently use in the PPC industry.

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.***

***Do you feel like you need more help? We can help you with PPC Automation and/or with your reporting under our new project MythicalReports.com here.***

Click the link below to open the comparison spreadsheet and have a read yourself. Notice that almost all functions have a dedicated button in Power Query unlike in Excel so it is even easier & faster to work in Power Query than in Excel!

Comparison sheet: https://goo.gl/dJBFwi
Sample Comparison

This is just a short sample, Power Query offers hundreds of functions! You can be pretty sure that your favorite Excel functions exist in Power Query as well.

You can see that functions in Power Query are called similarly as in Excel. There is always a “function type prefix” separated by dot and then the name. You would probably guess the rest of the list if I just showed you few top rows.

So there you have it. Power Query functions are very easy to use, especially with all those available buttons 🙂

I will try to keep the file updated.

DZ

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.***

***Do you feel like you need more help? We can help you with PPC Automation and/or with your reporting under our new project MythicalReports.com here.***

Leave a Reply

Your email address will not be published. Required fields are marked *