Google Sheets Tutorials · Better Sheets

Switch Data

We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.

Intermediate

SWITCH() VLOOKUP()

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

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

Beginner

COUNTA() COUNTIF()

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.

Intermediate

COUNTIF() MAX() SPARKLINE() TRUE()

Get Every Row 5 Times

Find out how to get a formula to get a row, but get it multiple times per row.

Intermediate

How Does Split Work?

We go deep into the syntax and usage of the SPLIT() formula.

Beginner

SPLIT()

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.

Beginner

COUNTIF()

Don't Draw Attention to the Header

Common mistake is highlighting the header of a table in a bold color.

Beginner

2 Ways to Hide Data

Hide data with these simple tricks. Just using the IF() formula.

Intermediate

IF()

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.

CHAR() DEC2HEX() MID() RANDBETWEEN()

Use Row() For Math You Need to Iterate

Create easy to use math iterators with the ROW() formula. It tells you the row your cell is on, but why do you need that? you can iterate math equations! It's neat!

Beginner

ROW()

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

Spreadsheet Automation 101: Camel Case

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.

Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes

Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.

Data validation Intermediate

IF()

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().

FILTER() FLATTEN() SORT() SUM() UNIQUE()

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

That Viral Growing Plant Progress Chart

Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.

Data validation Beginner

COUNTIF() IMAGE() SWITCH()

Displaying items 41-58 of 58 in total

TAGS

FORMULAS

TOPICS

58 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Switch Data

How to Make Hangman Game In Google Sheets

3 Ways to Count in Google Sheets

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Get Every Row 5 Times

How Does Split Work?

Ken Asks: How can I count true and false? Answer: w/ CountIF()

Don't Draw Attention to the Header

2 Ways to Hide Data

5 Ways to Create Coupon Codes | Create UUIDs

Use Row() For Math You Need to Iterate

Google Sheets Error: Unknown Range Name and How to Fix it

Spreadsheet Automation 101: Camel Case

Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes

This Seems Like Automation

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

Manage Your Wedding Guest List in Google Sheets

That Viral Growing Plant Progress Chart