Spreadsheet fundamentals

How to Convert Student Names to Emails

Learn how to convert student names into email addresses using Google Sheets by substituting spaces with either nothing or dots. This tutorial covers the use of the SUBSTITUTE function and ARRAYFORMULA for efficient email generation.

How to Change Font in Google Sheets

Learn how to change fonts in Google Sheets, including selecting from default options and adding new fonts. This video also covers conditional formatting to enhance your spreadsheet's appearance.

Add a Button To Automate Add a Row with Date

Learn how to create a button in Google Sheets that automatically adds a new row with the current date, streamlining your data entry process.

How to Delete Every Checked Row

Learn how to quickly delete every checked row in Google Sheets using App Script with a simple function. This tutorial walks you through the process step-by-step, ensuring you can automate your spreadsheet tasks efficiently.

How to Reverse First and Last Name and Add Comma Between in Google Sheets

Learn how to reverse first and last names in Google Sheets using a simple formula that adds a comma between them. This tutorial provides a step-by-step guide to automate the process for multiple names effortlessly.

Simple Daily Reminder Email in Google Sheets

Learn how to set up a simple daily reminder email in Google Sheets using Apps Script, ensuring you never forget to check your tasks list again.

Add a Button To Automate Add a Row with Priority Status

Learn how to create a button in Google Sheets that automatically adds a new row with a priority status using Apps Script. This tutorial simplifies the process of managing tasks by allowing you to set priority levels with just a click.

Inventory Button in Google Sheets

Learn how to create inventory buttons in Google Sheets using App Script to easily increase or decrease inventory counts with just a click. This tutorial simplifies inventory management by automating the process, ensuring accurate tracking of stock levels.

Move Completed to Bottom of Google Sheet

Learn how to automate the process of moving completed tasks to the bottom of your Google Sheets using Google Apps Script. This tutorial walks you through the necessary code and logic to streamline your task management.

How To Add Bullet Points In Google Sheets

Learn how to easily add bullet points in Google Sheets using a simple keyboard shortcut. This video also covers tips for enhancing your spreadsheets with checklists and emojis.

How to Show Month Name, And Not Whole Date, in Google Sheets

Learn how to display only the month name from a date in Google Sheets while keeping the original date data intact. This tutorial provides a step-by-step guide to formatting your dates effectively.

Add a Button To Automate Add a Row with Assignee Name

Learn how to automate adding a row in Google Sheets with a button that assigns a specific person to the task, streamlining your workflow with just one click.

How to Convert Words to Hashtags in Google Sheets

Learn how to easily convert phrases into hashtags in Google Sheets using a single formula with array formulas. This video provides a step-by-step guide to streamline your hashtag creation process.

How to Reverse a Word in Google Sheets

Learn how to reverse a word in Google Sheets using a formula that combines various functions to achieve the desired result. This video also explores how to check if the reversed word is a palindrome.

Automate The Year in Google Sheets

Learn how to automate the year in Google Sheets using the TODAY function and the YEAR formula, ensuring your spreadsheet updates automatically as the year changes.

How to Change the Color of a Cell

Learn how to change the color of a cell in Google Sheets, including background colors and text adjustments, to enhance your spreadsheet's visual appeal.

How to get a Random Number Every Hour in Google Sheets

Learn how to generate a random number every hour in Google Sheets using the Rand and Rand Between functions, and set your sheet to auto-update for dynamic data display.

How to Add Column Automatically for Habit Tracking

Learn how to automatically add a new column to your habit tracker in Google Sheets every day using Google Apps Script. This tutorial covers the necessary steps to set up the script and triggers for seamless automation.

How To Delete Extra Columns In Google Sheets

Learn how to efficiently delete extra columns in Google Sheets using built-in features and the Tiny Sheets extension for a cleaner spreadsheet experience.

How to Share a Single Tab with Clients Without Exposure to Other Data

Learn how to create a secure client portal in Google Sheets that allows clients to view a single tab without accessing other data, using simple formulas and no Apps Script.

Add a Button To Automate Add a Column with Date for Inventory

Learn how to create a button in Google Sheets that automatically adds a new column with the current date as the header, streamlining your inventory management process.

Create Button in Sheets to Other Sheets

Learn how to create interactive buttons in Google Sheets that link to other sheets using a simple script. This tutorial walks you through the process step-by-step, making it easy to enhance your spreadsheet navigation.

How To Strikethrough in Google Sheets

Learn how to use strikethrough formatting in Google Sheets, including how to automate it with checkboxes and conditional formatting for better task management.

How to Create Checklist that Unchecks Daily

Learn how to create a daily checklist in Google Sheets that automatically unchecks itself every morning using Apps Script. This tutorial covers the necessary code and how to set up triggers for automation.