Linking Data Between Google Sheets
| 1 min read
How to use IMPORTRANGE, the function that allows you to import data from a separate Google Sheet.
spreadsheets
A collection of 6 posts
Sync Google Analytics Data To A Google Sheet
| 3 min read
Yes, there is a Google Sheets plugin that will allow you to run Google Analytics reports in a Google Sheet via the API call. In the supporting article I will show you how to use this tool.
Bulk Updating Cell Ranges On Various Worksheet Tabs At Once
| 1 min read
Bulk update cell ranges across multiple worksheet tabs in Microsoft Excel
Named Range: The Spreadsheet Timesaver
| 3 min read
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
IMPORTRANGE() - Google Sheets Most Powerful Function
| 4 min read
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
Creating a Day Index in Excel and Google Sheets
| 6 min read
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
