Better Sheets

Explore ↓

Free ↓

Login
Get Instant Access
TRY ME!
→ Random Tutorial

631Google 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!

▶

Why you think it matters, matters

Later in this course I’ll have a key insight about what to put on your sales page, and it will revolve around your own journey, your own problem you’re solving in your Google Sheets. Take the time now, to reflect on why you’re using the sheets you’re using and what problems you solved, for yourself. Truly knowing your why will help guide you to build a better spreadsheet, and will also help you understand which spreadsheet features you use to solve the problem you’re solving.
▶

How you think matters

Consider selling spreadsheets as selling your process. How you think matters just as much as what you know.
▶

Who you are matters

Bring your whole self to make a sellable spreadsheet. You want to be a reseller, not a seller.
▶

What you know matters

There are two types of people who will take this course. Those who have a sheet made, and those who don’t. Both groups share this one thing, they probably have a spreadsheet within them.
▶

SECTION 1 - You Are The Sheet

Selling Spreadsheets Section 1: You are the Sheet Introduction

Over the course of this section of selling spreadsheets, I'm going to share with you some theories that I have of how to bring your entire self into the world. To the spreadsheet that you're selling. Not just the idea, and not just the sheet itself, and not just your time, not just your energy, not just your experience, but everything holistically.
▶

Selling Spreadsheets Course Introduction

Let's go sell great spreadsheet products.
▶

Automatically Clear Content | Refresh Reuse Recycle Templates

Create automatic functions to clear content.
Intermediate
▶

Access the Dictionary API to get Definitions for Words in Google Sheets

Advanced
▶

Automatically Uncheck A Daily Checklist

Create an automatic unchecker for a daily checklist. Fun way to learn Apps Script and simple Google Sheets automation.
Beginner
▶

Automate Google Sheets With Zero Experience

By the end of this video you should be knowledgeable about how to automate spreadsheets. I'm assuming you have no knowledge of how to automate or how to code and so we're gonna start with a very blank page
Beginner
▶

YNAB Origin Story From Expense Recorder to $10M a Year Revenue

▶

How to Turn a Simple List into an Epic Lead Magnet

I got this lead magnet via twitter. It's simply a list of faceless youtube channel from a Faceless Youtube Academy. But I think it could have been a lot better. Let's explore ways to make this particular lead magnet into an Epic one.
Intermediate
IF() ISBLANK() ROUND()
▶

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad.

Get perspective on your 2024 plan with this full year calendar template in Google Sheets.

All-Year-in-One Overview

Imagine having the entire year's schedule on one single page. BIG YEAR offers a comprehensive 12-month display, providing an at-a-glance view of your whole year. This holistic perspective makes it easier to plan long-term projects, vacations, and personal milestones, ensuring you never miss out on life's big events.

More info on the Gumroad page
▶

How to Turn Background Color to Text

This tutorial showcases a practical solution to convert visual cues into actionable data in Google Sheets. It's a step-by-step guide on using Google Apps Script to automate the process of reading background colors and converting them into text. The focus is on simplifying data processing tasks and enhancing the utility of spreadsheets for data analysis.
Intermediate
▶

Celebrate Your Completed Checklists

Learn how to use apps script to add emoji animations when you complete a checklist in Google Sheets.
Advanced Intermediate
RAND() INDEX() IF() COUNTIF() IFNA() +3 more
▶

Brighten Up Your Checklist Automatically

Create a cool function that brightens your sheet background from white to some specific color  a little bit each time you check off a to-do item.
Intermediate
▶

Whitening Google Sheet Prank

Drive your office crazy by setting a trigger to lighten the text and background of your sheet by 1 rgb point every time they edit, or based on every hour!

Learn how to create triggers in a fun way.
Advanced
▶

Laziest Checklist Ever

Get your spreadsheet to check off your checklist for you.

Dive into spreadsheet automation with this easy to follow script, or copy the sheet and use the script as you wish.
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
FILTER() ARRAYFORMULA() LOWER() IF() IFERROR() +1 more
▶

Generate Coupon Codes from a Google Sheet - Announcing Coupon Code Maker

You can now generate 100% off unique 1 time use Gumroad Coupon codes from a Google Sheet.
It's $30, available now.
Lifetime members get it for free
https://bettersheets.co/tools/coupon-code-maker

What does Coupon Code Maker do?
Coupon Code Maker is designed for generating coupon codes, particularly useful for sellers on Gumroad. The tool, simplifies the process of creating large quantities of unique, single-use coupon codes.

The tool leverages Google Apps Script for its functionality, indicating a strong reliance on automation and API interactions. It's particularly noted for its ability to generate a high volume of codes quickly and efficiently, which can be exported as CSV files for use on platforms like AppSumo and others. This is important for marketing and selling products effectively on various online marketplaces.

There will be continuous updates to Coupon Code Maker. Get it now for a 1-time payment and you'll get all future upgrades for free.

If you're wondering how to build something like this check out Spreadsheet Automation 101 and Supercharge Your Sheets, two courses available for monthly members and lifetime members alike.
Intermediate

Displaying items 181-200 of 631 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons