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...]
How To Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]
Measuring year-over-year growth in your analytics data is oftentimes much more important than month-over-month traffic trends, especially if your … [Read more...]
The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]
Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The … [Read more...]
Video Walkthrough Of An Excel Dashboard
I hesitate including this video in a blog post because it's primarily promotional and was created for my seminar landing page. But I decided to blog … [Read more...]
A Comprehensive Guide To Excel Charts For Marketers [VIDEO]
As marketers, the most important skill you need in Microsoft Excel is the ability to create and manipulate charts (followed by how to work with pivot … [Read more...]