Google Sheets Tutorials · Better Sheets

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

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.

ARRAYFORMULA() IFERROR()

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

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

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.

Beginner

Unique Features - Design a Better Dashboard Part 2

We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.

Advanced

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.

Switch Months Menu - Design a Better Dashboard Part 4

Create a dropdown that changes the months displayed in a dashboard.

INDEX() MATCH()

Dashboard Principles - Design a Better Dashboard Part 1

One of the best examples of a dashboard I got from a great talk on just totally like SASS dashboards, and they talked about the speedometer and why the speedometer is such a great dashboard is that it is it encapsulates all of the principles of what goes into a great dashboard.

Build The Dashboard - Design a Better Dashboard Part 3

We're actually gonna go build the dashboard today.

CHAR() COUNTA() HYPERLINK() IF() INDEX() +2 more

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

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

New Syntax for WhatChanged Formula in Google Script

revisiting the "what changed" custom function I built in a past video. Showing you more apps script

Advanced

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +3 more

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

LinkTree in a Google Sheet

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

Advanced

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

Displaying items 81-100 of 266 in total

TAGS

FORMULAS

TOPICS

266 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Create Hundreds of Tweets in a Google Sheet

Sheet Improvement: Better Business Idea Selection Framework

10 Google Sheets I Wish Someone Would Make

3 More Ways to Count in Google Sheets

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

Hide Gridlines for Better Communication

Unique Features - Design a Better Dashboard Part 2

Make Unsplash in Google Sheets - Part 2

Switch Months Menu - Design a Better Dashboard Part 4

Dashboard Principles - Design a Better Dashboard Part 1

Build The Dashboard - Design a Better Dashboard Part 3

How to Make a Marketplace in a Google Sheet

Search for Photos in a Google Sheet

New Syntax for WhatChanged Formula in Google Script

Create a Radio Button From Checkboxes Using Google Apps Script

Deep Inside Dark Habits Google Script

Add a Word Count to Google Sheets

LinkTree in a Google Sheet

More LinkInBio Templates for Google Sheets | SheetInBio

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