TRY ME!
→ Random Tutorial

141 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!

How do I prevent people from sharing my spreadsheets by making a copy?

How do I prevent people from sharing my spreadsheets by making a copy?

A video I did summarizing the 3 things you can do to help people who share your sheet, not do it, or at least get some value from it.

More info on the course: sellingspreadsheets.com

→ Get OnlySheets

Beginner
SECTION 3 - How to Make a Spreadsheet

SECTION 3 - How to Make a Spreadsheet

Crafting High-Demand Sheets from Scratch. Turn templates into tools to make sellable spreadsheets.
Intermediate
Activate A Certain Sheet When Opening a Spreadsheet

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.
Intermediate
SECTION 4 - Spreadsheet Sales Mastery

SECTION 4 - Spreadsheet Sales Mastery

Turn Google Sheets into Revenue Streams with a simple sales page. Tell the story your users want to buy into.
Intermediate
The Strangest Secret to Selling a Spreadsheet

The Strangest Secret to Selling a Spreadsheet

Don’t sell a spreadsheet. Feature the problem and solution, not the sheet itself. It just so happens to be a spreadsheet.
 Pricing Strategies for Spreadsheets

Pricing Strategies for Spreadsheets

Pricing is an art. Learn to balance affordability with profitability, understand market expectations, and apply different pricing models to maximize revenue.
Intermediate
A Spreadsheet CRM: Automation at work

A Spreadsheet CRM: Automation at work

Check out a CRM built inside of Google Sheets called SheetifyCRM.com
Beginner
SECTION 6 - Spreadsheet Breakdowns

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

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

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

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

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

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?

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()
Can I get alerted when a tab name is changed?

Can I get alerted when a tab name is changed?

Find out in this quick experiment if a tab name can be alerted to the owner of the spreadsheet. Great for owners and operators who want to know if someone is changing the sheet.
 3 Free Tools to Make Your Google Sheets Better

3 Free Tools to Make Your Google Sheets Better

3 add-ons you can install right now and your Google Sheets life is better!
Tiny Sheets makes it simple to delete excess blank rows and columns.
Sheet Styles makes for less headaches and better text colors.
Button Styles makes awesome buttons for your users to click.
 Go to Specific Cell When Spreadsheet is Opened

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
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
Access Free API's with Google Sheets

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets. 
API's here: freepublicapis.com
Intermediate
COUNTIF() IF() IMAGE() ISBLANK()

Displaying items 61-80 of 141 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons