Tools, Templates, & Tutorials

535Google Sheet Tutorials

Discover the Power of Productivity with Our Exclusive Library of Google Sheet Tutorials!

Unleash your full potential with our comprehensive Library of Google Sheet Tutorials. Dive into the world of seamless data management and analysis with our tutorials, your gateway to mastering the art of Google Sheets.

Why Choose Our Google Sheet Tutorials?

🚀 Maximize Your Efficiency:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precision at Your Fingertips:

Master Google Sheets Match and Indirect functions, ensuring your data is always accurate and up-to-date. Say goodbye to errors and hello to precise, reliable results every time.

💡 Expert Tips and Tricks:

Explore the best-kept secrets of Google Sheets, including adding emojis to your spreadsheets and creating powerful combinations. Impress your colleagues and clients with visually appealing and informative sheets.

🔧 Google Script Magic:

Delve into the world of Google Script and learn how to generate PDFs with just a click. Elevate your document game and streamline your reporting processes effortlessly.

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

Beginner

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.

Beginner

Adding Number and dot to rank or order lists

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution

Beginner

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0

Beginner

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.

Beginner

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.

Beginner

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.

Intermediate

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.

Beginner

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Advanced Data validation

Better Domain Portfolio Template

Create a better list of domains.

Intermediate

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Advanced

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Enable your apps script functions be auto completed while you're using Google Sheets.

Advanced

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.

Beginner

Learn simple keyboard shortcuts to save you time

Learn some simple keyboard shortcuts.

Intermediate

How to Trigger Macros Daily

Automate your apps script and macros you can record.

Advanced

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Build a list of domains you can buy right now. Easily check if the domain you want is still available.