TRY ME!
→ Random Tutorial

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

4 Ways to Make a New Spreadsheet

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.
Beginner
CONCAT()
Made a Conference Schedule Better - Member Request!

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.
Advanced
Creating A Dark Mode Theme | Announcing Dark Habits

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Most Popular Intermediate
ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +6 more
Ken Asks: How can I count true and false? Answer: w/ CountIF()

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()
Anders Asks: Find first and last of filter by date

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.
Beginner
COUNT() IF() INDEX()
2 Ways to Hide Data

2 Ways to Hide Data

Hide data with these simple tricks. Just using the IF() formula.
Intermediate
IF()
Get Twitter Handles Easily by changing URLS to @

Get Twitter Handles Easily by changing URLS to @

Change Urls to @ using Substitute()
Beginner
SUBSTITUTE()
Wrangle Scattered Data with Flatten()

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor. 
Beginner
FLATTEN()
Basic CRM - Add a Powerful Script To Move Row Based on Status

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.
Advanced
Wallace Asks: How To Find New Names

Wallace Asks: How To Find New Names

Got a list of names, need to add new ones to main list.
ARRAYFORMULA() IF() IFERROR() ISBLANK() MATCH()
Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.
Intermediate
INDIRECT() SORT() TRANSPOSE()
Anika Asks: How To Set Text Overflow All The Time

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.
Intermediate
Announcing Sell Daily and How I Built Sell Daily

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Beginner
FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more
Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
 Spreadsheet Automation 101: Camel Case

Spreadsheet Automation 101: Camel Case

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.
Introduction to Spreadsheet Automation 101 Lesson 3

Introduction to Spreadsheet Automation 101 Lesson 3

This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
 Spreadsheet Automation 101 Lesson 3: MailApp

Spreadsheet Automation 101 Lesson 3: MailApp

Learn about the needed variables for the Mail App to work. In this lesson, I’ll walk you through how you can email yourself or other people the items in a to-do list that hasn’t been done yet.
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger

Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger

Learn about how to add and delete Triggers very quickly. I’ll teach you how you can send out an email regularly using Triggers.
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop

Spreadsheet Automation 101 Lesson 3: Email Other People For Loop

Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.

Displaying items 321-340 of 348 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