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!

My Favorite Fonts

My Favorite Fonts

Learn the best fonts to use in Google Sheets.
Beginner
Merge Cells for Dashboards

Merge Cells for Dashboards

to make better Dashboards consider merging cells.
Beginner
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
Conditional Formatting Intermediate
100 Tweet Starters

100 Tweet Starters

Created a simple tweet starter sheet. Tweet directly from this Google Sheet. Free for Members.
Beginner
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
Building the Newsletter Geeks Virtual Mall

Building the Newsletter Geeks Virtual Mall

We're gonna create another virtual mall, and in this one we're gonna make it for newsletters
Advanced
CONCATENATE()
Announcing OnlySheets

Announcing OnlySheets

Introducing OnlySheets, the paywall for Google Sheets.
Most Popular
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()
Find "Entry Number" for Bookmarklet

Find "Entry Number" for Bookmarklet

Followup to the Bookmarklet video. To help you find the entry number for each form field.
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 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
Add Team Members to the Quick CRM

Add Team Members to the Quick CRM

We have a question from Rupesh about the quick CRM. He wants to add some team members.
Intermediate
FILTER() IMPORTRANGE()
Roast: Hotel PPC Channel Cost Calculator

Roast: Hotel PPC Channel Cost Calculator

I have no idea what to do as a user, so let's make it better.
Intermediate
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

Displaying items 221-240 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