TRY ME!
→ Random Tutorial

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

Create an Auto-Update Sales Chart: Trailing 12 Months

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.
Intermediate
COUNTA() IF() INDEX() ISBLANK() SUM()
Biggest Flaw In Dashboards with Dark Colors

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.
Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

how would I do the following? In Google Sheets, it's in column A I have a list of URLs. For each of those URLs, I want to pull that URL's featured image and meta description, and put those in columns B and C. Here's how you do it. I just grabbed Wikipedia articles for this example.
Advanced
IMPORTXML()
Ken Asks: Can We Add Star Ratings?

Ken Asks: Can We Add Star Ratings?

One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.
Beginner
AVERAGE() SWITCH() VLOOKUP()
How to Edit a Macro

How to Edit a Macro

Editing macros in Google Sheets helps you do more in less time.
Advanced
Count How Many Subscribers In a Company by BetterSheets.co

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Intermediate
ARRAYFORMULA() COUNTIF() LOWER() SORT() SPLIT() +1 more
Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Enable your apps script functions be auto completed while you're using Google Sheets.
Advanced
Take a list and make it Vertical, Using Split Join or RegexReplace

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.
Beginner
JOIN() REGEXREPLACE() SPLIT() TRUE()
Adding Number and dot to rank or order lists

Adding Number and dot to rank or order lists

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution
Beginner
CONCAT() ROW()
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
Beginner
TRANSPOSE() UNIQUE()
6 Ways to Make Your Checkboxes Better

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
Data validation Beginner
5 Ways to Generate Random Numbers

5 Ways to Generate Random Numbers

generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
Intermediate
RAND() RANDBETWEEN()
Introduction to Spreadsheet Automation 101 Lesson 3

Introduction to Spreadsheet Automation 101 Lesson 3

This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
 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()
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()

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