Spreadsheet fundamentals

How to Hide Text Until Checkbox Checked

Learn how to hide text in Google Sheets until a checkbox is checked using the IF formula. This tutorial provides a step-by-step guide to create dynamic messages based on checkbox states.

what you need to know to automate Google Sheets

How To Highlight Timestamps This YEAR

Learn how to highlight timestamps in Google Sheets that correspond to the current year using conditional formatting. This quick tutorial will enhance your spreadsheet skills and help you manage your data more effectively.

How To Highlight Timestamps This Month

Learn how to highlight timestamps or dates that fall within the current month using conditional formatting in Google Sheets. This tutorial provides a step-by-step guide on applying a custom formula to achieve this.

How To Highlight Timestamps Last Month

Learn how to highlight timestamps from the previous month using Google Sheets formulas and conditional formatting techniques. This tutorial walks you through the necessary steps to effectively apply these formulas in your spreadsheets.

How To Highlight Timestamps Over 7 Days Ago

Learn how to highlight timestamps in Google Sheets that are over seven days old using conditional formatting and custom formulas.

How To Calculate Days Since Timestamp in Google Sheets

Learn how to calculate the number of days since a timestamp in Google Sheets using two different formulas, one for exact numbers and another for rounded results.

Automatically Add Formula When Editing Row

Learn how to automatically add formulas in Google Sheets when editing a row using Apps Script. This tutorial covers creating dynamic formulas that adjust based on user input.

How to Highlight Any Date In the Future in Google Sheets

Learn how to highlight any future date in Google Sheets using conditional formatting. This tutorial covers step-by-step instructions to highlight entire rows based on date criteria.

How to Highlight Any Date Before Today Including Today

Learn how to highlight any date in Google Sheets that is today or before using conditional formatting. This quick tutorial will guide you through the necessary steps to apply this formatting effectively.

How To Highlight Any Past Date in Google Sheets

Learn how to highlight past dates in Google Sheets using conditional formatting. This tutorial covers the steps to highlight entire rows based on date criteria.

Apps Script you need to know while using ChatGPT

Learn essential Apps Script techniques to enhance your Google Sheets automation, even when using ChatGPT for coding assistance. This video covers creating functions, setting triggers, and handling edits effectively.

How to Format Numbers with a Comma in Google Sheets

Learn how to format numbers with commas in Google Sheets, including different formats for large numbers and spaces. This tutorial covers custom number formatting techniques to enhance your spreadsheet presentation.

How to Format Numbers with Leading Zeros in Google Sheets

Learn how to format numbers with leading zeros in Google Sheets for various applications like tracking numbers, zip codes, and order numbers. This tutorial provides step-by-step instructions to customize number formats effectively.

How Many Days Until Valentine's Day

Learn how to automate the countdown to Valentine's Day using Google Sheets formulas, ensuring your sheet always reflects the correct number of days remaining.

Automate Expense Tracking in Google Sheets

Learn how to automate your expense tracking in Google Sheets with powerful formulas and Apps Script. This video covers creating dropdown menus, running totals, timestamps, and email alerts for low balances.

How to Replace Vowels with Symbols in Google Sheets

What Day is Labor Day This Year

How to Convert Full Names to Initials in Google Sheets

How to Add Suffix to a Column of Names in Google Sheets

How to Add Prefix to a Column of Names in Google Sheets

Learn how to quickly add a prefix to a column of names in Google Sheets using a single formula with ARRAYFORMULA. This tutorial simplifies the process of enhancing your data with prefixes like 'Dr.' for multiple entries at once.

How to Hide Many Tabs Automatically

Learn how to automatically hide and show multiple tabs in Google Sheets using Apps Script. This tutorial walks you through creating functions and a custom menu for easy access.

How to Translate to Spanish Automatically in Google Sheets

Learn how to automatically translate text from English to Spanish in Google Sheets using a combination of formulas and Apps Script. This tutorial covers both the formula method and a more advanced automation technique.

How to Edit a Named Range's Range

Learn how to edit a named range's range in Google Sheets without changing its name or deleting it. This quick tutorial guides you through the steps to include additional rows in your named range.