The INDIRECT function in Google Sheets takes in the cell address in the form of text and returns a cell reference. It...
How to use the INDIRECT function in Google Sheets
read more
Spreadsheets articles
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...
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...
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...
How to use the INDEX function in Google Sheets
The INDEX function in Google Sheets returns the value of a cell within an input range, relatively separated from the...
How to connect Excel to Google Looker Studio
Google Data Studio is a powerful visual reporting tool that allows you to transform a sea of raw data into engaging...
10 Remote work productivity templates in Google Sheets
Working from home, or working remotely, can come as a big shock if you haven't done it before. And if you're a...
5 Best practices for spreadsheet data structure
Spreadsheets are one of the most widely-used pieces of software in the world. Over 1 billion people use them to...
Combine QUERY with IMPORTRANGE in Google Sheets
Combining QUERY with IMPORTRANGE allows you to pull in data from different spreadsheets and perform advanced queries...
English 
Español 
Português do Brasil 
Français