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 Count Ifs function and conditional formatting. This tutorial provides a step-by-step guide 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 a simple Apps Script. This tutorial walks you through the steps to create a function that increments a view count every time the sheet is opened.

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 sets for potential fraud. This tutorial covers essential functions like LEFT and COUNTIF to extract and tally 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.

Harada Method Template

Learn how to create the Harada Method template in Google Sheets, a fun and effective way to organize your goals and track your progress. This video guides you through the steps to set up your template with borders, cell references, and formatting.

MonoSpace Font

Learn how to enhance the appearance of numbers in your spreadsheets by using a monospace font, making larger numbers stand out more effectively.

Mordor To Do

In this video, learn how to create a fun and engaging 'Mordor To Do' list using spreadsheet functions like COUNTIF and text wrapping to visualize your progress on a journey.

Weight Tracker Reverse Chronological

Learn how to create a reverse chronological weight tracker in Google Sheets that allows you to easily enter your weight at the top 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 function and the CHOOSE function to generate random numbers between 1 and 6. This tutorial also explores how to incorporate emojis and characters into your sheets.

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

Discover the fun and creative ways to use symbols, emojis, arrows, shapes, and even Braille 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 perfect cruise trip, utilizing powerful functions like COUNTIF to manage your checklist effectively.

Year on a Cell

Learn how to extract just the year from a date in Google Sheets using specific formulas and combinations. This video also explores practical applications for managing yearly data.

Email When Cell Changes

Learn how to set up email notifications in Google Sheets when a specific cell changes, enhancing your CRM's automation 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 plants' progress and care requirements 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 entries, making it easier to track your weight over time.

Coffee Break ToDo List

In this video, learn how to create an efficient ToDo list using spreadsheet formulas, making your coffee breaks more productive.

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 learning experience, from mastering basic formulas to diving into advanced automations with App Script.

How to Filter By Color in Google Sheets

Learn how to filter data by color in Google Sheets with this step-by-step tutorial. Discover how to highlight specific entries and manage your filters effectively.