One thing I like to do when doing a competitive analysis for a client is rifle through their backlinks vis-a-vis their competitors' and reverse … [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...]
How To Create A Cool Heat Map Like Avinash Showed At MozCon
In Avinash Kaushik's presentation at MozCon, he showed a really cool heat map that showed number of goal completions (for the most part) segmented by … [Read more...]
How To Create A Dynamic Chart From A Pivot Table [VIDEO]
In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel's best-kept secrets) to divide a list of keywords … [Read more...]
[VIDEO] Excel Bug In Pivot Charts On The Mac
As I mention in my post on creating pivot charts, you can't create pivot charts in Excel for the Mac. It's, hands down, my greatest aggravation with … [Read more...]