TRY ME!
→ Random Tutorial

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

Create Your Own API by Deploying a Web App

Create Your Own API by Deploying a Web App

See how you can create your own API using Google Sheets' Web App feature. Deploy a web app and write doGet() to enable others to use an API you create yourself.
Advanced
IMAGE()
I Created an Advent Calendar

I Created an Advent Calendar

Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.
Beginner
IMPORTRANGE()
SECTION 1 - You Are The Sheet

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.
 Easiest Sheet Ever to Sell

Easiest Sheet Ever to Sell

Idea Graveyard - Create a Decaying Checklist

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.
Intermediate
Create Your Own NIGHT Mode (like PRIDE)

Create Your Own NIGHT Mode (like PRIDE)

Create easter eggs in your sheets.
Conditional Formatting Intermediate
AND()
Create a Branded Lead Magnet from Qualitative Data

Create a Branded Lead Magnet from Qualitative Data

Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.
 
The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.
Intermediate
AVERAGE() COUNTA() COUNTIF() FIND() HYPERLINK() +7 more
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
Weird Idea: Find a Great Sheet Domain Name

Weird Idea: Find a Great Sheet Domain Name

Find a domain to get sheet ideas.
Intermediate
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
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
Why can't people fill in my Google Form?

Why can't people fill in my Google Form?

The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
 Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
Create an Automated Task List

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. Add a checkbox when adding a task. Add a timestamp when done. Also emailing every day the top task.
Intermediate
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
Email Certain Department Based on Google Form Entries

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.
Advanced
Make a Tour of Your Sheet

Make a Tour of Your Sheet

create a tour of your sheet for users who might be using your sheet and need to know what to do on each tab.
Advanced
Expense Tracker Template with Data Entry Form Inside Sheets

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.
Intermediate
FILTER() IFNA() SUM()

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