TRY ME!
→ Random Tutorial

324 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 Than Happy | Redesign of The Feelings Wheel

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet
Beginner
Facebook Ads Mockup Generator

Facebook Ads Mockup Generator

Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!
Beginner
IMAGE() LEN()
Spreadsheet Automation 101 Lesson 4: UrlFetchApp

Spreadsheet Automation 101 Lesson 4: UrlFetchApp

Use any URL to scrape the web or access an API and get that info into your Google Sheet.
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL

Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL

Capture data from OMDb in our Google Sheets with a free API Key. It’s easier than it sounds. Let’s do this!
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters

Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters

Learn how we get information out of a JSON response. I’ll even show you how you can bring in some cool images in Google Sheets!
Your First Formula

Your First Formula

Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.
Beginner
CONCATENATE() TRANSPOSE()
Create Instant QR Codes

Create Instant QR Codes

Learn how to use a free Google API to create QR codes in sheet to any URL. And we'll learn how to make them magically appear as you enter domains.
ARRAYFORMULA() IF() IMAGE() ISBLANK()
Figuring out the 80/20 Rule with a Running Sum Total

Figuring out the 80/20 Rule with a Running Sum Total

I figured out that 20% of my videos are getting 80% of the watch time on my YouTube channel, and I actually used a Google sheet to figure this out.
Beginner
SUM()
Create Navigation Like A Book or Presentation

Create Navigation Like A Book or Presentation

A pretty cool script I came up with to click and set active the next tab. No matter how many tabs/sheets you have. Makes a book-like page turning action. At the end of the video I say you have to wait, but now you can get the sheet and the script only. Spreadsheet Alchemy is still a work in progress.
Advanced
Build a Better ChatGPT Prompt Builder

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.
JOIN() SUBSTITUTE()
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
Conditional Formatting Intermediate
How Do I Make a CSV File? And give a link to someone instead of the csv.

How Do I Make a CSV File? And give a link to someone instead of the csv.

Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.
This Seems Like Automation

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more
1 Simple Formula to Make Writing Tweets Easier or Make $1,000

1 Simple Formula to Make Writing Tweets Easier or Make $1,000

Create a hook writing sheet with SUBSTITUTE(). Create an engine to write tweet upon tweet upon tweet. Bundle up 100 hooks/formats and sell it. Go ahead, make sweet tweets in a sweet sheet.
SUBSTITUTE()
Every Tab Has a Unique ID called GID

Every Tab Has a Unique ID called GID

Less than 2 minute tip to help you link directly to a tab in a sheet. Each spreadsheet file has it's own unique id, a url. But also every tab has a unique "gid" that you can use to link directly to a tab in a sheet. Saving people a click.
Beginner
Visicalc 2023 Technical Walkthrough

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.
Advanced
Find "Entry Number" for Bookmarklet

Find "Entry Number" for Bookmarklet

Followup to the Bookmarklet video. To help you find the entry number for each form field.
Roast: 363 Questions VCs Ask Founders

Roast: 363 Questions VCs Ask Founders

we got a pretty darn simple and sweet sheet here with funding. A lead magnet that is 363 questions that PCs investors ask startup founders.
Find The Most Common Word(s)

Find The Most Common Word(s)

Find out which words in your sheet are the most common. Highest count of each individual word.
Intermediate
Change the Default Font

Change the Default Font

Set a different default font for each sheet you open.
Beginner

Displaying items 281-300 of 324 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