TRY ME!
→ Random Tutorial

354 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 to Make an AI Integrated Freebie Spreadsheet

How to Make an AI Integrated Freebie Spreadsheet

Intermediate
IF() ISBLANK()
How to Make Good Looking Spreadsheets

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

Automatic Calculations

Create custom scripts to make your spreadsheets more like tools.
Beginner
You Must Double Duplicate (If you're selling a sheet you use)

You Must Double Duplicate (If you're selling a sheet you use)

How to turn a spreadsheet in your Google Drive into a sellable product. Step-by-step, I will show you exactly how I do it. If you're selling a sheet you use, then you must do this!
Beginner
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
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
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
Automatically Align Top

Automatically Align Top

Automate formatting cells to align top. Either by a time-based trigger or every time you edit cells.
 Automatically Check Past Stages

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the past stages also check.
Beginner
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()
Vertically Stack and Sort Data

Vertically Stack and Sort Data

It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.
Beginner
SORT()
Send Better Email When Google Form Filled Out

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.
Intermediate
Every Google Drive File Created in Last 24 Hours

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
Intermediate
Reformat Pasted Cells Automatically

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.
Intermediate
Add NPS to Your Google Site

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Intermediate
AVERAGE()
Better Email Form on Google Sites

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Advanced Intermediate

Displaying items 241-260 of 354 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