TRY ME!
→ Random Tutorial

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

Roast: Sidekick Recipes

Roast: Sidekick Recipes

Unlock the Secrets of Recipe Organization with this Google Sheet review. A deep dive into a Google Sheet and how to improve it. Not just a Google Sheet Tutorial. Dive deep into a sheet that hold recipes. Great video for those looking to organize and share Recipes in a Google Sheet. Whether you're a home cook or a budding professional chef. You're probably already curating your recipes in a Google Sheet. Here's how to make your sheet better.
Beginner
Great Sheets! Corona Hiring Sheet

Great Sheets! Corona Hiring Sheet

Reviewing a Corona hiring sheet. A great example of using Google Sheets. I have high praise for the design and the use of forms for data validation. The sheet makes great use of white space, circular image, and icons instead of text. While I suggest other ways to monetize the job board, I acknowledge the creator's decision to avoid exploiting the situation.
Google Sheet Basics - The Absolute Basics

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Beginner
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()
Aesthetics Teaser: How To Use Alternating Colors

Aesthetics Teaser: How To Use Alternating Colors

How to use alternating colors in your spreadsheets.
Beginner
RANK()
Create an Email Campaign Stats Calculator

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
CONCATENATE() ROUNDDOWN() UPPER()
Made a Conference Schedule Better - Member Request!

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.
Advanced
Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

A fun way to make a sheet look like a mall.
Advanced
CONCATENATE() HYPERLINK() IFERROR() INDEX()
How to Name Sheet Tabs

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
Beginner
Better Header Fonts - Best Fonts To Use In Google Sheets

Better Header Fonts - Best Fonts To Use In Google Sheets

Find out what fonts to use to make your headers better.
David Asks: About Primary Keys

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Intermediate
INDEX() MATCH()
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
Automatically Delete All Sheets If Not Listed Name

Automatically Delete All Sheets If Not Listed Name

A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!
Advanced
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()
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.
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
Getting Started Coding in Apps Script

Getting Started Coding in Apps Script

A short 10 minute video to get you started with Apps Script. Showing you menu: Extensions > Apps Script. And shows off how to write a function, do some math, manipulate some text. Members can get Spreadsheet Automation 101 in https://BetterSheets.co/courses
Beginner
World Peace in Google Sheets

World Peace in Google Sheets

Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!
Beginner
DETECTLANGUAGE() GOOGLETRANSLATE() VLOOKUP()
Meet Asa: Ask Sheets Anything

Meet Asa: Ask Sheets Anything

GPT3 Powered Answers to your spreadsheet questions. Ask sheets anything, literally any question about Google Sheets! This might put me out of a job as a Google Sheets Expert.
OpenSea Data Inside Sheets

OpenSea Data Inside Sheets

Get floor prices into your spreadsheet with URLFETCHAPP. Accessing OpenSea's API directly from google sheets. Get any data you want. from Market Cap to One Hour Volume

Displaying items 121-140 of 141 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