TRY ME!
→ Random Tutorial

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

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curated sites, articles, and more web resources super easily into a Google Sheet. Create a bookmarklet automatically with this apps script tool.
Beginner
Build Your Own Free Domain Availability Checker

Build Your Own Free Domain Availability Checker

Built a Domain Availability Checker in Google Sheets. You can build your own with the code provided. Use RapidAPI and Domainr.com to get an APIEKY for your own free checker.

Learn how to integrate sheets with a TLD Availability API.
Advanced
ARRAYFORMULA() FILTER() IF() ISBLANK()
Create a Branded Lead Magnet from Qualitative Data

Create a Branded Lead Magnet from Qualitative Data

Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.
 
The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.
Intermediate
AVERAGE() COUNTA() COUNTIF() FIND() HYPERLINK() +7 more
Duplicate Everything For Each Unique Value

Duplicate Everything For Each Unique Value

Intermediate
ARRAYFORMULA() CONCATENATE() JOIN() SPLIT()
How to Make Good Looking Spreadsheets

How to Make Good Looking Spreadsheets

Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.
Intermediate
How to Make an AI Integrated Freebie Spreadsheet

How to Make an AI Integrated Freebie Spreadsheet

Intermediate
IF() ISBLANK()
How to Count Numbers in a Row

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.
Beginner
AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more
Uncheck Every Checkbox in Google Sheets

Uncheck Every Checkbox in Google Sheets

Automatically uncheck a whole range of checkboxes. Or just do it yourself with the spacebar.
Intermediate
Create Your Own NIGHT Mode (like PRIDE)

Create Your Own NIGHT Mode (like PRIDE)

Create easter eggs in your sheets.
Conditional Formatting Intermediate
AND()
Weight Loss Tracker Template

Weight Loss Tracker Template

I created a weight loss tracker template for myself and thought you, and all members would like it. So get it, copy it, and start your weight loss journey today. Comes with a nice chart already so all you have to do is add your numbers every day.
Beginner
Everything I know about Checkboxes (Cool Hacks)

Everything I know about Checkboxes (Cool Hacks)

Let me tell about some cool hacks you can do with checkboxes. Like making a checkbox have alternative values, or making a checkbox look like a button, not a check mark.
Beginner
How to make a Pill Form Field in Google Sheets

How to make a Pill Form Field in Google Sheets

Create rounded pill form fields in Google Sheets.
Using Canva and a bit of a transparent PNG hack, you can make these very easily too!

also make sure to check out Coupon Code Maker a software product I sell that generates thousands of coupon codes in a click.

Recently updated dashboard makes it really cool! 
Intermediate
Coupon Code Maker Updates February 2024 - New Dashboard

Coupon Code Maker Updates February 2024 - New Dashboard

Update to Coupon Code Maker
Available for free for lifetime members. Buy via Gumroad if you're not yet a member.
Watch the video because there are discount codes I show you in the video to get Coupon Code Maker for less than $30.  
Yes I use Coupon Code Maker myself. It's how I put products from Gumroad onto AppSumo Marketplace.
Intermediate
Idea Graveyard - Create a Decaying Checklist

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.
Intermediate
DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create dark mode with Conditional Formatting.
Conditional Formatting Beginner
What is this Ampersand Doing in Google Sheets?

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.
CONCAT() DATE() MONTH() VALUE()
Problems Everywhere, and the Spreadsheets that Solve Them

Problems Everywhere, and the Spreadsheets that Solve Them

In my video, I talk about how common problems are and how Google Sheets can help solve many of them in business. I discuss the different ways Google Sheets can be used, from simple to complex tasks, and plan to share five specific ways to use it effectively in future videos for better planning, tracking, and managing tasks.
 Easiest Sheet Ever to Sell

Easiest Sheet Ever to Sell

Tracker Tactics

Tracker Tactics

Tactics to build different kinds of trackers you can sell as digital products.
 The Art of the Sell: Breaking down a Free Title Generator

The Art of the Sell: Breaking down a Free Title Generator

I'm breaking down the landing page of titlecraft master nonfiction book titles. It's by two people I know on Twitter, and they send this to me and it's free, it's zero dollars

Displaying items 161-180 of 637 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