183 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀: Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯: Precise: Ensure your data is always accurate and your analysis is clear.
🌈: Creative: Discover new ways to use Google Sheets.
❌: Can't Find a Video?: Members can reach out and ask me anything!

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

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script

Intermediate

COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

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.

Replace 1,000 Formulas Instantly

Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video. Then show you how to use it better.

Beginner

ARRAYFORMULA() SORT()

Spreadsheet Automation for Beginners

I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.

Learn more Automation: https://bettersheets.co/courses/spreadsheet-automation-101

Get the AI GPT-3.5 and GPT 4 code: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Better Sheets members can get the code and the sheet in the video below.

Beginner

INDEX() SPLIT()

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets

Squeezed Rows
Garbage Data
Looks The Same
Crazy Column Width
Where’s Waldo
Of Results
Too Many Clicks
Instructions Unclear
Eye Strain and Headaches
Lazy Conditional Formatting
Too Many Cells

Conditional Formatting Data validation Beginner

IF() ISBLANK() ISEMAIL() ISURL()

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!

Intermediate

IF() ISBLANK() SUBSTITUTE()

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER! Imagine having the ability to effortlessly validate text patterns, ensuring the integrity of your data. Whether you're searching for specific mentions, cleaning up unwanted content, or filtering out irrelevant information, our REGEXMATCHER is your go-to solution.

Error-Free Data:

Experience precise data validation ensuring your information is accurate and error-free.

Effortless Pattern Recognition:

Easily identify and eliminate unwanted data patterns, guaranteeing a clean and organized dataset.

Tailored Data Classification:

Classify your data based on specific patterns, streamlining your workflow and increasing efficiency.

Advanced

IF() REGEXMATCH()

Maximize Spreadsheet Sales to Startups

A Review of Gary's AARRR Tracker and Landing Page Strategies that you can employ if you're selling templates, spreadsheets, and google sheets to Startups.

Explore how to enhance a spreadsheet landing page's appeal and effectiveness. Discover innovative strategies for crafting compelling landing pages, learn the art of selling solutions (not just spreadsheets), and get tips on leveraging Google Sheets to create digital products that truly resonate with your audience.

Whether you're a seasoned spreadsheet seller or just starting out, this video is packed with actionable advice to elevate your sales game. Tune in and transform your spreadsheet into a sellable sensation.

3 Key Takeaways

Market spreadsheets as problem-solving solutions, not just as templates or tools.
Design landing pages that tell a compelling story and focus on the benefits and solutions offered by the spreadsheet.
Utilize Google Sheets' advanced features and automations to enhance functionality and add value to your spreadsheet product.

If you want to automate your spreadsheets more, take the course: Spreadsheet Automation 101.

Intermediate

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

Selling Spreadsheets Course Introduction

Let's go sell great spreadsheet products.

Explore Your Spreadsheet Selling Options

- Template
- Custom Formulas
- Custom Functions - Apps Script
- Google Sheet Add-ons

Surprising Things about Selling Spreadsheets

A few things that surprised me when I started selling sheets. From landing page copy that converts, to what people want to know after they buy.
- Adding videos to onboard helps immensely.
- Landing page copy should agitate, not solve everything.
- Sheets aren’t sold, they’re bought.
- Selling a great sheet is selling a great process.
- You can Launch, again and again… seemingly forever.

SECTION 2 - Your Spreadsheet Blueprint

Figure out the framework to consistently come up with spreadsheet-able ideas and make them super easy to execute from your laptop.

The #1 Mistake Spreadsheet Sellers Make and how to Save People Time

Scope down from an existing problem to a sheet that still solves a juicy problem. If you can solve something in 10x less time, you win. Find out how lack of specificity is the #1 mistake. I’ll share with you a quick way to figure out if you’re really saving people time.

Problems Everywhere, and the Spreadsheets that Solve Them

In my video, I talk about how common problems are and how Google Sheets can help solve many of them in business. I discuss the different ways Google Sheets can be used, from simple to complex tasks, and plan to share five specific ways to use it effectively in future videos for better planning, tracking, and managing tasks.

How to Make an AI Integrated Freebie Spreadsheet

Get the freebie here at @abloommedia on TikTok or on Abloommedia.com
Sorry no sheet available even for members. Get the AI code in the video mentioned: Upgrade AI to GPT 4

Intermediate

IF() ISBLANK()

How to Make Good Looking Spreadsheets

Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.

Intermediate

Displaying items 61-80 of 183 in total

TAGS

FORMULAS

TOPICS

183 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

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

5 Ways To Use Google Sheets for Advanced Project Management

Calculate ROAS in Google Sheets

Create a ChatGPT Cheat Sheet Spreadsheet

Write Apps Script to Create a New Google Sheets Formula

Replace 1,000 Formulas Instantly

Spreadsheet Automation for Beginners

10 Things I Hate About Your Spreadsheets

One Weird Google Sheet Formula for Bulk Publishing With AI

REGEXMATCH Formula Generator for Google Sheets

Maximize Spreadsheet Sales to Startups

A Few New Spreadsheet Business Ideas

Selling Spreadsheets Course Introduction

Explore Your Spreadsheet Selling Options

Surprising Things about Selling Spreadsheets

SECTION 2 - Your Spreadsheet Blueprint

The #1 Mistake Spreadsheet Sellers Make and how to Save People Time

Problems Everywhere, and the Spreadsheets that Solve Them

How to Make an AI Integrated Freebie Spreadsheet

How to Make Good Looking Spreadsheets