Topics → Most Popular

Includes

21 Tutorials

You'll be saying "You can do that in Google Sheets?"


Most Popular Google Sheet Tutorials on BetterSheets.co

Discover the Best Tutorials to Enhance Your Google Sheets Experience

Google Sheets is a powerful tool that can help you organize and analyze data quickly and efficiently. However, many users may not know how to fully utilize all the features and functions available in the application.

 Luckily, BetterSheets.co has compiled a list of the most popular tutorials to help you enhance your Google Sheets experience. These tutorials are popular among members.


From creating pivot tables to automating data entry, these tutorials will show you how to take advantage of Google Sheets' full potential. This article will guide you through the most popular Google Sheet tutorials available on BetterSheets.co.


Let's Make a Bookmarklet!
Bookmarklets are small, self-contained pieces of JavaScript that you can save as bookmarks in your web browser. With a bookmarklet, you can perform all sorts of tasks on a webpage with just one click. In this tutorial, you'll learn how to create a bookmarklet that allows you to clip web content directly to your Google Sheet.


To create the bookmarklet, you'll need to know a little bit of JavaScript, but don't worry - we'll walk you through the process step-by-step. Once you've created the bookmarklet, you'll be able to use it to clip text and links directly from the web to your Google Sheet with just a few clicks.


Google Sheets Error: Unknown Range Name and How to Fix it
If you've ever worked with Google Sheets, you've probably encountered the dreaded "Unknown Range Name" error at some point. This error occurs when you've typed in a formula with the wrong format of a sheet name. In this tutorial, we'll show you how to fix this error, as well as some other common errors that might pop up in Google Sheets.

We'll walk you through some simple steps you can take to troubleshoot and fix this error in your Google Sheets.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

21 Tutorials

Let's Make a Bookmarklet!

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.
Google Sheets Easter Eggs Beyond PRIDE

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"
Google Sheets Error: Unknown Range Name and How to Fix it

Google Sheets Error: Unknown Range Name and How to Fix it

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.
Add Icons To Your Sheets With a Domain Name

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)
IMAGE()
Announcing OnlySheets 2.0

Announcing OnlySheets 2.0

In this exclusive video, I will explain the benefits of using Only Sheets and why it exists.

I'll also show you how to set up Only Sheets 2.0 and how it can be used to sell templates and other info products.

Throughout the video, I'll address common issues and provide tips for maximizing the potential of Only Sheets.

Stay tuned for Payment Process step-by-step instructions.

Get OnlySheets 2.0 here: BetterSheets.co/tools/onlysheets
Lifetime members get it free
Anyone else can purchase OnlySheets for $30 via gumroad here: https://gum.co/onlysheets
Meet Asa: Ask Sheets Anything

Meet Asa: Ask Sheets Anything

GPT3 Powered Answers to your spreadsheet questions. Ask sheets anything, literally any question about Google Sheets! This might put me out of a job as a Google Sheets Expert.
Announcing AtomicSheets.com

Announcing AtomicSheets.com

Create a Headline Generator

Create a Headline Generator

Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.
PROPER() CONCATENATE()
Headline Generator: Add Dropdowns

Headline Generator: Add Dropdowns

Create a headline generator inside Google Sheets. Add dropdown menus to make the generator easy to us.
Create a Trello Board with Transpose Formula in Google Sheets

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.
TRANSPOSE()
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.
Create a Many to Many Database

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.
TRANSPOSE() FILTER() JOIN() IFNA()
Announcing OnlySheets

Announcing OnlySheets

Introducing OnlySheets, the paywall for Google Sheets.
Write Your First Script

Write Your First Script

I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Creating A Dark Mode Theme | Announcing Dark Habits

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
TODAY() COUNTIF() CONCATENATE() IFNA() ARRAYFORMULA() +6 more
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.
AND() IF() SWITCH() ISBLANK() IFS() +1 more
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
VLOOKUP() CONCATENATE()
Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.
QUERY()
Make Unsplash in Google Sheets - Part 2

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.
Find Hundreds of Available Domains From Keywords with Concat and Array Formula

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.
CONCAT() ISBLANK() ARRAYFORMULA() IF()
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a row of data based on a single criteria in a column. Great for sales teams and maintaining a CRM.