The VLOOKUP function in Excel is one of the most essential functions marketers need to master. It's a staple in my tool set because it allows you to … [Read more...]
Give Your Data an Extreme Makeover
I had the privilege of speaking at SMX Advanced today in Seattle with other data aficionados. I took a slightly different approach (for me at least) … [Read more...]
Replicating Google Analytics’ Time Format in Excel
Problem: I want to show Time on Site the way Google Analytics does, but it shows up in Excel as number of seconds when I export. Solution: Run a … [Read more...]