Spreadsheet fundamentals

How to Change Ownership of a Spreadsheet

Learn how to change the ownership of a spreadsheet in Google Sheets, including the necessary steps and limitations based on organizational settings.

How to Share Only One Tab in a Spreadsheet

Learn how to share only one tab from a spreadsheet without exposing the entire document. This video covers methods to copy a tab to a new spreadsheet and use the IMPORTRANGE function for real-time updates.

How to Change Access to Shared Sheet

Learn how to change access permissions for users on your Google Sheets, whether it's switching from editor to viewer or vice versa. This quick guide will help you manage your shared sheets effectively.

Is Google Sheets OVERRATED?

In this video, Andrew from Better Sheets evaluates various features of Google Sheets, determining which are overrated, underrated, or correctly rated, including popular formulas and functionalities.

How to Add Access with Expiration to a Google Sheet

Learn how to grant temporary access to your Google Sheets by setting an expiration date for collaborators. This tutorial walks you through the steps to share your sheet with a specified time limit.

How to Remove Access to a Google Sheet

Learn how to easily remove access for individuals from your Google Sheet, ensuring your data remains private and secure.

Tournament Template With Four Automations in Google Sheets

Learn how to automate an Americano tournament in Google Sheets with four unique automations, making it easy to track scores and manage matchups for eight players.

How To Split Column #googlesheets

Learn how to split a full name into first and last names in Google Sheets using the SPLIT function. This tutorial covers selecting the text, setting the delimiter, and applying the function correctly.

Find Name in Phone Number List #googlesheets

Learn how to find the owner of a phone number using the VLOOKUP function in Google Sheets. This video guides you through the process of setting up your formula to retrieve names based on phone numbers.

Advanced Coding Tips in Google Sheets for Programmers

Discover advanced coding techniques in Google Sheets tailored for programmers, including creating custom menus, native-like functions, and developing Google Sheets add-ons to enhance your productivity.

How to do Factorial in Google Sheets

Learn how to easily calculate factorials in Google Sheets using the FACT formula. This video demonstrates the simplicity of using the FACT function to compute factorials for any number.

Advanced Attendance in Google Sheets

Learn an advanced method for tracking student attendance in Google Sheets using checkboxes and Apps Script to maintain a detailed log of attendance records.

Fix a Word Count of Zero #googlesheets

Learn how to fix the word count issue in Google Sheets where blank cells incorrectly count as one. This video demonstrates how to use the IF and ISBLANK functions to achieve accurate word counts.

Checkbox Hacks in #Google Sheets

Discover innovative checkbox hacks in Google Sheets to streamline your approval processes and enhance functionality. Learn how to customize checkbox values and create dynamic approval systems with ease.

How to highlight every other row #googlesheets

Learn how to highlight every other row in Google Sheets using conditional formatting with custom formulas for odd and even rows.

How to Rename a Sheet based on a Date Automatically

Learn how to automatically rename a Google Sheet based on a date using Google Apps Script. This tutorial covers setting up triggers to rename your sheet daily or based on specific actions.

Create New Worksheet When Google Form Submitted

Learn how to automatically create a new Google Sheet from a template every time a Google Form is submitted, perfect for consultants and service providers looking to streamline their workflow.

Capitalize all words or no words in #GoogleSheets

Learn how to capitalize all words or none in Google Sheets using the PROPER and LOWER functions. This video provides a quick guide on applying these formulas effectively.

How to Take Attendance in Google Sheets

Learn how to efficiently take attendance in Google Sheets using checkboxes, formulas for counting, and calculating attendance percentages.

How To Reference Cell In Another Sheet #googlesheets

Learn how to reference a cell from another sheet in Google Sheets with simple formulas and techniques, including using the name box for easier referencing.

How To Delete All Empty Rows #googlesheets

Learn how to efficiently delete all empty rows in Google Sheets without the hassle of keyboard shortcuts. This video introduces a simple add-on that streamlines the process.

How To Split Columns with a Comma #googlesheets

Learn how to efficiently split columns in Google Sheets using the split function, specifically for separating first and last names with a comma delimiter.

Automated Project Management Notifications in Google Sheets

Learn how to automate project management notifications in Google Sheets using Apps Script. This tutorial covers creating dropdowns for project statuses, sending automated emails, and managing project assignments efficiently.

How to Remove Rows in Google Sheets Automatically

Learn how to automatically remove rows in Google Sheets using Apps Script and custom menus. This video covers both semi-automatic and fully automated methods for efficient row management.