Google Sheets Tutorials · Better Sheets

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.

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.

Beginner

COLUMN() INDEX() ROW()

Make a New Sheet - Best Practices

Create a new sheet and do it well.

Beginner

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

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends!

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.

Beginner

COUNTA() INDEX() RAND() ROUND()

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

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.

COUNTA() COUNTIF() FILTER() IFERROR() MATCH() +1 more

Google Sheets Interface Changes

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

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

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

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.

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

Extract URLs from Google Sheets

When you can't get the url of a hyperlinked cell, do this instead.

Displaying items 81-100 of 365 in total

TAGS

FORMULAS

TOPICS

365 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Great Sheets! Corona Hiring Sheet

Basics - Structure of a Sheet: Index() Row() and Column()

Make a New Sheet - Best Practices

Search for Photos in a Google Sheet

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

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

Manage Your Wedding Guest List in Google Sheets

Google Sheets Interface Changes

How to Add YouTube Thumbnails

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

Let's Make a Bookmarklet!

LinkTree in a Google Sheet

How to Iterate Counting Blank Cells in Google Sheets

Extract URLs from Google Sheets