Google Sheets Tutorials · Better Sheets

SECTION 6 - Spreadsheet Breakdowns

Walk through real life examples of landing pages of spreadsheets for sale, and the actual spreadsheets.

Where to Sell Spreadsheets - Marketplace Marketing

Understand the perks and nuances of marketplaces like Etsy, Gumroad Discover, and AppSumo Marketplace. How to sell the same sheet on any online marketplace.

Intermediate

How to Sell Spreadsheets on AppSumo Marketplace

Get this tool: Coupon Code Maker to make it insanely easy to launch and sell on marketplaces like AppSumo Marketplace.

Intermediate

Protect Your Spreadsheet IP

Tips and tricks to make sure people don’t resell your sheet. Or if they do, catch them.
- Brand the heck out of your Awesome Useful sheets
- Add your business info everywhere (I mean everywhere!)
- Consider selling more than the sheet (advice/consulting/onboarding/auto email series/videos)

Intermediate

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

Automatically Backup a Spreadsheet

Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script. Two are shown here. to back up a tab or back up a spreadsheet file.

Intermediate

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

COUNTA() INDEX() RAND() ROUNDUP()

How do I reference a different spreadsheet in Apps Script?

I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.

Intermediate

IMPORTRANGE()

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons

Advanced Intermediate

Perfect Use of AI in Google Sheets (Categorize Tasks)

Explore how to use AI for task categorization in Google Sheets, from setting up the environment to using a pre-made code template. Watch as we walk through the process, from generating an API key to fine-tuning the prompt for effective categorization of work and home tasks.

Final code is available in the sheet below. And the original template code is available here:
https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.

Beginner

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula.

Intermediate

COUNTA() COUNTUNIQUEIFS() FILTER() TEXT() UNIQUE()

How to Filter Multi-Select Dropdown Feature

Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!

Intermediate

FILTER() SEARCH() SUM()

What Sucks About Selling Spreadsheets And How to Solve These Problems

I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.

Advanced

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

Advanced

AVERAGE() COUNTA() COUNTIF() FILTER() IF()

Launching SheetOps The Business Operations Task Manager

Jump in and watch this quick run through of what is SheetOps. It's not just an automated task list, it's a business operations command center. Command the chaos! Get it at https://BetterSheets.co/tools/sheetops

Advanced Intermediate

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

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting

Conditional Formatting Beginner

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.

Intermediate

Displaying items 81-100 of 178 in total

TAGS

FORMULAS

TOPICS

178 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

SECTION 6 - Spreadsheet Breakdowns

Where to Sell Spreadsheets - Marketplace Marketing

How to Sell Spreadsheets on AppSumo Marketplace

Protect Your Spreadsheet IP

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

Automatically Backup a Spreadsheet

Open Spreadsheet to Motivational Quote Automatically

How do I reference a different spreadsheet in Apps Script?

Advanced Coding in Google Sheets for Programmers

Perfect Use of AI in Google Sheets (Categorize Tasks)

Go to Specific Cell When Spreadsheet is Opened

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

How to Filter Multi-Select Dropdown Feature

What Sucks About Selling Spreadsheets And How to Solve These Problems

Automate Help Desk Ticket Closing

Launching SheetOps The Business Operations Task Manager

Creating a Custom URL Link for Your Spreadsheet

Add a Checkbox to Turn on Dark Mode

Intro Video - Make Better Sheets

Transform Information Into an Info Product