Category: Google Sheets tutorials

Learn the ultimate tutorial on how you can export your Google Calendar events to Google Sheets without coding or using the Apps Script.

Discover all the options that will let you remove duplicate entries from your data set in Google Sheets in one tutorial.

Read a detailed tutorial about the power of GOOGLEFINANCE function in Google Sheets with real-life examples.

Discover the ultimate guide on how to import your reports from Google Analytics to Google Sheets using the native Google Analytics add-on

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