Google Sheets Tutorials · Better Sheets

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

Better Google Ad Writing Tool Sheet Makeover

Got an amazing tool from Inside Google Ads course by Jyll. She shares this tool, and I went for 30 minutes reviewing it, improving it, and redesigning it. Hope members can learn from this video. Jyll graciously allows me to share this sheet with members only!

CONCATENATE() IF() ISBLANK() LEN()

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?

Beginner

How to Use Sheets For Network Building

Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.

Beginner

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is going to be super, super helpful to you because I'm going to explain not just the sheet I want and what it does, but over the course of all of these, I think you'll get a sense of some really interesting ideas on how to make sheets that sell.

Advanced

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.

Data validation Beginner

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.

Troubleshooting Bitly in a Google Sheet Script

Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.

Advanced

How to Make a Marketplace in a Google Sheet

Make a marketplace where sellers and buyers do not have to have edit access to a sheet.

Intermediate

ARRAYFORMULA() FILTER() UPPER()

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.

Beginner

CONCAT() ROW()

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()

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding

Advanced

IF() IMPORTRANGE()

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically

Intermediate

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

Every Locale Listed in Google Sheets and a Tool to Save Your Sanity

How to change your locale and figure out what changing locales means for your sheets.

Google Sheets Error: Unknown Range Name and How to Fix it

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.

Beginner

Displaying items 61-80 of 351 in total

TAGS

FORMULAS

TOPICS

351 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

How To Create An AutoFill in Google Sheets

Twitter App Clone in a Google Sheet

Naughty or Nice? - Google Sheets' New Dropdown Chips

Learn Google Sheet Formulas The Hard Way

Better Google Ad Writing Tool Sheet Makeover

How To Add Columns in Google Sheets

How to Use Sheets For Network Building

Intro Video - Make Better Sheets

10 Google Sheets I Wish Someone Would Make

Magical Things You Can do with Checkboxes in Google Sheets

Make Unsplash in Google Sheets - Part 2

Troubleshooting Bitly in a Google Sheet Script

How to Make a Marketplace in a Google Sheet

Make Your Lists Spicy Hot in Google Sheets

Add a Word Count to Google Sheets

Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Email Yourself a Cell from a Google Sheet, Every Day

Every Locale Listed in Google Sheets and a Tool to Save Your Sanity

Google Sheets Error: Unknown Range Name and How to Fix it