Better Sheets on YouTube

Watch with annotated transcripts: formulas, glossary terms, and related guides inline.

New videos

The latest uploads from the Better Sheets channel, newest first

Spreadsheet fundamentals

Core Google Sheets skills: formulas, formatting, charts, and everyday workflows

See all

QR codes in Google Sheets

Learn how to easily generate QR codes in Google Sheets using the image formula. This quick tutorial shows you how to create QR codes for URLs and text with just a few simple steps.

How to Highlight Row based on Text in Cell

Learn how to highlight an entire row in Google Sheets based on the text in a specific cell, using conditional formatting and custom formulas.

How To Get Domain from Emails

Learn how to efficiently extract domains from a list of email addresses using Google Sheets, including advanced techniques with REGEX and array formulas for automatic updates.

What's your favorite keyboard shortcut?

Discover the power of keyboard shortcuts, specifically Command + Arrow, to enhance your productivity in Google Sheets. This video demonstrates how to navigate efficiently through your data using simple key combinations.

TIKTOK EDITS MY GOOGLE SHEET

In this video, discover an experiment with a Google Sheet containing one million checkboxes, allowing anyone to edit it and showcasing the performance challenges that arise. Join the fun as viewers interact with the sheet and explore its unique features.

A Student Taught ME This Google Sheets Trick

Discover an unintuitive yet powerful Google Sheets trick that allows you to combine first and last names seamlessly while keeping your formulas intact, even when sorting data.

Caleb Hammer Audits Google Sheets

In this video, Caleb Hammer audits Google Sheets, highlighting common errors like VLOOKUP reference issues and offering tips on formatting and using formulas effectively.

I Built a Product Nobody Wanted

In this video, Andrew Kamphey shares the story of launching SheetOps, a product designed to streamline operations in Google Sheets, which ultimately flopped due to poor marketing and a lack of user feedback. He reflects on the lessons learned and emphasizes the importance of understanding customer needs and effective product naming.

Build with Better Sheets

Tools, templates, trackers, and full build-from-scratch projects

See all

Make a Mini Month Calendar in 5 minutes

Learn how to create a mini month calendar in just five minutes using Google Sheets, complete with custom formatting and gridlines.

New Slogan

In this video, the creator explores various catchy slogans for Better Sheets, focusing on the tools and templates designed for Google Sheets users. The discussion revolves around finding the perfect phrase that encapsulates the essence of their offerings.

When did you realize you could do Google Sheets as a living?

In this video, the creator shares their journey of discovering a passion for Google Sheets, transitioning from Excel VBA to becoming a recognized expert in the field. They recount pivotal moments that led to the launch of Better Sheets, a platform dedicated to helping users maximize their Google Sheets experience.

SearchLord Search

Discover SearchLord, a powerful free Google Sheets template that enables you to search over 90 websites beyond Google and ChatGPT, including major news outlets and specialized directories.

Find the Perfect Gift with this Google Sheet

Discover how to find the perfect gift using the innovative Google Sheet tool, Searchlord, which searches across 90 websites beyond just Google. This video showcases how to utilize Searchlord for unique gift ideas and rare finds.

Random Dice

Learn how to roll dice in Google Sheets using the CHOOSE function and RANDBETWEEN for randomization. This tutorial also covers how to use checkboxes to trigger dice rolls.

Find View Count of Free Sheet

Learn how to track the view count of your Google Sheets to see how many people are engaging with your shared documents. This video provides a step-by-step guide on accessing the Activity Dashboard for insights on viewer trends.

FULL BOX DROPDOWN

In this tutorial, Andrew demonstrates how to create full box dropdowns in Google Sheets, allowing the dropdowns to occupy the entire cell for a cleaner look. Learn how to adjust the display style and apply these changes to all dropdowns in your sheet.

Apps Script & automations

Scripts, macros, custom functions, and hands-off automation

See all

Find Files in Folder by Name Apps Script

Learn how to find files in a specific Google Drive folder by name using Apps Script, ensuring you retrieve the correct file even when multiple files share the same name.

Dutch Auction in Google Sheets and Google Forms

Learn how to create a Dutch auction using Google Sheets and Google Forms, where item prices decrease over time until sold. This tutorial covers form creation, automation for price reduction, and tracking sold items.

Create Calendar Event When Form Submitted

Learn how to automatically create a Google Calendar event when a Google Form is submitted, scheduling a review session one week later using Google Apps Script.

Automate Emails by Google Form Responses Using Google Apps Script Email Certain Department Based on

Learn how to automate email notifications to different departments based on Google Form responses using Google Apps Script. This tutorial walks you through creating a database of emails, setting up a Google Form, and linking it with an Apps Script to send emails upon form submission.

How to Create a Tab For Every Week of the Year

Learn how to create a tab for every week of the year in Google Sheets using Apps Script. This tutorial walks you through the necessary code adjustments to customize your weekly tabs based on your preferred starting day.

How to Add a Column Between Transposed List

Learn how to add a gap between transposed lists in Google Sheets without altering your original data. This tutorial demonstrates using the join and split functions effectively for better dashboard design.

How to Quickly Add Approval Dropdown Chip

Learn how to quickly add an approval dropdown chip in Google Sheets to streamline your approval process and keep your data organized.

How to Hide a Sheet Tab Automatically

Learn how to automatically hide and unhide sheet tabs in Google Sheets using Google Apps Script. This tutorial covers creating triggers to manage visibility based on time.

Quick tips

Short, single-idea fixes and demos when no topic section fits

See all

Stop Centering Everything

Discover why centering numbers in your spreadsheets can make them harder to read and learn the benefits of right-aligning them for better clarity.

What are your hobbies outside of spreadsheets?

In this video, the speaker shares their passion for board games and how the constraints of these games parallel the complexities of spreadsheets. They reflect on their childhood experiences and the deeper layers of strategy involved in both hobbies.

What personality trait made you good at Sheets?

Discover how thinking inside the box, rather than outside of it, can enhance your problem-solving skills in Google Sheets and beyond. This video explores the importance of constraints in fostering creativity and efficiency.

Shift Command Arrow

Learn how to efficiently select cells in Google Sheets using the Shift + Command keyboard shortcuts to navigate until the next blank cell.

Is this taught in schools anymore?

In this video, the host reflects on a 1922 bookkeeping and accounting book, questioning whether the knowledge contained within is still taught in schools today, especially for younger generations.

Increase The Size of Your Cursor

Learn how to easily increase the size and change the color of your cursor for better visibility and personalization in this quick tutorial.

Today's Month

Learn how to easily extract today's month in Google Sheets using the TEXT function and various formatting options. This video covers different ways to display the month, from numbers to full names.

this guy Google Sheets #googlesheets

In this video, the creator shares their unique perspective on Google Sheets, blending humor and insights to make the tool more enjoyable and accessible.