Better Sheets

635 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!

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

Beginner

MATCH() FILTER() IMAGE() INDEX()

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.

Beginner

UNIQUE() TRANSPOSE()

Adding Number and dot to rank or order lists

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution

Beginner

CONCAT() ROW()

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0

Beginner

VLOOKUP() CONCATENATE()

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.

Beginner

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

JOIN() REGEXREPLACE() TRUE() SPLIT()

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.

Intermediate

EDATE() TEXT() TODAY() CONCATENATE()

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() ISBLANK() TRANSPOSE() FILTER() INDEX() +3 more

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.

Beginner

MATCH() FILTER() MIN() INDEX() ARRAYFORMULA()

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

MID() COLUMN() TEXT() INDEX() IF()

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

OR() NOT() IFS()

Better Domain Portfolio Template

Create a better list of domains.

Intermediate

MATCH() MAX() INDEX() FILTER() COUNTA() +1 more

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Enable your apps script functions be auto completed while you're using Google Sheets.

Advanced

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.

Beginner

COUNTIF()

Learn simple keyboard shortcuts to save you time

Learn some simple keyboard shortcuts.

Intermediate

SPLIT()

How to Trigger Macros Daily

Automate your apps script and macros you can record.

Advanced

TODAY()

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Build a list of domains you can buy right now. Easily check if the domain you want is still available.

Added Categories to 100 Twitter Templates Template

Add one more feature to the 100 Twitter Templates tool.

Intermediate

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.

Intermediate

COUNTIF() SORT() LOWER() SPLIT() UNIQUE() +1 more

Displaying items 481-500 of 635 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

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons