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

ifs-function-google-sheets

How to use the IFS function in Google Sheets

The IF function in Google Sheets enables logical decision making with a simple if-else structure. It checks whether a condition in a cell...
search-function-google-sheets

How to use the SEARCH function in Google Sheets

The Google Sheets SEARCH function returns the position of a substring within a text. It is the right tool if you need to find a specific...
split-function-google-sheets

How to use the SPLIT function in Google Sheets

The DCOUNTA formula in Google Sheets counts the number of values in a table-like array or range that meet specific criteria. It is similar...
index-match-function-google-sheets

How to use the MATCH function in Google Sheets

In Google Sheets, the MATCH function gives you the relative position of an item within a range of cells. Basically, if you want to know...
correl-function-google-sheets

How to use the CORREL function in Google Sheets

When you're carrying out data analysis, statistical measures help you to understand underlying trends. One of the most common statistical...
index-match-function-google-sheets

How to use the IF function in Google Sheets

IF follows an else if logic and is one of the most useful Google Sheets functions. You can use it to perform logical tests on your...
TODAY-function-google-sheets

How to use the INDIRECT function in Google Sheets

The INDIRECT function in Google Sheets takes in the cell address in the form of text and returns a cell reference. It works in the...
sort-function-google-sheets

How to use the Google Sheets SORT function

The Google Sheets SORT function allows you to sort data and return the rows in ascending or descending order. It is useful to sort text,...
lookup-function-google-sheets

How to use the Google Sheets LOOKUP function

The Google Sheets LOOKUP function searches through a row or column for a key and returns the value of the cell in a result range located...

How to use the GOOGLEFINANCE function in Google Sheets

The GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google Sheets. It also enables...