Google Sheets Tutorials · Better Sheets

1 Simple Formula to Make Writing Tweets Easier or Make $1,000

Create a hook writing sheet with SUBSTITUTE(). Create an engine to write tweet upon tweet upon tweet. Bundle up 100 hooks/formats and sell it. Go ahead, make sweet tweets in a sweet sheet.

SUBSTITUTE()

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.

Advanced

Build a Domain Grader

Create a way to grade the quality of a domain based on many different votes and inputs and qualities. Like measuring the length and ranking the results.

ARRAYFORMULA() CONCAT() COUNTA() COUNTIF() LEN() +1 more

Roast: 363 Questions VCs Ask Founders

we got a pretty darn simple and sweet sheet here with funding. A lead magnet that is 363 questions that PCs investors ask startup founders.

Find The Most Common Word(s)

Find out which words in your sheet are the most common. Highest count of each individual word.

Intermediate

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Beginner

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.

Beginner

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.

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.

Beginner

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

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

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.

Beginner

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

Quadrant to List and List to Quadrant

We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.

Intermediate

FILTER() FIND() IF() IFERROR() JOIN()

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.

Advanced

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

Displaying items 301-320 of 338 in total

TAGS

FORMULAS

TOPICS

338 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

1 Simple Formula to Make Writing Tweets Easier or Make $1,000

Visicalc 2023 Technical Walkthrough

Build a Domain Grader

Roast: 363 Questions VCs Ask Founders

Find The Most Common Word(s)

Get Data With Comments

Hide Gridlines for Better Communication

Write Your First Script

Create Square Cells for Dashboards or Beautiful Information

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!

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

How to Use Smarket

How To Replace First Word | Great for SEO keyword research

Quadrant to List and List to Quadrant

Basic CRM - Add a Powerful Script To Move Row Based on Status

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