Spreadsheet fundamentals

How to See Version History in Google Sheets

Learn how to view and manage version history in Google Sheets, including how to name versions for easy access and tracking changes over time.

How To Make Negative Numbers Red in Google Sheets

Learn how to easily highlight negative numbers in red using conditional formatting in Google Sheets, making your data analysis clearer and more efficient.

Checkbox or Dropdown?

In this video, we explore the differences between using checkboxes and dropdown menus for attendance tracking in Google Sheets, discussing their advantages and limitations based on situational needs.

Quickly CAPITALIZE Headers

Learn how to quickly capitalize headers in Google Sheets using simple functions and shortcuts. This video provides a step-by-step guide to ensure your headers are consistently formatted without manual typing.

How to Copy an Entire Spreadsheet

Learn how to easily copy an entire spreadsheet in Google Sheets, including tips on sharing and utilizing unique URL hacks for exporting and duplicating your files.

How to Move Row To Section in Google Sheets

Learn how to automatically move a row to a specific section in Google Sheets using Apps Script. This tutorial demonstrates how to set up a function that responds to edits in your sheet, making data organization easier.

How to Find Fuzzy Matches in Google Sheets

Learn how to find fuzzy matches in Google Sheets using simple formulas and conditional formatting to enhance your data cleaning process.

How to Convert Text to Numbers in Google Sheets

Learn how to convert text that appears as numbers into actual numbers in Google Sheets, ensuring your calculations work correctly. This video covers various formatting techniques to achieve accurate data representation.

Link Google Sheets to Google Slides

Learn how to efficiently link data from Google Sheets to Google Slides, allowing for dynamic updates and easy access to detailed information in your presentations.

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.