I'm going to start a series called Function Friday where I will share common Excel functions and formulas marketers should learn. I'll kick this … [Read more...]
How To Pull Domains Out Of A List Of URLs In Excel [VIDEO]
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...]