TRY ME!
→ Random Tutorial

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

Better Sheets Videos Checklist

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.
Data validation Beginner
COUNTA() COUNTIF() FILTER() IFNA() SORT() +1 more
Sheet Improvement: Better Band Bureau Better Schedule

Sheet Improvement: Better Band Bureau Better Schedule

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.
Basics - Structure of a Sheet: Index() Row() and Column()

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.
Beginner
COLUMN() INDEX() ROW()
Make a New Sheet - Best Practices

Make a New Sheet - Best Practices

Create a new sheet and do it well.
Beginner
Great Sheets! Community Information Board by Seedtable.com

Great Sheets! Community Information Board by Seedtable.com

Incredible design and inspiration for us in our sheets.
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
Secure Your Sheets by BetterSheets.co

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.
Beginner
ARRAYFORMULA() FILTER() INDEX() MATCH() MIN()
Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

A fun way to make a sheet look like a mall.
Advanced
CONCATENATE() HYPERLINK() IFERROR() 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 More Sheets Help

Get More Sheets Help

How To Ask Questions as a Better Sheets Member
14 Sheet Ideas You Can Sell

14 Sheet Ideas You Can Sell

Strategic ideas, examples of sheets you can sell or create as lead magnets
Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Get Values is done in the Apps Script. In this lesson, you’ll learn what changing .getValue() to .getValues() do. You’ll also learn about Logger and For Loop, which I mention here briefly.
How to Use Sheets For Network Building

How to Use Sheets For Network Building

Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.
Beginner
Add Cool Responsive Graphs to Your Stock Tracking Sheets

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!
GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()
Sheet Improvement: Better Business Idea Selection Framework

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.
ARRAYFORMULA() IFERROR()
Turn Data in Many Columns Into 1 Column

Turn Data in Many Columns Into 1 Column

How to turn many columns into one column.
Beginner
How to Refer to Other Cells - A1 and R1C1 Explained

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.
Beginner
Let's Make a Bookmarklet!

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.
Most Popular Advanced
Switch Data

Switch Data

We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.
Intermediate
SWITCH() VLOOKUP()
Sheet Stories / Video Notes + Clear 24 Hour Old Videos

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. 
Advanced
CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Displaying items 201-220 of 361 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