TRY ME!
→ Random Tutorial

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

Automatically Align Top

Automatically Align Top

Automate formatting cells to align top. Either by a time-based trigger or every time you edit cells.
 Automatically Check Past Stages

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the past stages also check.
Beginner
Open Spreadsheet to Motivational Quote Automatically

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.
Beginner
COUNTA() INDEX() RAND() ROUNDUP()
Send Better Email When Google Form Filled Out

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.
Intermediate
Every Google Drive File Created in Last 24 Hours

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
Intermediate
Reformat Pasted Cells Automatically

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.
Intermediate
Add NPS to Your Google Site

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Intermediate
AVERAGE()
Better Email Form on Google Sites

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Advanced Intermediate
Why can't people fill in my Google Form?

Why can't people fill in my Google Form?

The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
 Create New Worksheet When Google Form Submitted

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.
Advanced
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
Add Columns Automatically

Add Columns Automatically

Create your own "Add Columns" button just like the add rows to the bottom.
Intermediate
How To Change Date Format Automatically

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.
Advanced
Email Certain Department Based on Google Form Entries

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.
Advanced
Make a Tour of Your Sheet

Make a Tour of Your Sheet

create a tour of your sheet for users who might be using your sheet and need to know what to do on each tab.
Advanced
Expense Tracker Template with Data Entry Form Inside Sheets

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.
Intermediate
FILTER() IFNA() SUM()
I Created an Automatic Emailer

I Created an Automatic Emailer

While creating SheetOps, a new product, I came up with this idea of an automatic emailer that I can just enter an email and select a series of emails to send them. Needs an unsubscribe link. And so I made it in less than 45 minutes. Here it is. You can start using this right now for free if you're a member.
Advanced Intermediate
Weekly Email Sheet as Lead Magnet

Weekly Email Sheet as Lead Magnet

Create a fun freebie for selling spreadsheets
 SearchLord: One Sheet to Search Them All

SearchLord: One Sheet to Search Them All

I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord

In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.
Intermediate Beginner
ENCODEURL() FILTER() IFNA() SUBSTITUTE()
SheetLord Update: duplicate tab and automatically add Search Term

SheetLord Update: duplicate tab and automatically add Search Term

Updated SheetLord with a new function.
Intermediate

Displaying items 221-240 of 329 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