Check out the most common errors of IMPORTRANGE formulas and learn how you can fix them. To avoid errors and fails, use a reliable IMPORTRANGE alternative.
There are two ways to import CSV data using Google Drive – IMPORTDATA and Coupler.io. Find out which one fits your needs better.
Learn how to vertically look up data in Google Sheets with VLOOKUP function. Discover the VLOOKUP cheat sheet with essential formula examples
The ultimate guide to the FILTER function Google Sheets with advanced formula examples: FILTER nested with UNIQUE, SUM, REGEXMATCH and other functions.
A detailed tutorial on how to use IMPORTRANGE to import data across spreadsheets, with examples and formulas.
Do you like dashboards? Check out how you can build a post coronavirus dashboard using Data Studio, Google Sheets, Typeform, and Coupler.io.
To navigate around the mobile landscape in data management, here are tips on how you can effectively organize data using the Google Sheets mobile app.
All the functions to merge cells and columns in Google Sheets. Check out formula examples with CONCAT, CONCATENATE, JOIN, TEXTJOIN, SUBSTITUTE and &.
SPLIT is a Google Sheets function to divide data into fragments. Check out how it works, as well as other options to split cells in spreadsheets.
Google Sheets provides plenty of shortcuts to optimize your workflow with spreadsheets. Check out the hotkeys by category and see how they work in action.