TRY ME!
→ Random Tutorial

170 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 a CPM Custom Function (Create Better Calculators!)

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.
Beginner
Announcing AtomicSheets.com

Announcing AtomicSheets.com

Most Popular Beginner
Restrict Access to a Cell if Another Cell is Blank

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?
Data validation Beginner
ISBLANK() NOT()
Convert Your Bullet Journal To Google Sheets

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.
Beginner
VLOOKUP()
Countdown Blank Row

Countdown Blank Row

Great for counting writing sessions, or tweets you're writing.
Beginner
CONCATENATE() COUNTA()
Wrangle Scattered Data with Flatten()

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor. 
Beginner
FLATTEN()
Get Twitter Handles Easily by changing URLS to @

Get Twitter Handles Easily by changing URLS to @

Change Urls to @ using Substitute()
Beginner
SUBSTITUTE()
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()
6 Ways to Make Your Checkboxes Better

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
Data validation Beginner
How to Name Sheet Tabs

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
Beginner
Interactive To-Do List

Interactive To-Do List

Create a simple to-do list that does so much more.
Beginner
IF()
How To Replace First Word | Great for SEO keyword research

How To Replace First Word | Great for SEO keyword research

Replace and find word will search your documents for specific text, replaced with different text, or you can replace it with something else.
Beginner
MID()
Anders Asks: Find first and last of filter by date

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.
Beginner
COUNT() IF() INDEX()
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()
More LinkInBio Templates for Google Sheets | SheetInBio

More LinkInBio Templates for Google Sheets | SheetInBio

You can easily add your own links and improve your bio for free.
Beginner
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
Don't Draw Attention to the Header

Don't Draw Attention to the Header

Common mistake is highlighting the header of a table in a bold color.
Beginner
How to Use Smarket

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.
Beginner
Add Pics to Marketplace in a Google Sheet

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.
Beginner
FILTER() IMAGE() INDEX() MATCH()
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
Beginner
TRANSPOSE() UNIQUE()

Displaying items 101-120 of 170 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