TRY ME!
→ Random Tutorial

297 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!

Switch Months Menu - Design a Better Dashboard Part 4

Switch Months Menu - Design a Better Dashboard Part 4

Create a dropdown that changes the months displayed in a dashboard.
INDEX() MATCH()
Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

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()
How to Edit a Macro

How to Edit a Macro

Editing macros in Google Sheets helps you do more in less time.
Advanced
Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

ow do I show the date and time for the last time something was changed in a sheet? So what's interesting is that this This shows you Google Sheets shows an version history up here and shows you the last edit, but sometimes we want to have that data available to us inside of the sheet.
NOW()
Make a New Sheet - Best Practices

Make a New Sheet - Best Practices

Create a new sheet and do it well.
Beginner
Count How Many Subscribers In a Company by BetterSheets.co

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Intermediate
ARRAYFORMULA() COUNTIF() LOWER() SORT() SPLIT() +1 more
Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Enable your apps script functions be auto completed while you're using Google Sheets.
Advanced
Better Domain Portfolio Template

Better Domain Portfolio Template

Create a better list of domains.
Intermediate
COUNTA() FILTER() INDEX() MATCH() MAX() +1 more
Adding Number and dot to rank or order lists

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
Beginner
CONCAT() ROW()
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
Interactive To-Do List

Interactive To-Do List

Create a simple to-do list that does so much more.
Beginner
IF()
6 Ways to Make Your Checkboxes Better

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
14 Sheet Ideas You Can Sell

14 Sheet Ideas You Can Sell

Strategic ideas, examples of sheets you can sell or create as lead magnets
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.
Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Created a daily email with a motivational quote in the subject.
Intermediate
ARRAYFORMULA() COUNTA() IF() LEN() RANDBETWEEN()
Use Row() For Math You Need to Iterate

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()
Learn to Love Your Sheets

Learn to Love Your Sheets

Quick intro to a better experience of using Google Sheets
Beginner
ARRAYFORMULA() IMPORTRANGE()
Spreadsheet Automation 101: Camel Case

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: Arrays

Spreadsheet Automation 101 Lesson 2: Arrays

Learn the basics of Arrays – how to create one, how to reference rows and columns of data in a different way, and how to get an entire column or row in Apps Script.
Spreadsheet Automation 101 Lesson 4: UrlFetchApp

Spreadsheet Automation 101 Lesson 4: UrlFetchApp

Use any URL to scrape the web or access an API and get that info into your Google Sheet.

Displaying items 261-280 of 297 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