TRY ME!
→ Random Tutorial

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

5 Ways to use IF() Formula to Create Magic in Your Sheets

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.
Intermediate
AND() IF() IFS() ISBLANK() OR() +1 more
Show Sheet Tabs Based on Edit

Show Sheet Tabs Based on Edit

Show a sheet or tab based on a code being entered in one sheet.
Intermediate
Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

An epic sheet improved in under one hour. Watch this video to see me revamp a Google Sheet and Take it to the Next Level!  Discover the Secrets to Improving this EV Universe Sheet, Including Customized Colors, Easy Navigation and Valuable Updates. 
 Better Sheets Videos Checklist

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.
Data validation Beginner
COUNTA() COUNTIF() FILTER() IFNA() SORT() +1 more
Sheet Improvement: Better Band Bureau Better Schedule

Sheet Improvement: Better Band Bureau Better Schedule

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.
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()
Great Sheets! Community Information Board by Seedtable.com

Great Sheets! Community Information Board by Seedtable.com

Incredible design and inspiration for us in our sheets.
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced
Secure Your Sheets by BetterSheets.co

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.
Beginner
ARRAYFORMULA() FILTER() INDEX() MATCH() MIN()
Get More Sheets Help

Get More Sheets Help

How To Ask Questions as a Better Sheets Member
14 Sheet Ideas You Can Sell

14 Sheet Ideas You Can Sell

Strategic ideas, examples of sheets you can sell or create as lead magnets
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
Advanced
Highlight Row as You Move Your Cell Selection

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move your cell selection.
Conditional Formatting Beginner
Build a Better ChatGPT Prompt Builder

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.
JOIN() SUBSTITUTE()
Make a Better Template - Ambassador Nomination Template

Make a Better Template - Ambassador Nomination Template

Create a nomination or voting template. Looking to build better Google Sheets? Andrew from Better Sheets is here to help! Join his membership to access exclusive videos and email support. In this video, Andrew takes a closer look at a Google Sheet template by Tableau ambassador Adam Miko, offering tips and tricks for a better user experience. Save time and effort with Andrew's easy copy-and-paste method. Want more? Join his membership today and start building better Sheets! 
 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
Add Cool Responsive Graphs to Your Stock Tracking Sheets

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!
GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()
Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.
Make Your Headers Useful

Make Your Headers Useful

Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.
Sheet Improvement: Better Business Idea Selection Framework

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.
ARRAYFORMULA() IFERROR()

Displaying items 201-220 of 348 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