Better Sheets

Login

Get Instant Access

TRY ME!

→ Random Tutorial

TAGS

Intermediate

178

Beginner

169

Advanced

104

Most Popular

13

Data validation

13

Conditional Formatting

11

630Google 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!

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

Create vertical lists in Google Sheets.

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

Ben Asks: How Do I Add 1 Month?

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

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.

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

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

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.

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.

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

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

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.

COUNTIF()

Learn simple keyboard shortcuts to save you time

Learn some simple keyboard shortcuts.

SPLIT()

How to Trigger Macros Daily

Automate your apps script and macros you can record.

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.

Most Popular Intermediate

CONCAT() ISBLANK() ARRAYFORMULA() IF()

Added Categories to 100 Twitter Templates Template

Add one more feature to the 100 Twitter Templates tool.

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.

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

New Syntax for WhatChanged Formula in Google Script

revisiting the "what changed" custom function I built in a past video. Showing you more apps script

How Does Split Work?

We go deep into the syntax and usage of the SPLIT() formula.

SPLIT()

Use Index Match when you want Vlookup

If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.

INDEX() MATCH() VLOOKUP() MAX()

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Revolutionary Method to Manage Your Video Stories! Learn how to delete old videos in just 24 hours. Keep your content fresh and engaging. Click here for the ultimate guide.

SPLIT() IF() INDEX() ISBLANK() IMAGE() +1 more

Use Min and Max for More Average Averages

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

MIN() MEDIAN() AVERAGE() MAX()

Displaying items 481-500 of 630 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons