TRY ME!
→ Random Tutorial

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

Roast: Sales Tax Calculator

Roast: Sales Tax Calculator

I would not think that I would enjoy sales tax calculators, no one enjoys sales tax calculators, but when it's in a Google sheet, it's really exciting.
Intermediate
How to Find Duplicates and create a Duplicate Detector

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.
Beginner
CONCATENATE() COUNTA() IF() MATCH() ROW() +1 more
Basics - 5 Ways to Change Row Height

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.
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
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.
Conditional Formatting Beginner
Biggest Flaw In Dashboards with Dark Colors

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.
Pabbly Connect Countdown - "Sheet Improvement!"

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!
 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()
Create an Email Campaign Stats Calculator

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
CONCATENATE() ROUNDDOWN() UPPER()
Creating A Dark Mode Theme | Announcing Dark Habits

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Most Popular Intermediate
ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +6 more
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
Ken Asks: How can I count true and false? Answer: w/ CountIF()

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()
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()
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
Beginner
TRANSPOSE() UNIQUE()
Anders Asks: Find first and last of filter by date

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.
Beginner
COUNT() IF() INDEX()
How to Name Sheet Tabs

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

2 Ways to Hide Data

Hide data with these simple tricks. Just using the IF() formula.
Intermediate
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
Get Twitter Handles Easily by changing URLS to @

Get Twitter Handles Easily by changing URLS to @

Change Urls to @ using Substitute()
Beginner
SUBSTITUTE()

Displaying items 241-260 of 280 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