Better Sheets

Login

Get Instant Access

TRY ME!

→ Random Tutorial

TAGS

Intermediate

180

Beginner

170

Advanced

105

Most Popular

13

Data validation

13

Conditional Formatting

11

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

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

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

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.

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()

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