Google Sheets Tutorials · Better Sheets

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

How Do I Make a CSV File? And give a link to someone instead of the csv.

Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

FILTER() FLATTEN() IF() IFERROR() TRANSPOSE() +1 more

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

Every Tab Has a Unique ID called GID

Less than 2 minute tip to help you link directly to a tab in a sheet. Each spreadsheet file has it's own unique id, a url. But also every tab has a unique "gid" that you can use to link directly to a tab in a sheet. Saving people a click.

Beginner

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

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

Change the Default Font

Set a different default font for each sheet you open.

Beginner

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

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.

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor.

Beginner

FLATTEN()

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

Displaying items 281-300 of 317 in total

TAGS

FORMULAS

TOPICS

317 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Build a Better ChatGPT Prompt Builder

How Do I Make a CSV File? And give a link to someone instead of the csv.

This Seems Like Automation

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

Every Tab Has a Unique ID called GID

Visicalc 2023 Technical Walkthrough

Roast: 363 Questions VCs Ask Founders

Find The Most Common Word(s)

Change the Default Font

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!

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Wrangle Scattered Data with Flatten()

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

Discover Misspelled Duplicates