Spreadsheet fundamentals

Get Nutrition Facts From Barcode in Google Sheets

Learn how to extract nutrition facts from barcodes using the Open Food Facts API in Google Sheets. This tutorial covers setting up API calls and creating custom functions for seamless data retrieval.

Select Whole Row Keyboard Shortcut #googlesheets

Learn how to quickly select an entire row in Google Sheets using a simple keyboard shortcut. This efficient method saves time and enhances your spreadsheet productivity.

Make PayPal.me Links in Google Sheets

Learn how to create PayPal.me links directly in Google Sheets to streamline payment requests for your items. This video demonstrates a simple method to concatenate prices into a shareable link for easy transactions.

TWO SHEET TIMEZONES

Learn how to manage two different time zones in your Google Sheets, ensuring your app scripts function correctly by setting the appropriate time zone in both spreadsheet and project settings.

SHEETS and SHEET NEW FORMULAS in Google Sheets

Discover the exciting new formulas, 'sheets' and 'sheet', in Google Sheets that allow you to count tabs and retrieve sheet indices in real-time. Learn how to effectively use these formulas to enhance your spreadsheet management.

Take Control of a Column in Google Sheets

Learn how to effectively manage and control entire columns in Google Sheets to enhance your spreadsheet experience.

How To Send Google Doc Text to Google Sheets

Learn how to automate the process of sending text from a Google Doc to a specific cell in Google Sheets using Google Apps Script. This video guides you through creating a custom menu and writing the necessary functions to streamline your workflow.

Average Without Zeros in Google Sheets

Learn how to calculate the average of a range in Google Sheets while excluding zeros using the AVERAGEIF function. This quick tutorial will help you get accurate averages without manually deleting zero values.

VIBE CODE GOOGLE SHEETS

In this video, learn how to automate repetitive tasks in Google Sheets using formulas and App Script, specifically for crochet pattern creation. Discover tips on using functions like REPT and SEQUENCE to streamline your workflow.

How To Change Display Language in Google Sheets

Learn how to change the display language in Google Sheets to better suit your needs, whether it's Spanish, Swahili, or any other language. This quick tutorial guides you through the steps to customize your Google Sheets experience.

Scrape H1 in Google Sheets

Learn how to scrape H1 tags from multiple URLs using a custom function in Google Sheets with Apps Script. This tutorial simplifies the process of extracting important header information from web pages.

Calculate Reading Time with Custom Function in Google Sheets

Learn how to create a custom function in Google Sheets to calculate reading time based on word count and words per minute, enhancing your spreadsheet capabilities.

Get Tab Name in Cell

Learn how to get the tab name in a cell using a custom function in Google Sheets. This video walks you through the steps to create a simple app script that retrieves the active sheet's name.

Keep Data Hidden in Google Sheets

Learn how to keep sensitive data hidden in Google Sheets by using named ranges and custom functions in Apps Script. This video demonstrates how to create a more secure way to manage identifiers without displaying them directly in your sheets.

Automatic Certificate Creation in Google Sheets

Learn how to automate the creation and emailing of certificates in Google Sheets using Google Slides and Apps Script. This tutorial walks you through the steps to set up your spreadsheet, write the necessary code, and send personalized certificates as PDFs.

How To Add Emojis to Google Sheets

Learn how to easily add emojis to your Google Sheets using keyboard shortcuts and other methods to enhance your spreadsheets.

SUM From Date to Date in Google Sheets

Learn how to sum values between specific dates in Google Sheets using the SUMIFS function. This video provides a step-by-step guide to correctly setting up your criteria for date ranges.

Count Color by Row

In this video, learn how to count rows in Google Sheets by their background color using Google Apps Script. Discover how to create custom functions to automate this process and visualize your data effectively.

Get Full Year API with Google Sheets

Learn how to turn a Google Sheet into a full-year API that automatically updates, allowing you to share specific data with others securely. This tutorial covers the steps to create and deploy a web app using Google Apps Script.

Automatically Replace Words in Google Sheets

Learn how to automatically replace words in Google Sheets using both the SUBSTITUTE formula and Google Apps Script for real-time editing. This video provides step-by-step instructions to enhance your spreadsheet skills.

Change Font on Every Sheet Tab

Learn how to automatically change the font on every sheet tab in Google Sheets using a few lines of Apps Script. This simple tutorial guides you through the process step-by-step.

Quick Follow Up Email

Learn how to automate sending follow-up emails directly from Google Sheets using Google Apps Script. This tutorial walks you through setting up the script to send personalized emails based on task assignments.

How to Hide Rows Marked Complete in Google Sheets

Learn how to automatically hide rows marked as 'Complete' in Google Sheets using Google Apps Script. This tutorial walks you through the process step-by-step, ensuring your task list stays organized.

Scrape Google Maps in Google Sheets

Learn how to scrape Google Maps data directly into Google Sheets using Google Apps Script. This tutorial covers setting up the API key, writing the script, and customizing your queries for effective data retrieval.