Google Sheets Tutorials · Better Sheets

How to Create a CRM in google sheets w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

Create a Podcast Advertising Calculator

Build from scratch a calculator to figure out podcast advertising rates.

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.

Beginner

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

How to use alternating colors in your spreadsheets.

Beginner

RANK()

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

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Build a list of domains you can buy right now. Easily check if the domain you want is still available.

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

COLUMN() IF() INDEX() MID() TEXT()

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.

Beginner

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.

Data validation Beginner

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

VLOOKUP()

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

From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3

In this video, I'm going to share with you how to go basically from sheet to script and then back to the sheet again.

Beginner

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.

COLUMN() IF() INDEX() INDIRECT() ROW()

Create Navigation Like A Book or Presentation

A pretty cool script I came up with to click and set active the next tab. No matter how many tabs/sheets you have. Makes a book-like page turning action. At the end of the video I say you have to wait, but now you can get the sheet and the script only. Spreadsheet Alchemy is still a work in progress.

Advanced

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

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

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

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 101-120 of 120 in total

TAGS

FORMULAS

TOPICS

120 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

How to Create a CRM in google sheets w/ Dashboard

Create a Podcast Advertising Calculator

Create Square Cells for Dashboards or Beautiful Information

Ken Asks: Can We Add Star Ratings?

Aesthetics Teaser: How To Use Alternating Colors

Search for Photos in a Google Sheet

Creating A Dark Mode Theme | Announcing Dark Habits

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Wordle in a Google Sheet | Work in Progress

How to Name Sheet Tabs

6 Ways to Make Your Checkboxes Better

Convert Your Bullet Journal To Google Sheets

David Asks: About Primary Keys

From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3

How Can I Compare Two Tabs for Differences?

Create Navigation Like A Book or Presentation

Every Tab Has a Unique ID called GID

Getting Started Coding in Apps Script

Meet Asa: Ask Sheets Anything

OpenSea Data Inside Sheets