TRY ME!
→ Random Tutorial

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

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.
Advanced
HYPERLINK()
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.
CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more
Sheet Styles A Free Google Sheet Add-on by Better Sheets

Sheet Styles A Free Google Sheet Add-on by Better Sheets

Install Sheet Styles now: https://sheet-styles.bettersheets.co/
 Announcing Button Styles | A Free Google Sheet Add-On

Announcing Button Styles | A Free Google Sheet Add-On

A new free Google Sheets Add-On to make drop shadow buttons inside your sheets. Free for everyone. Announced to members first.
Add Pics to Marketplace in a Google Sheet

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.
Beginner
FILTER() IMAGE() INDEX() MATCH()
How To Add Columns in Google Sheets

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?
Beginner
Add Tasks to Google Tasks From Google Sheets

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script
Advanced
How to Iterate Counting Blank Cells in Google Sheets

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.
Intermediate
ARRAYFORMULA() IF() ISBLANK() MAX()
Add a Word Count to Google Sheets

Add a Word Count to Google Sheets

Count your words inside a sheet. Great for ad writing, novel writing, or if you need to meet minimums.
COUNTA() IF() ISBLANK() SPLIT()
Email Yourself a Cell from a Google Sheet, Every Day

Email Yourself a Cell from a Google Sheet, Every Day

Learn how to email yourself a cell from a Google sheet every day in just a few simple steps! This powerful technique will change the way you manage your data. Follow along and get ready to be amazed! 

Learn to automate an email, with data, from a sheet.
Beginner
Add Title Case to Google Sheets

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How! 
Advanced
Introduction to Google Sheets™ Add-on Course

Introduction to Google Sheets™ Add-on Course

In this course we'll go step by excruciating step how to take a simple apps script from a bound script to your spreadsheet and turn it into a published Google Sheets add-on available to the public on the Google Workspace Marketplace.
 MAKE Your Google Sheets Add-on WORK

MAKE Your Google Sheets Add-on WORK

In this section of the Add-on course we'll be making the apps script work as an Add-on.
 MAKE Your Google Sheets Add-on USABLE

MAKE Your Google Sheets Add-on USABLE

In this section we're going to turn our apps script into an add-on. complete with add-on menu. (Yes it's different than a custom menu, slightly).

The things I go over in this section took a lot of trial and error. The first time I created a Google Sheets Add-on I was flabbergasted that it just didn't work like a Google Sheets Add-on. Until I did all the things I go over in this section.
 MAKE Your Google Sheets Add-on DISCOVERABLE

MAKE Your Google Sheets Add-on DISCOVERABLE

In this section of our Add-on course we'll get out of sheets for a bit and create marketing materials. I'll show you the templates I use to make websites very quickly. hint: It's CARRD!
I'll also show you how quickly I make the banner and logo. You might be as quick if you have your own company logo or you already have something made.
 MAKE Your Google Sheets Add-on MARKETABLE

MAKE Your Google Sheets Add-on MARKETABLE

In this section we'll put our marketing materials to the test. We'll go through the ENTIRE process of asking for approval, getting rejected, and overcoming rejection to ultimately publish our Google Sheets Add-on to the world!
 Check Your Google Sheets Add On Works

Check Your Google Sheets Add On Works

In this lesson we'll check if the add-on actually works and record a client ID video. A weird little thing that I've now done a few times so can hopefully show you how to easily do it without getting frustrated.
 How to Replace Text with a Blank Cell in Google Sheets

How to Replace Text with a Blank Cell in Google Sheets

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.
Beginner
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Beginner
CONCATENATE() JOIN()
Create an Internal Google Sheets Add-on

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.
Intermediate

Displaying items 1-20 of 350 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