Google Sheets Tutorials · Better Sheets

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.

Beginner

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

Advanced

HYPERLINK()

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

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

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

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

3 More Ways to Count in Google Sheets

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

Beginner

COUNTBLANK() COUNTIFS() COUNTUNIQUE()

Sheet Styles A Free Google Sheet Add-on by Better Sheets

Install Sheet Styles now: https://sheet-styles.bettersheets.co/

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

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

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Learn to code in sheets. Automate Your Daily Sales Report with Google Sheets: Learn how to create a script that copies data from one sheet to another, including timestamps. Boost your productivity with this easy guide!

Advanced

NOW()

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6

this completes learn to code in Google Sheets and I wanted to finish off by giving you a few more quick concepts that expands your mind of what Google Sheets can do.

Advanced

Tag Emails From A List of Members in Google Sheets

Add labels to gmail emails you get from email addresses you put in a Google Sheet list. Great for tagging members, subscribers, users, when you want to prioritize them in your Gmail. Great to see a function laid out that interacts with Gmail inside of Google Sheets Apps Script.

Advanced

Embed a Headline in a Website from Google Sheets

One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!

Advanced

SUBSTITUTE()

Roast: Mortgage Calculator for Google Sheets

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

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.

How To Set Up Stripe Webhook to Google Sheets with Google Script

Learn how to set up a Stripe web hook in a Google sheet and Stripe to track new customers, payments, and cancellations with ease! Get the script and code on GitHub, available for everyone. No need to be a Better Sheets member.

Advanced

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

FILTER() IMPORTRANGE()

How to Redirect Domains to Google Sheets and Google Docs

Learn how to use URL forwarding to Redirect Domains to Google Sheets and Google Docs. Also included is a new feature I like to in Google which is Publish To the Web. In a previous video about this topic I might not have mentioned that.

Intermediate

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()

Beginner

AND() FILTER() IF() SORT()

Displaying items 21-40 of 342 in total

TAGS

FORMULAS

TOPICS

342 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

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

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Manage Your Wedding Guest List in Google Sheets

Calculate ROAS in Google Sheets

3 More Ways to Count in Google Sheets

Sheet Styles A Free Google Sheet Add-on by Better Sheets

How to Make Hangman Game In Google Sheets

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

Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4

Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6

Tag Emails From A List of Members in Google Sheets

Embed a Headline in a Website from Google Sheets

Roast: Mortgage Calculator for Google Sheets

Great Sheets! Corona Hiring Sheet

How To Set Up Stripe Webhook to Google Sheets with Google Script

Create a Public Sheet and Private Sheet: Using ImportRange()

How to Redirect Domains to Google Sheets and Google Docs

Optimize SEO with Google Sheets and Google Search Console