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...]
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...]
Email Attachments Up To 10GB Using Google Drive
I noticed an extra icon in my Gmail and decided to explore it. Turns out, Google has dialed up its Gmail/Drive integration by allowing users to send … [Read more...]