A few years ago I took some statistics and R courses, and I noticed a peculiar thing: Every one of the instructors across the different training … [Read more...]
How to Dynamically Generate URLs on the Fly in Excel or Google Sheets
Why Include Dynamic Links in Dashboards When I create dashboards, I like to add as many resources as possible for stakeholders who want more … [Read more...]
How To Use Google Fusion Tables: A Simple Guide For Marketers [VIDEO]
My Initial Hesitancy with Fusion Tables I've been aware of Google's Fusion Tables for a couple years but used to be a little leery of them. They used … [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...]
VLOOKUP Tips And Tricks For Marketers [VIDEO]
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...]