TRY ME!
→ Random Tutorial

327 Google 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!

Find The Most Common Word(s)

Find The Most Common Word(s)

Find out which words in your sheet are the most common. Highest count of each individual word.
Intermediate
Change the Default Font

Change the Default Font

Set a different default font for each sheet you open.
Beginner
Get Data With Comments

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.
Beginner
Hide Gridlines for Better Communication

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.
Beginner
Write Your First Script

Write Your First Script

I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Most Popular Beginner
4 Ways to Make a New Spreadsheet

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.
Beginner
CONCAT()
Made a Conference Schedule Better - Member Request!

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.
Advanced
How to Use Smarket

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.
Beginner
Richard Asks: Copy Template Tab and Rename to Date Every Week

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.
Tagging Titles, Create a Comma Separated List of Tags

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.
Intermediate
COUNTIF() FILTER() JOIN() TRANSPOSE()
David Asks: About Primary Keys

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()
Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.
Intermediate
INDIRECT() SORT() TRANSPOSE()
Better Than Happy | Redesign of The Feelings Wheel

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet
Beginner
Anika Asks: How To Set Text Overflow All The Time

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.
Intermediate
Announcing Sell Daily and How I Built Sell Daily

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Beginner
FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more
Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
 Introduction to Spreadsheet Automation 101 Lesson 3

Introduction to Spreadsheet Automation 101 Lesson 3

This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
 BetterSheets.co Tour for Lifetime Members

BetterSheets.co Tour for Lifetime Members

Find out all that Better Sheets has to offer you. Learn where to learn. Find out the features available to lifetime members at BetterSheets.co
 How Can I Compare Two Tabs for Differences?

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()
Choose Your Anonymous Avatar

Choose Your Anonymous Avatar

Now you can choose your avatar here on Better Sheets. Enjoy choosing between every available animal from Alligator to Wombat. You can choose Nyancat or Kraken too!

Displaying items 301-320 of 327 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons