Google Sheets Tutorials · Better Sheets

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

Made Ali Abdaal's study google sheet better.

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

Intermediate Beginner 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"

Intermediate Beginner 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.

Intermediate Beginner 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

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.

Beginner

Invoicing in Google Sheets for Freelancers

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.

Beginner

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()

Beginner

Displaying items 1-20 of 162 in total

162Google Sheet Tutorials

Discover the Power of Productivity

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

🎯 Precise:

🔧 Automate Your Sheets