Google Sheets Tutorials · Better Sheets

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.

Advanced

Create a ChatGPT Cheat Sheet Spreadsheet

Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.

Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script

Intermediate

CONCATENATE() COUNTIF() IF() ISBLANK() LEN() +2 more

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet into a cell.

CONCAT() HYPERLINK()

Spreadsheet Automation 101: Camel Case

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.

Better Numbers and Bullet Points in Your Spreadsheets

Improve Google Sheets Readability
Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets.

Create Visually Appealing Sheets
Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.

Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting.

The Benefits of Using Bullet Points and Numbering in Spreadsheets
Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features:

Bullet points and numbering help to organize information in a logical and easy-to-follow way
They make it easier to scan and find important information quickly
They can help to emphasize key points and make them stand out from the rest of the data
They make your spreadsheet look more visually appealing and professional

Beginner

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

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

Spreadsheet Automation 101 Lesson 2: Arrays

Learn the basics of Arrays – how to create one, how to reference rows and columns of data in a different way, and how to get an entire column or row in Apps Script.

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!

Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker

Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.

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

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

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.

Beginner

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.

CHAR() DEC2HEX() MID() RANDBETWEEN()

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Learn about the strategy and concept of the SpreadsheetApp. Understand rows, columns, and cells better.

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.

Intermediate

COUNTIF() FILTER() JOIN() TRANSPOSE()

Find The Most Common Word(s)

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

Intermediate

Creating Blank Cells For Good Reasons with IfError Formula and if(isBlank) Formula

There are surprisingly few times you want to have blank cells, or even create blank cells. In this video I'll show you the good reasons you want blank cells.

Capitalize Each Word

Every word can be capitalized with this formula.

LOWER() PROPER() UPPER()

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.

Beginner

CONCATENATE() COUNTA() IF() MATCH() ROW() +1 more

Displaying items 1-20 of 189 in total

TAGS

FORMULAS

TOPICS

189 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Create a new Spreadsheet from just a Name in a Sheet.

Create a ChatGPT Cheat Sheet Spreadsheet

Creating a Custom URL Link for Your Spreadsheet

Spreadsheet Automation 101: Camel Case

Better Numbers and Bullet Points in Your Spreadsheets

Create a Sheet of Sheets for Project Management and/or Data Management

Create Square Cells for Dashboards or Beautiful Information

Spreadsheet Automation 101 Lesson 2: Arrays

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker

Create a Many to Many Database

Create Navigation Like A Book or Presentation

Create a CPM Custom Function (Create Better Calculators!)

5 Ways to Create Coupon Codes | Create UUIDs

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Tagging Titles, Create a Comma Separated List of Tags

Find The Most Common Word(s)

Creating Blank Cells For Good Reasons with IfError Formula and if(isBlank) Formula

Capitalize Each Word

How to Find Duplicates and create a Duplicate Detector