Learn all possible options to total values with and without conditions in Google Sheets in one blog post about SUM, SUMIF, and SUMIFS.
Learn the basics of ETL (extract-transform-load) process and check out how it works in the example of a real-life ETL tool.
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 the most common errors of IMPORTRANGE formulas and learn how you can fix them. To avoid errors and fails, use a reliable IMPORTRANGE alternative.
Do you use Excel for heavy calculations and want to import the results to Google Sheets for sharing? Read this tutorial to learn how you can do this.
Learn how to export QuickBooks reports such as Balance Sheet, Profit and Loss, and others to Google Sheets. No coding skills required.
Choose the best way to export OneDrive or Dropbox CSV files to Google Sheets: Coupler.io, a GSheets add-on, or IMPORTDATA.
Track your personal spending easily and learn how to import your bank transactions to Google Sheets without coding.