TRY ME!
→ Random Tutorial

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

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.
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()
Ben Asks: How Do I Add 1 Month?

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.
Intermediate
CONCATENATE() EDATE() TEXT() TODAY()
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
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
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()
Add Character Count and Character Limit

Add Character Count and Character Limit

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting
Beginner
LEN()
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
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
New Syntax for WhatChanged Formula in Google Script

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
Advanced
Create a Radio Button From Checkboxes Using Google Apps Script

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
IFS() NOT() OR()
Sheet Stories / Video Notes + ADDED: Email Notifications

Sheet Stories / Video Notes + ADDED: Email Notifications

Unlock the Power of Email Notifications! 📧 Dive into our latest video tutorial, where we show you step-by-step how to add email notifications to your Google Sheets. Stay ahead of the game, get instant updates, and keep your workflow seamless! Check it out now! 
Advanced
CONCATENATE() IF() INDEX()
How to Name Sheet Tabs

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
Beginner
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()

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