Google Sheets Tutorials · Better Sheets

Bjarne Asks: Can I show the total number of rows minus the header row?

find out how to show the total number of data rows available in a sheet.

Beginner

COUNTA() COUNTBLANK() SUM()

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.

Beginner

CONCAT()

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.

Advanced

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()

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.

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.

Discover Misspelled Duplicates

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates.

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records.

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed.

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.

Beginner

ARRAYFORMULA() COUNTIF() LOWER() SORT() UNIQUE() +1 more

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.

Intermediate

INDIRECT() SORT() TRANSPOSE()

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet

Beginner

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.

Intermediate

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.

Beginner

FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more

Introduction to Spreadsheet Automation 101 Lesson 3

This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.

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.

FILTER() IFNA() JOIN() TRANSPOSE()

BetterSheets.co Tour for Lifetime Members

Find out all that Better Sheets has to offer you. Learn where to learn. Find out the features available to lifetime members at BetterSheets.co

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.

COLUMN() IF() INDEX() INDIRECT() ROW()

Choose Your Anonymous Avatar

Now you can choose your avatar here on Better Sheets. Enjoy choosing between every available animal from Alligator to Wombat. You can choose Nyancat or Kraken too!

Create Navigation Like A Book or Presentation

A pretty cool script I came up with to click and set active the next tab. No matter how many tabs/sheets you have. Makes a book-like page turning action. At the end of the video I say you have to wait, but now you can get the sheet and the script only. Spreadsheet Alchemy is still a work in progress.

Advanced

Best Header Font Ever

Learn about "Oswald" the best font for headers. You might fall in love with this font as much as I've fallen in love with Karla (the font). It helps your headers stand out without having to do much coloring or more. A little change to your header font and your sheets will look better.

Beginner

YouTube Title Rewriter with GPT-3

Rewrite YouTube Titles with GPT-3 API. Writes shorter, more persuasive titles I can use to increase views on YouTube. Code is included in Apps Script of sheet.

Advanced

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk through the features here. And get yourself a copy of the sheet below.

Beginner

SUM()

Displaying items 301-320 of 323 in total

TAGS

FORMULAS

TOPICS

323 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Bjarne Asks: Can I show the total number of rows minus the header row?

4 Ways to Make a New Spreadsheet

Made a Conference Schedule Better - Member Request!

How To Replace First Word | Great for SEO keyword research

Figure Out Frequency

Richard Asks: Copy Template Tab and Rename to Date Every Week

Discover Misspelled Duplicates

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

Better Than Happy | Redesign of The Feelings Wheel

Anika Asks: How To Set Text Overflow All The Time

Announcing Sell Daily and How I Built Sell Daily

Introduction to Spreadsheet Automation 101 Lesson 3

Create a Many to Many Database

BetterSheets.co Tour for Lifetime Members

How Can I Compare Two Tabs for Differences?

Choose Your Anonymous Avatar

Create Navigation Like A Book or Presentation

Best Header Font Ever

YouTube Title Rewriter with GPT-3

Visicalc 2023 Quick Walkthrough