Better Sheets

Login

Get Instant Access

TRY ME!

→ Random Tutorial

TAGS

Beginner

169

Intermediate

178

Conditional Formatting

11

Data validation

13

Advanced

104

Most Popular

13

168Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀: Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯: Precise: Ensure your data is always accurate and your analysis is clear.
🌈: Creative: Discover new ways to use Google Sheets.
❌: Can't Find a Video?: Members can reach out and ask me anything!

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?

Data validation Beginner

NOT() ISBLANK()

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.

VLOOKUP()

Countdown Blank Row

Great for counting writing sessions, or tweets you're writing.

COUNTA() CONCATENATE()

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor.

FLATTEN()

Get Twitter Handles Easily by changing URLS to @

Change Urls to @ using Substitute()

SUBSTITUTE()

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.

ROUND() COUNTA() RAND() INDEX()

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

How to Name Sheet Tabs

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

Interactive To-Do List

Create a simple to-do list that does so much more.

IF()

How To Replace First Word | Great for SEO keyword research

Replace and find word will search your documents for specific text, replaced with different text, or you can replace it with something else.

MID()

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.

COUNT() INDEX() IF()

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

INDEX() MATCH() VLOOKUP()

More LinkInBio Templates for Google Sheets | SheetInBio

You can easily add your own links and improve your bio for free.

How do I Insert Emojis into Google Sheets?

Using Control+Command+Space in inserting emojis into Google Sheets.

Don't Draw Attention to the Header

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

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

MATCH() FILTER() IMAGE() INDEX()

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.

UNIQUE() TRANSPOSE()

Adding Number and dot to rank or order lists

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution

CONCAT() ROW()

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0

VLOOKUP() CONCATENATE()

Displaying items 101-120 of 168 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons