TRY ME!
→ Random Tutorial

362 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
❌
Can't Find a Video?: Members can reach out and ask me anything!

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends! 

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.
Beginner
COUNTA() INDEX() RAND() ROUND()
Password Protecting Data In a Google Sheet

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding
Advanced
IF() IMPORTRANGE()
Automatic Weekly Backup of Google Sheets

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically
Intermediate
Google Sheets Error: Unknown Range Name and How to Fix it

Google Sheets Error: Unknown Range Name and How to Fix it

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.
Beginner
Manage Your Wedding Guest List in Google Sheets

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.
COUNTA() COUNTIF() FILTER() IFERROR() MATCH() +1 more
How to Add YouTube Thumbnails

How to Add YouTube Thumbnails

Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.
FIND() IFERROR() INDEX() SPLIT() SUBSTITUTE()
Create Hundreds of Tweets in a Google Sheet

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease and tweet each other's tweets! Learn how to do it with our step-by-step guide 
 Add Cool Responsive Graphs to Your Stock Tracking Sheets

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!
GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()
3 More Ways to Count in Google Sheets

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.
Beginner
COUNTBLANK() COUNTIFS() COUNTUNIQUE()
How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.
Intermediate
COUNTIF() IF()
LinkTree in a Google Sheet

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.
Advanced
Convert Your Bullet Journal To Google Sheets

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.
Beginner
VLOOKUP()
Better Header Fonts - Best Fonts To Use In Google Sheets

Better Header Fonts - Best Fonts To Use In Google Sheets

Find out what fonts to use to make your headers better.
Password Protecting Data In a Google Sheet Part 2 The Basics

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.
Advanced
IF() IMPORTRANGE()
How to Write a Function - Learn to Code in Google Sheets Part 2

How to Write a Function - Learn to Code in Google Sheets Part 2

Continuing to show you how to write a function in Apps Script.
Beginner
Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script
Advanced
Hold a Giveaway Raffle in a Google Sheet

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks to do.
World Peace in Google Sheets

World Peace in Google Sheets

Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!
Beginner
DETECTLANGUAGE() GOOGLETRANSLATE() VLOOKUP()
How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
Beginner
How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
Beginner
AND() IF() OR()

Displaying items 81-100 of 362 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons