Learn how you can build a custom currency exchange rate monitor in your spreadsheet, or import financial data using API without a single line of code.
Check out both formula and formula-free solutions to combine data ranges with a different number of columns from multiple sheets into one.
Check out the formula and no-formula solution to combine tabs from an internal or external Google Sheets file into one master view
Check out a complete guide that provides examples on how to use ARRAYFORMULA with SUMIF, VLOOKUP, and other Google Sheets functions.
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.