Better Sheets
Tools, Templates, & Tutorials

Better Sheets Academy

Free Resources ↓

Member Login
Pricing
→ Random Tutorial

Tags

Formulas

131Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Wordle in a Google Sheet | Work in Progress
Building a clone of Wordle inside Google Sheets.
Intermediate
Better Domain Portfolio Template
Create a better list of domains.
Intermediate
Learn simple keyboard shortcuts to save you time
Learn some simple keyboard shortcuts.
Intermediate
Find Hundreds of Available Domains From Keywords with Concat and Array Formula
Build a list of domains you can buy right now. Easily check if the domain you want is still available.
Most PopularIntermediate
Added Categories to 100 Twitter Templates Template
Add one more feature to the 100 Twitter Templates tool.
Intermediate
Count How Many Subscribers In a Company by BetterSheets.co
I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Intermediate
Use Index Match when you want Vlookup
If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.
Intermediate
Creating A Dark Mode Theme | Announcing Dark Habits
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Most PopularIntermediate
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
Get Every Row 5 Times
Find out how to get a formula to get a row, but get it multiple times per row.
Intermediate
Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4
Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.
Intermediate
Create A Video Course in a Google Sheet | LMS in a Google Sheet
Set up a list of video links, and a checklist for others to use.
Conditional FormattingIntermediateData validation
Switch Data
We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.
Intermediate
How to Make a Quick CRM 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 PopularIntermediate
Make Unsplash in Google Sheets - Part 2
Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.
Most PopularIntermediate
Find Keywords in Any Column. Create quick search dropdown to find keywords
Create a quick search dropdown to find keywords in any column.
Intermediate
Create an Auto-Update Sales Chart: Trailing 12 Months
how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.
Intermediate
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!
Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today! 
Intermediate
Create a Trello Board with Transpose Formula in Google Sheets
Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.
Most PopularIntermediate
How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co
Create a pastel colored hunting game, just in time for Easter.
Intermediate

Displaying items 101-120 of 131 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons