TRY ME!
→ Random Tutorial

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

Make Your Lists Spicy Hot in Google Sheets

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
Beginner
CONCAT() ROW()
Ken Asks: How can I count true and false? Answer: w/ CountIF()

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.
Beginner
COUNTIF()
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
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()
Figure Out Frequency

Figure Out Frequency

Fid out how to get the frequency of ProductIds, or Names, or Emails. or how many times they appear in a sheet/column/row.
5 Ways to Create Coupon Codes | Create UUIDs

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.
CHAR() DEC2HEX() MID() RANDBETWEEN()
5 Ways to Generate Random Numbers

5 Ways to Generate Random Numbers

generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
Intermediate
RAND() RANDBETWEEN()
Extract URLs from Google Sheets

Extract URLs from Google Sheets

When you can't get the url of a hyperlinked cell, do this instead.
Announcing AtomicSheets.com

Announcing AtomicSheets.com

Most Popular Beginner
David Asks: About Primary Keys

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Intermediate
INDEX() MATCH()
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
Sync Two Tabs Without ImportRange()

Sync Two Tabs Without ImportRange()

Get this epic script that automatically edits two tabs and keeps them in sync.
Advanced
Facebook Ads Mockup Generator

Facebook Ads Mockup Generator

Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!
Beginner
IMAGE() LEN()
Learn to Code in Google Sheets, For Programmers

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".
Intermediate
IMAGE()
Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.
Beginner
Hold a Giveaway Raffle in a Google Sheet

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks to do.
This Seems Like Automation

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more
Sheet Review of 50 ChatGPT Prompts

Sheet Review of 50 ChatGPT Prompts

Tips to help improve the look, feel, branding of Better Sheets Member’s Free Lead Magnet. A free Google Sheet of ChatGPT Templates that just gets better by the end of the video.
 Tag Emails From A List of Members in Google Sheets

Tag Emails From A List of Members in Google Sheets

Add labels to gmail emails you get from email addresses you put in a Google Sheet list. Great for tagging members, subscribers, users, when you want to prioritize them in your Gmail. Great to see a function laid out that interacts with Gmail inside of Google Sheets Apps Script.
Advanced
Figuring out the 80/20 Rule with a Running Sum Total

Figuring out the 80/20 Rule with a Running Sum Total

I figured out that 20% of my videos are getting 80% of the watch time on my YouTube channel, and I actually used a Google sheet to figure this out.
Beginner
SUM()

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