spreadsheets

A collection of 3 posts

spreadsheets

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

google sheets

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

excel

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