Spreadsheet fundamentals

How to Get People to Fill in Google Forms Faster

Learn a powerful Google Sheets trick to create pre-filled Google Forms that make it easier and faster for respondents to fill them out by automatically including their email addresses.

How to Highlight Edited Cells

Learn how to highlight edited cells in Google Sheets using Apps Script, allowing you to visually track changes with a simple function.

How To Wrap Text in Google Sheets

Learn how to easily wrap text in Google Sheets using menu options and shortcuts to enhance your spreadsheet formatting.

How To Subtract in Google Sheets

Learn how to effectively subtract numbers in Google Sheets using various methods, including the basic subtraction formula and the use of absolute values to find differences.

How to Create URL to SMS a Phone Number in Messages from Google Sheets

Learn how to create a URL that allows you to send SMS messages directly from Google Sheets by formatting phone numbers correctly. This tutorial covers the use of the HYPERLINK function and how to handle common formatting issues.

How to Create URL to Call a Number in Facetime

Learn how to create a URL to call a number in FaceTime directly from Google Sheets using a simple hyperlink formula. This tutorial covers various formats for phone numbers and how to troubleshoot common errors.

How to Fix WhatsApp Number Errors in Google Sheets

Learn how to quickly fix WhatsApp number errors in Google Sheets by removing unwanted characters and formatting your numbers correctly for seamless integration.

How to WhatsApp From Google Sheets

Learn how to create WhatsApp links directly from Google Sheets, ensuring your phone numbers are formatted correctly to avoid errors. This tutorial covers the necessary steps to hyperlink WhatsApp numbers efficiently.

How to Change Time Zone in Google Sheets

Learn how to change the time zone in Google Sheets to ensure your formulas and Apps Script projects reflect the correct time settings. This tutorial covers the steps to adjust your time zone settings effectively.

How to Change the Timezone of Your Apps Script

Learn how to change the timezone of your Apps Script to ensure it aligns with user settings, avoiding potential issues with timestamps across different sheets and users.

How To Duplicate a Template For Every Day of the Year

Learn how to efficiently duplicate a template in Google Sheets for every day of the year using Apps Script, ensuring your spreadsheet remains manageable and fast.

How To Create a Tab For Every Day of the Year

Learn how to create a Google Sheets tab for every day of the year using Apps Script. This tutorial walks you through the process of automating tab creation with a simple script.

How to Continue a Sequence in Google Sheets

Learn how to continue sequences in Google Sheets, whether with numbers, dates, or text, using simple mouse tricks. This video covers various types of sequences and their limitations.

How to Delete Protected Range in Google Sheets

Learn how to easily delete a protected range in Google Sheets with this step-by-step guide. Discover where to find the trash icon and how to confirm the deletion of your protected ranges.

How to Edit Protected Range in Google Sheets

Learn how to edit and manage protected ranges in Google Sheets, including how to change permissions and delete protected ranges effectively.

How to Lock Range in Google Sheets

Learn how to lock a range in Google Sheets to prevent unwanted edits, ensuring your important data remains unchanged while allowing modifications around it.

How to Lock Cell in Google Sheets

Learn how to lock specific cells in Google Sheets to prevent unwanted edits, ensuring your data remains intact as you update your spreadsheet over time.

How to Join Text without Extra Spaces

Learn how to effectively use the TextJoin function in Google Sheets to combine text without introducing extra spaces, even when dealing with empty cells.

Hey! Look At This!

Learn how to effectively draw attention to specific cells in Google Sheets using colors, comments, and shapes like arrows. This video provides tips on making important information stand out in your spreadsheets.

How To Subtract $10 from every Row Quickly for Data Cleaning

Learn how to quickly subtract $10 from every row in Google Sheets while handling text and numbers effectively, ensuring smooth data cleaning without errors.

How To Duplicate a Tab and Move it to the End of your Google Sheets

In this video, learn how to duplicate a tab in Google Sheets and automatically move it to the end of your spreadsheet using Apps Script. The tutorial covers creating a custom menu and scripting the duplication process with date formatting.

How To Make a Table in Google Sheets

Learn how to create a table from scratch in Google Sheets, including how to add data validation and dropdown menus for enhanced functionality.

How To Add Many Columns in Google Sheets

Learn how to quickly add multiple columns in Google Sheets with this easy tutorial. Discover efficient methods to insert many columns at once, enhancing your spreadsheet management skills.

How To Add a Column in Google Sheets

Learn how to efficiently add a column to the far right or left in Google Sheets with this quick tutorial. Master the techniques to enhance your spreadsheet management skills.