TRY ME!
→ Random Tutorial

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

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()
100 Tweet Starters

100 Tweet Starters

Created a simple tweet starter sheet. Tweet directly from this Google Sheet. Free for Members.
Beginner
Create Drop Shadows! This makes your dashboards pretty.

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.
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/
How to Add YouTube Thumbnails

How to Add YouTube Thumbnails

Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.
FIND() IFERROR() INDEX() SPLIT() SUBSTITUTE()
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
Create a Self-Adding Dropdown Menu

Create a Self-Adding Dropdown Menu

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.
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()
Headline Generator: Add Dropdowns

Headline Generator: Add Dropdowns

Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.
Most Popular
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()
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

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