Author

Valentine Schelstraete

Helping SaaS find their right buyer personas and generate organic traffic to build their user and customer base rapidly. Interested in all things product marketing, providing the best product/service to the right profile, and how to scale your tech business.

Latest posts

weekday-function-google-sheets-featured-image

How to use the WEEKDAY function in Google Sheets

There will be instances where we may need to know the day of the week, for a given date. In Google Sheets, the WEEKDAY function can help...
hlookup-function-google-sheets-featured-image

How to use the HLOOKUP function in Google Sheets

The HLOOKUP function is perhaps not as famous and widely used as its counterpart, VLOOKUP function. However, the two functions are the...
How to use the filter function in google sheets

How to use the FILTER function in Google Sheets

The FILTER function in Google Sheets helps you filter and return rows in a range that meet specified criteria. You can also add multiple...
eomonth-function-google-sheets-featured-image

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 a month that is a...
counta-function-google-sheets-featured-image

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 gives you the total...
address-function-google-sheets-featured-image

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 address is a string...
switch-function-google-sheets

How to use the SWITCH function in Google Sheets

This Google Sheets SWITCH evaluates an expression against a set of specific cases. The first case to evaluate as TRUE will return a...
google-sheets-offset-function

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 reference cell. You specify...
SUMPRODUCT-function-google-sheets

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 sum of the results....
TODAY-function-google-sheets

How to use the TODAY function in Google Sheets

The Google Sheets TODAY function returns the current date and time, based on the user’s computer settings. It’s a dynamic or “volatile”...