TRY ME!
→ Random Tutorial

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

2 New Ways To Add Emoji Reactions

2 New Ways To Add Emoji Reactions

 Revolutionize the way you react with emojis! Discover two new methods to add emoji reactions and take your spreadsheets to the next level. Learn how to create a reaction clicker and a reaction picker to personalize your sheets with emojis. Don't miss out on this game-changing method in Google Sheets. 

We're adding some emoji reactions to Google Sheets.
 Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.
SPARKLINE()
My Favorite Fonts

My Favorite Fonts

Learn the best fonts to use in Google Sheets.
Beginner
Member Asks: How do I calculate from a set of Form entries?

Member Asks: How do I calculate from a set of Form entries?

Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.
ARRAYFORMULA()
Add a Checkbox to Turn on Dark Mode

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting
Conditional Formatting Beginner
Send Daily Email Updates

Send Daily Email Updates

extending Google Sheets in a really fun way. We're gonna be sending emails. I have had literally two people in the past week and a half ask me for this and I answered their question very specifically, but I wanna generally reach out to everyone here, give everyone the opportunity to learn this.
Advanced
Announcing OnlySheets

Announcing OnlySheets

Introducing OnlySheets, the paywall for Google Sheets.
Most Popular
Dark Mode / Better Font Color

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.
Intermediate
How to Find Duplicates

How to Find Duplicates

Learn how to find duplicates with a simple formula in Google Sheets.
CONCATENATE() FILTER() IF() MATCH() ROW()
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.
Generate Hundreds of Business Names

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.
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
Basic Keyboard Shortcuts To Speed Up Your Productivity

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.
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.
Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

how would I do the following? In Google Sheets, it's in column A I have a list of URLs. For each of those URLs, I want to pull that URL's featured image and meta description, and put those in columns B and C. Here's how you do it. I just grabbed Wikipedia articles for this example.
Advanced
IMPORTXML()
Bjarne Asks: Can I show the total number of rows minus the header row?

Bjarne Asks: Can I show the total number of rows minus the header row?

find out how to show the total number of data rows available in a sheet.
Beginner
COUNTA() COUNTBLANK() SUM()

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