TRY ME!
→ Random Tutorial

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

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
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Beginner
CONCATENATE() JOIN()
Quickly Integrate AI and Google Sheets

Quickly Integrate AI and Google Sheets

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
Lock Your Sheets with OnlySheets

Lock Your Sheets with OnlySheets

Understand what you can do, if you use OnlySheets between your payment processor and the buyer.
Intermediate
Weird Idea: Find a Great Sheet Domain Name

Weird Idea: Find a Great Sheet Domain Name

Find a domain to get sheet ideas.
Intermediate
Saving OpenAI API Calls inside of Google Sheets

Saving OpenAI API Calls inside of Google Sheets

Copy text output and input into a google sheet from your OpenAI API calls. Great way to save AI text into a sheet or start to create your own AI writer, or even clone ChatGPT
Intermediate
Optimize SEO with Google Sheets and Google Search Console

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()
Beginner
AND() FILTER() IF() SORT()
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
Invoicing in Google Sheets for Freelancers

Invoicing in Google Sheets for Freelancers

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.
Beginner
FILTER() IFNA() SUM()
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
Build Your Own AI Writer in Google Sheets

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and code.
Advanced
SUBSTITUTE()
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()
Sync Tabs in Different Sections

Sync Tabs in Different Sections

How to sync different sections on different tabs. In this case we're taking data from multiple tabs putting into one, and syncing between those.
Advanced
Create an Internal Google Sheets Add-on

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.
Intermediate

Displaying items 221-240 of 358 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