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

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

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

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.

Intermediate

AND() IF() IFS() ISBLANK() OR() +1 more

Create a Self-Adding Dropdown Menu

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!

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

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

FILTER() IMPORTRANGE()

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

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.

A Few New Spreadsheet Business Ideas

Learn how to import DropCatch data with 100,000 domains into a Google Sheet. Find out how to get a filtered list of domains with sheet in them. And how to generate ideas of what to build based on these found domains.

Leveraging Expired Domain Names for Google Sheets Business: The speaker discusses using expired domain names to create and sell Google Sheets templates or tools. He demonstrates how to find domain names related to 'sheets' and suggests creative business ideas around them.

Importing and Analyzing Data in Google Sheets: The process of importing CSV data into Google Sheets and manipulating it to find specific information (like domains containing the word 'sheet') is showcased. This highlights the versatility of Google Sheets in handling and analyzing data.

Idea Generation and Business Opportunities in Google Sheets: The speaker, Andrew Kamphey, provides several examples of how to generate business ideas using Google Sheets. He suggests various niches like WordPress-related spreadsheets, balance sheets for accountants, and even educational tools like math workbooks, demonstrating the wide range of potential applications for Google Sheets in various domains.

Intermediate

ARRAYFORMULA() FILTER() FIND() IF() IFERROR() +1 more

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.

Intermediate

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.

Advanced

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

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

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.

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 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.

Aesthetics Teaser: How To Use Alternating Colors

How to use alternating colors in your spreadsheets.

Beginner

RANK()

Displaying items 1-20 of 249 in total

TAGS

FORMULAS

TOPICS

249 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

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

Better Numbers and Bullet Points in Your Spreadsheets

4 Ways to Make a New Spreadsheet

5 Ways to use IF() Formula to Create Magic in Your Sheets

Create a Self-Adding Dropdown Menu

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

Tagging Titles, Create a Comma Separated List of Tags

Create a Radio Button From Checkboxes Using Google Apps Script

Create a Public Sheet and Private Sheet: Using ImportRange()

Create a ChatGPT Cheat Sheet Spreadsheet

Write Apps Script to Create a New Google Sheets Formula

A Few New Spreadsheet Business Ideas

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Create New Worksheet When Google Form Submitted

Creating a Custom URL Link for Your Spreadsheet

Create an Auto-Update Sales Chart: Trailing 12 Months

Spreadsheet Automation 101: Camel Case

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

Create a Trello Board with Transpose Formula in Google Sheets

Aesthetics Teaser: How To Use Alternating Colors