Combining the power of VLOOKUP and IMPORTRANGE is a great way to transfer specific data between two spreadsheets....
How to use VLOOKUP and IMPORTRANGE in Google Sheets
read more
Spreadsheets articles
How to filter IMPORTRANGE
There are many reasons to filter IMPORTRANGE results. You may want to share only some data and not an entire...
Is IMPORTRANGE not working? Learn how to fix it
In this article we will go over the most common IMPORTRANGE errors and how to fix them. Every error will be grouped...
How to use Google Sheets for currency conversion
Staying up to date with the latest conversion rates can be a daunting task. But it doesn’t have to be. Read on to...
How to subscript in Google Sheets
Google Sheets doesn’t have a feature to add subscript text easily like in Google Docs. However, it is possible to...
How to superscript in Google Sheets
Adding superscript in Google Sheets is not as simple as it is in Google Docs. Still, there are a couple of workarounds...
How to merge cells in Google Sheets
Learning how to merge cells in Google Sheets can significantly enhance your spreadsheets, but do it cautiously because...
Countif greater than 0 Google Sheets
At its core, countif is super simple: it counts every cell that meets a condition. Countif greater than 0 is just one...
How to fill down Google Sheets – save time with these shortcuts
Learn how to fill down Google Sheets, a great feature that will let you replicate data across spreadsheets...
English 
Español 
Português do Brasil 
Français