Spreadsheet fundamentals | Better Sheets on YouTube

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.

How to Rename a Named Range in Google Sheets

Learn how to easily rename a named range in Google Sheets, whether through the name box or the named ranges menu. This quick tutorial also covers how to delete a named range if needed.

Simple Inventory Management Automations

Discover how to create simple inventory management automations using Google Sheets, including conditional formatting, automated emails, and timestamps for stock updates.

How to Calculate Percentage of Total Column in Google Sheets

Learn how to calculate the percentage of a total in Google Sheets, including formatting percentages and using absolute references to maintain correct calculations when copying formulas.

If Date is Passed, And Done, Hide Text

Learn how to hide overdue text in Google Sheets when a task is marked as done using a combination of IF and TODAY functions. This video builds on previous concepts to enhance your spreadsheet management.

If Date is Passed, How to Show Overdue

Learn how to determine if a date is overdue in Google Sheets using conditional formatting and logical expressions. This tutorial covers the use of the IF function and how to enhance your project management with effective date tracking.

Delete A Row When Writing a Certain Word

Learn how to automatically delete a row in Google Sheets when a specific word, like 'CANCEL', is entered. This video covers the use of Apps Script to enhance safety and functionality in your spreadsheets.

Get Percent For Certain Criteria in Column

Learn how to calculate the percentage of yearly sales for individual salespeople in Google Sheets, focusing on specific criteria to get accurate results.

Things to Think About When You Share a Sheet

This video discusses essential considerations for sharing Google Sheets, including naming your sheet, choosing the right sharing settings, and understanding access levels for collaborators.

How To Unhide Rows In Google Sheets

Learn how to easily unhide rows in Google Sheets with this quick tutorial. Discover the different methods to reveal hidden rows and enhance your spreadsheet experience.