TRY ME!
→ Random Tutorial

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

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.
Ian Asks: How to sort dates by year/month (can't do with filter)

Ian Asks: How to sort dates by year/month (can't do with filter)

In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.
Better Font Colors

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/
Create a Guess The Number Game | Challenge!

Create a Guess The Number Game | Challenge!

Use random number generators to make a number guessing game.
Intermediate
RAND() ROUND()
Generate Hundreds of Business Names

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.
How to Download a Sheet as a CSV with a URL only

How to Download a Sheet as a CSV with a URL only

So you want to download a Google Sheet as a CSV. Let's do it!
Beginner
How To Color Cell Blocks So Others Enter Data Easily

How To Color Cell Blocks So Others Enter Data Easily

Use neon blue to show where someone needs to enter data.
Beginner
How To Track Crypto Prices

How To Track Crypto Prices

Get crypto prices into a Google Sheet.
Intermediate
GOOGLEFINANCE()
How to Get Time from a Timestamp

How to Get Time from a Timestamp

Extract the time from a Google Sheets timestamp.
Beginner
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
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()
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()

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