Category: Google Sheets tutorials

Learn all possible options to total values with and without conditions in Google Sheets in one blog post about SUM, SUMIF, and SUMIFS.

Read this blog post to become a professional in sharing Google sheets and spreadsheets. Learn how to share one tab only, including answering the question of how to share a spreadsheet with non-Gmail users.

Learn the fundamentals of using pivot tables in Google Sheets to manipulate and organize your data efficiently.

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