Better Sheets on YouTube

Add Zero in Front of Phone Number

Learn how to add a zero in front of phone numbers in Google Sheets without complicated formatting. This quick tip ensures your numbers display correctly while maintaining flexibility in input.

The Ultimate Weight Tracker Template

Discover the ultimate weight tracker template that combines powerful features to help you achieve your weight loss goals effortlessly. With automated reminders, goal setting, and integration with Google services, this template ensures you stay accountable and motivated.

Highlight Duplicates of Two Columns

Learn how to highlight duplicates across two columns in Google Sheets using the COUNTIFS function and conditional formatting. This tutorial provides step-by-step instructions to effectively identify and manage duplicate entries.

How to Count Views of Google Sheets

Learn how to count the number of views on your Google Sheets using Google Apps Script. This tutorial walks you through the steps to implement a simple script that tracks viewer activity.

Mood, Food, Tude Weight Loss Tracker

In this video, learn how to enhance a simple weight tracker by incorporating mood, food, and attitude tracking using Google Sheets and Apps Script. Discover how to automate daily entries and create a visually appealing heat map to analyze your emotional and dietary patterns.

Messy Sales Pipeline CLEANED UP

In this video, learn how to transform a messy sales pipeline spreadsheet into a visually appealing and functional dashboard using checkboxes and conditional formatting, making it easier for sales reps to track their progress.

Month in a Cell

Learn how to display the full month name in a cell using Google Sheets by formatting numbers and customizing date and time settings.

Count First Digit of Cell

Learn how to count the first digit of numbers in Google Sheets using Benford's Law to analyze data for potential fraud. This tutorial covers the necessary formulas and techniques to extract and count first digits effectively.

Week Progress Bar

Learn how to create a weekly progress bar in Google Sheets using the WEEKDAY function and checkboxes to visually represent the days of the week. This tutorial also explores different numbering systems for weekdays.

Harada Method Template

Learn how to create a fun and effective Harada Method template in Google Sheets, inspired by Shay Otani's success. This video guides you through the steps to design a customizable and visually appealing template.

MonoSpace Font

Learn how to enhance your spreadsheet's readability by using monospace fonts, making larger numbers stand out more clearly. Discover various font options to improve your Google Sheets experience.

Mordor To Do

In this video, learn how to manage your to-do list using Excel functions like COUNTIF while embarking on a fun journey to Mordor. Discover tips for visualizing progress and organizing tasks effectively.

Weight Tracker Reverse Chronological

Learn how to create a reverse chronological weight tracker in Google Sheets that allows you to easily input your weight without scrolling. This tutorial covers the use of Google Apps Script to automate daily entries.

Roll Dice

Learn how to roll dice in Google Sheets using the RAND and CHOOSE functions to generate random numbers between 1 and 6. This video also explores how to incorporate characters and emojis into your sheets.

Symbols, Emojis,Arrows, Shapes, Braille & Fun in Google Sheets

Discover the fun and creative ways to use symbols, emojis, and shapes in Google Sheets with the CHAR formula. Learn how to enhance your spreadsheets with unique characters for checklists, progress bars, and more.

Cruise Trip #spreadsheetmagic

Join us as we explore spreadsheet magic to plan your cruise trip, utilizing powerful functions like COUNTIF and checkboxes for effective organization.

Year on a Cell

Learn how to extract just the year from a date in a cell using a specific formula combination in Google Sheets.

Email When Cell Changes

Learn how to set up email notifications in Google Sheets when a specific cell changes, enhancing your CRM's efficiency and keeping you updated without manual checks.

Gardening To Do List #googlesheets

Learn how to create a gardening to-do list in Google Sheets that helps you track your plant growth and manage tasks effectively.

Simple Weight Tracker Automatic Add Row

Learn how to create a simple weight tracker in Google Sheets that automatically adds a new row for daily weight entries. This tutorial covers using Google Apps Script to automate the process and set triggers for daily updates.

Coffee Break ToDo List

In this video, learn how to create an efficient ToDo list using Excel formulas, making your task management smoother and more organized.

How to Sort by Color in Google Sheets

Learn how to sort your data by color in Google Sheets, allowing you to prioritize specific colors in your spreadsheet for better organization.

Google Sheet Side Quests

Explore various Google Sheet side quests that enhance your spreadsheet skills, from mastering basic formulas to automating tasks with App Script. Learn how to leverage advanced features like data validation, custom functions, and triggers to unlock the full potential of Google Sheets.

How to Filter By Color in Google Sheets

Learn how to filter data by color in Google Sheets, specifically how to highlight and display only the rows with a selected fill color. This step-by-step tutorial will guide you through the process of creating and removing filters.