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 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 Remove Duplicates in Google Sheets Using the UNIQUE Function [VIDEO]
Google Sheets doesn't have a Remove Duplicates option, like Excel does. However, you can still use Google Sheets for your duplicate data removal … [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...]
How To Import One Spreadsheet Into Another In Google Drive [VIDEO]
I worked with an editorial team for this project. And editorial teams love working in Google Docs. But managing them can be a bear because … [Read more...]