Google Doc Functions

… feature for creating date pickers that makes this process a breeze for your dashboard users. I show you how to use the TEXT function to convert these dates to the format used in the Google Analytics report URLs. Click for larger image You can get a date picker in Excel, but it’s much more complicated (thanks, Obama). In Excel 2013 for PC users you…

… Google Sheets doesn’t have a Remove Duplicates option, like Excel does. However, you can still use Google Sheets for your duplicate data removal needs! In this video, I’ll show you how to remove duplicate values from a list in Google Sheets using the UNIQUE function. I really wish Excel had this function. Two other mad-cool Google Sheets…