Three Regex Functions in Google Sheets Continuing on with my series on the many marketing uses of regex (aka regular expressions), in this post I … [Read more...]
Regex for Marketers: Plain English, Real World Examples [VIDEO]
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 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...]