Google Sheets Tutorials · Better Sheets

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

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!

Beginner

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

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

Aesthetics Teaser: How To Use Alternating Colors

How to use alternating colors in your spreadsheets.

Beginner

RANK()

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

How to Name Sheet Tabs

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

Beginner

2 Ways to Hide Data

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

Intermediate

IF()

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

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

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

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

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

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

Displaying items 101-120 of 126 in total

TAGS

FORMULAS

TOPICS

126 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

How to Make Hangman Game In Google Sheets

3 Ways to Count in Google Sheets

Google Sheet Basics - The Absolute Basics

Create Square Cells for Dashboards or Beautiful Information

Ken Asks: Can We Add Star Ratings?

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

Get Every Row 5 Times

Aesthetics Teaser: How To Use Alternating Colors

How Does Split Work?

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

How to Name Sheet Tabs

2 Ways to Hide Data

Convert Your Bullet Journal To Google Sheets

5 Ways to Create Coupon Codes | Create UUIDs

David Asks: About Primary Keys

Use Row() For Math You Need to Iterate

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

This Seems Like Automation

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

Create Navigation Like A Book or Presentation