Google Sheets Tutorials · Better Sheets

Create a few simple automations like email notifications and low stock alerts.

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get this free review of your Google Sheets in 2024.
https://bettersheets.co/sheetswrapped

You Should Know The Limitations of Data Validation

You should know the difference between Data Validation and Data Veracity (or truthfulness of data)
This video points out some incredibly simple concepts of Data Validation you may want to use in your Google Sheets to make your data analysis better.

Beginner Intermediate

Combine Filters in One Column

Using the ampersand and ARRAYFORMULA to combine two filters into a single column.

Beginner

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.

Beginner

Introducing Bigger Brain

10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.

Beginner Intermediate Advanced

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Beginner

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.

Beginner

Tips to Navigating Thousands of Lines of Code In Apps Script

Find out how I use Apps Script built in features to code very quickly and efficiently.

Beginner

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.

Beginner

How to Copy To New Tab When Checked

Copy text from one tab to another based on a checkbox being checked.

Beginner

Recreate a Starbucks Order Status Sign

Create a status flow chart, like a kanban board but for displaying coffee orders.

Beginner

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"

Beginner Intermediate Advanced

Vertically Stack and Sort Data

It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.

Beginner

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automatically.

Beginner Intermediate Advanced

One Million Checkboxes

Check out this fun onEdit() counting you can do with checkboxes in a fun sheet with 1 Million Checkboxes.
Anyone can log into google sheets and go here: https://bettersheets.co/checkboxes

Beginner

Turn Bland Sheets Into Glam Sheets!

A few tips to make your Google Sheets look better.

Beginner

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the past stages also check.

Beginner

Timestamp When Done (With Code)

Automatically create a timestamp when a certain cell is marked as Done. I show you how to customize this scrip and where to get the script. I hope this is simple enough for beginners to start automating you sheets. If you want to see more automations and dive deeper into apps script enroll in Spreadsheet Automation 101
and see more examples of Apps Script at BetterSheets.co/snippets

Beginner

Displaying items 1-20 of 165 in total

165Google Sheet Tutorials

Discover the Power of Productivity

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

🎯 Precise:

🔧 Automate Your Sheets