Spreadsheet fundamentals

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.

How To Unhide A Column In Google Sheets

Learn how to easily unhide columns in Google Sheets with this quick tutorial. Discover the methods to identify hidden columns and how to restore them to view.

How to Delete Google Forms from Google Sheet and Unlink

Learn how to unlink and delete a Google Form from a Google Sheet, ensuring your spreadsheet continues to function correctly. This quick guide will help you clean up your Google Drive by removing unwanted forms.

Create a Google Form for Emails Only

Learn how to create a Google Form that collects email addresses only, ensuring proper validation to capture valid emails. This tutorial walks you through the steps to set up your form and manage responses effectively.

How To Highlight Whole Row if Any Cell is Blank

Learn how to highlight an entire row in Google Sheets if any cell within that row is blank, using conditional formatting and custom formulas.

How to Find All Formulas in Google Sheets

In this video, learn how to find all the formulas in Google Sheets, including a little-known method to access a comprehensive directory of over 500 formulas and their functionalities.

How to Fix Phone Number Formula Parse Errors in Google Sheets

Learn how to resolve formula parse errors caused by phone numbers in Google Sheets, specifically when using the plus sign. This video provides step-by-step instructions to clean up your data and avoid common pitfalls.

You Should Know The Limitations of Data Validation

This video explores the importance of data validation in Google Sheets, highlighting its limitations and how it can enhance your spreadsheet management. Learn how to effectively use data validation to minimize risks and ensure data integrity.

Easiest Way to Create Google Form Connected to a Google Sheet

Learn the easiest methods to create a Google Form connected to a Google Sheet, including quick URL shortcuts and automatic linking through Google Sheets.

How To Send Two Emails in Same Trigger in Apps Script

Learn how to send two emails in the same trigger using Google Apps Script, a simple yet effective method for automating email updates to different recipients on a scheduled basis.

How To Make Cells Bigger in Google Sheets

Learn how to make cells bigger in Google Sheets by resizing columns and rows or merging cells for a cleaner dashboard display.

How to Add Up Many Columns in Google Sheets

Learn how to efficiently add up multiple columns in Google Sheets using simple functions and references, including how to avoid common errors.

How to Add Up a Column in Google Sheets

Learn how to efficiently add up a column in Google Sheets with simple formulas and discover a unique trick to display the sum directly in your header. This video provides essential tips for both beginners and advanced users.

How to Allow only Email addresses in as a Google Form Question

Learn how to restrict responses to only email addresses in a Google Form question using response validation. This video provides step-by-step instructions to enhance your form's data collection process.

How to Allow Only Images Uploaded to Google Form

Learn how to restrict file uploads in Google Forms to only allow image files, ensuring that your expense submission forms receive the correct file types for receipts.

How Many Days Until New Year's Day

Learn how to automate the calculation of days until New Year's Day using Google Sheets formulas, ensuring it always reflects the next upcoming New Year's Day.

How Many Days Until Christmas

Learn how to automatically calculate the number of days until Christmas using Google Sheets formulas, including the DATE_DIFF function and error handling techniques.

Simplify Data Organization with the IFS Function in Google Sheets

Learn how to simplify data organization in Google Sheets using the IFS function to manage class choices effectively. This video demonstrates how to implement the IFS function for multiple conditions and handle errors gracefully.

How to Know the Day of the Week of Any Date

Learn how to determine the day of the week for any date using Google Sheets with two simple methods: utilizing the WEEKDAY formula and custom date formatting.

How to Send Bulk Emails from Google Sheets with Apps Script

Learn how to send bulk emails directly from Google Sheets using Apps Script in this informative tutorial. This video guides you through the process of coding a function to automate email sending to a list of recipients.

How to Get Middle Name from Splitting Full Name in Google Sheets

Learn how to extract middle names from full names in Google Sheets by using the SPLIT function and INDEX to handle names with varying lengths.