I'll admit it: I used to be a regexaphobe. When I was new to analytics, I remember someone sending me a snippet of regular expressions (AKA regex) to … [Read more...]
How To Create Histograms For Marketers In Excel [VIDEO]
Histogram charts are great tools for marketers, but unfortunately Excel doesn't make the process of creating them terribly intuitive. But I'll try to … [Read more...]
21 Real-World Examples Of Concatenating Marketing Data In Excel
Hey! Welcome to another edition of #FunctionFriday! One of Excel’s Swiss army knives for marketers is the ability to concatenate things and stuff. Oh, … [Read more...]
How To See If You’re Trashing Your Analytics With Campaign Tracking
Okay, I'm back from my blogging hiatus. I took a few months off from all blogging (guest blogging as well as my site) to focus on training for myself. … [Read more...]
How To Create Pivot Tables In Excel [VIDEO]
By popular demand, I've created a video walk through of how to create and customize pivot tables. If you haven't use pivot tables, they are especially … [Read more...]