Sheetgo Blog
Your go-to resource for all things spreadsheet related
How to use the EOMONTH function in Google Sheets
The EOMONTH function in Google Sheets stands for “End Of MONTH“, and rightly so. It returns the last calendar date of...
How to use the COUNTA function in Google Sheets
The COUNTA function in Google Sheets is a simple and widely-used function for everyday spreadsheet work. It quickly...
How to use the ADDRESS function in Google Sheets
The ADDRESS Google Sheets function returns a cell’s address in the form of a text. It is noteworthy that the resulting...
How to use the SWITCH function in Google Sheets
In Google Sheets, the SWITCH function works in a pretty similar way to the nested IF function. The advantage of SWITCH...
How to use the OFFSET function in Google Sheets
The OFFSET function in Google Sheets references a range of cells that are shifted or displaced from a starting...
Automated inventory template in Excel
Do you need a way to manage stock levels in your retail business, office, restaurant, or clinic? Chances are that you...
Top 10 inventory Excel tracking templates
No matter what size business you work in, spreadsheets are a simple and flexible tool for tracking and managing...
How to use the SUMPRODUCT function in Google Sheets
The SUMPRODUCT function in Google Sheets multiplies corresponding items within arrays of equal size and returns the...
How to use the TODAY function in Google Sheets
In Google Sheets, the TODAY function returns the current date, as per the local date and time settings on the user’s...
How to use the IFERROR function in Google Sheets
Google Sheets is an extremely user-friendly and reliable piece of spreadsheet software, but anyone who uses Google...
How to use the IFS function in Google Sheets
The IF function in Google Sheets helps you categorize data using a simple if-then-else construct. It checks whether a...
How to use the SEARCH function in Google Sheets
A spreadsheet is a fantastic tool that allows you to tinker with numbers and also with text strings. When working with...