Google Sheets Tutorials · Better Sheets

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

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

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

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

VLOOKUP()

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.

Advanced

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

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Advanced

How to Add YouTube Thumbnails

Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.

FIND() IFERROR() INDEX() SPLIT() SUBSTITUTE()

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a row of data based on a single criteria in a column. Great for sales teams and maintaining a CRM.

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease and tweet each other's tweets! Learn how to do it with our step-by-step guide

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.

Beginner

COUNTBLANK() COUNTIFS() COUNTUNIQUE()

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

COUNTIF() IF()

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.

Advanced

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

ARRAYFORMULA() IF() ISBLANK() MAX()

Displaying items 81-100 of 366 in total

TAGS

FORMULAS

TOPICS

366 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Better Google Ad Writing Tool Sheet Makeover

10 Google Sheets I Wish Someone Would Make

How to Make a Marketplace in a Google Sheet

Make Your Lists Spicy Hot in Google Sheets

Search for Photos in a Google Sheet

Basic CRM - Add a Powerful Script To Move Row Based on Status

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

Google Sheets Interface Changes

Create a new Spreadsheet from just a Name in a Sheet.

How to Add YouTube Thumbnails

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

Create Hundreds of Tweets in a Google Sheet

Add Cool Responsive Graphs to Your Stock Tracking Sheets

3 More Ways to Count in Google Sheets

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

LinkTree in a Google Sheet

How to Iterate Counting Blank Cells in Google Sheets