In today’s post, we will look at building simple Excel refreshable reports WITHOUT using any macros.
Typical scenario:
- You get files with performance data on a regular basis (daily, weekly). E. g. CSVs, TXTs, XLSs, XLSXs…
- You just want to take these files, drop them into a folder and refresh your pivots without copying & pasting anything, without using macros.
Here is a tutorial showing how you can achieve that in Power Query in 5 minutes. That’s how simple & fast it really is.
***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.***
Of course, in real world, you can make your reports more complicated. You can build one query for combining all AdWords files, then another query for combining Bing Ads files, then another query for pulling data from your CRM and then joining all the previous queries into one. Your options are unlimited.
Do you want to learn how to do Power Query magic? Drop comments & contact details to the section below!
Getting Power Query for Excel:
- Power Query for Excel 2013 is here.
- Power Query for Excel 2016 is built-in under Data>Get & Transform
***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.***