The Named range feature found in both Excel and Google Sheet gives the user the ability to name a range of cells with a label that is more memorable than the built in spreadsheet range format of “Sheet!ColumnRow:ColumnRow” (e.g. ‘Excel - Test - One’!A15:AF255’). While there are a few Excel wizards out there that have the ability to interpret the built in reporting format without switching sheets or scanning cells, the majority of users will most likely find this memorization difficult and there is absolutely no shame in that. Named ranges removes these requirements with
An underused feature of Google Sheets that I find to be a major reason to use the software over excel (yes I said it) is the IMPORTRANGE() Function. It is a function that doesn’t exist in other spreadsheet platforms and is specifically tied to the collaborative cloud-based capabilities that Google Sheets has to offer. Pass a Google Sheet Url ID and a specific range within that sheet to the function and next thing you know, the content of those cells appear in your current sheet...Wow, how amazing, right? Probably not spectacular or useful at first, but when you
A fun challenge that I faced a few days was creating a weekday/weekend day index in Google sheets to count and index the number of weekdays/weekends in a month. This might sound like something easily achieved by placing a static value next to the date based on the preceding index value and day of the week, but the more this process has to be replicated, the more boring and tedious the task will become. This process is simply not for me as I hate manual excel work. As a result, I decided to take some additional time to
Manually populating spreadsheets with Google Analytics data on a weekly or daily basis is a time consuming task.The typical report building format follows the uniform process of generating a custom report, exporting that data to an excel format and then pasting the values into a customized reporting format. This is a pretty common practice that results in a major waste of time and resources for companies of all sizes. In order to avoid this process and regain the time and resources that are lost, exploration of an automated solution has to be a high priority. Thankfully there is a
Connor Phillips is a Senior Marketing Analyst located in New York City. He enjoys digging into data and making data-driven marketing decisions. In his spare time he bartends, works on coding and loves to run.