TRY ME!
→ Random Tutorial

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

How to Create a CRM in google sheets w/ Dashboard

How to Create a CRM in google sheets w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.
Most Popular Intermediate
Google Sheet Basics - The Absolute Basics

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Beginner
Wordle in a Google Sheet | Work in Progress

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.
Intermediate
COLUMN() IF() INDEX() MID() TEXT()
Redirect a Domain to a Google Sheet

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.
Beginner
Most Common Errors and How To Handle Them in Google Sheets

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0
Beginner
CONCATENATE() VLOOKUP()
How do I Insert Emojis into Google Sheets?

How do I Insert Emojis into Google Sheets?

Using Control+Command+Space in inserting emojis into Google Sheets.
Beginner
How To Create An AutoFill in Google Sheets

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.
Beginner
INDEX() MATCH() VLOOKUP()
Twitter App Clone in a Google Sheet

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets
Beginner
Naughty or Nice? - Google Sheets' New Dropdown Chips

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?
Learn Google Sheet Formulas The Hard Way

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas
 Capture Emails from Website Form to a Google Sheet (Without Zapier)

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey
SUBSTITUTE()
Better Google Ad Writing Tool Sheet Makeover

Better Google Ad Writing Tool Sheet Makeover

Got an amazing tool from Inside Google Ads course by Jyll. She shares this tool, and I went for 30 minutes reviewing it, improving it, and redesigning it. Hope members can learn from this video. Jyll graciously allows me to share this sheet with members only!
CONCATENATE() IF() ISBLANK() LEN()
5 Ways To Use Google Sheets for Advanced Project Management

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
Intermediate
COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more
Magical Things You Can do with Checkboxes in Google Sheets

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.
Data validation Beginner
Troubleshooting Bitly in a Google Sheet Script

Troubleshooting Bitly in a Google Sheet Script

Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.
Advanced
Basics - Structure of a Sheet: Index() Row() and Column()

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.
Beginner
COLUMN() INDEX() ROW()
How to Make a Marketplace in a Google Sheet

How to Make a Marketplace in a Google Sheet

Make a marketplace where sellers and buyers do not have to have edit access to a sheet.
Intermediate
ARRAYFORMULA() FILTER() UPPER()
Search for Photos in a Google Sheet

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.
VLOOKUP()
Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends! 

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.
Beginner
COUNTA() INDEX() RAND() ROUND()
Get More Sheets Help

Get More Sheets Help

How To Ask Questions as a Better Sheets Member

Displaying items 61-80 of 368 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