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 […]
Month: December 2016
Excel & Power Query Campaign Builder for Paid Search: Step By Step Demo
In today’s post, we will have a look at a step by step demo of Power Query campaign builder. Watch the 4 minute video below showing how the campaign builder is built from nothing to full campaign setup. As you could see, all you needed is 6 sample tables to start with, then the entire […]