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!

Made a Conference Schedule Better - Member Request!

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.
Advanced
Find Hundreds of Available Domains From Keywords with Concat and Array Formula

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
ARRAYFORMULA() CONCAT() IF() ISBLANK()
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

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
Better Domain Portfolio Template

Better Domain Portfolio Template

Create a better list of domains.
Intermediate
COUNTA() FILTER() INDEX() MATCH() MAX() +1 more
Don't Draw Attention to the Header

Don't Draw Attention to the Header

Common mistake is highlighting the header of a table in a bold color.
Beginner
Richard Asks: Copy Template Tab and Rename to Date Every Week

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.
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()
Better Than Happy | Redesign of The Feelings Wheel

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet
Beginner
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
Highlight Row as You Move Your Cell Selection

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move your cell selection.
Conditional Formatting Beginner
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: Introduction to Pre-course Videos

Spreadsheet Automation 101: Introduction to Pre-course Videos

Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.
 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 Lesson 1: GetValue - Introduction to SpreadsheetApp

Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp

Learn to write codes in Apps Script. Understand what SpreadsheetApp is used for. Get to know getActiveSpreadsheet and use it correctly.
Spreadsheet Automation 101 Lesson 2: Logger.log()

Spreadsheet Automation 101 Lesson 2: Logger.log()

Learn to log any variable you want and get notes inside your log. Debug your code to understand what’s going on and find out where you went wrong.
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.
Create a Many to Many Database

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.
FILTER() IFNA() JOIN() TRANSPOSE()
BetterSheets.co Tour for Lifetime Members

BetterSheets.co Tour for Lifetime Members

Find out all that Better Sheets has to offer you. Learn where to learn. Find out the features available to lifetime members at BetterSheets.co
 How Can I Compare Two Tabs for Differences?

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.
COLUMN() IF() INDEX() INDIRECT() ROW()

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