Tools, Templates, & Tutorials

538Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

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.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.

Beginner

Get Data With Comments

A great way to manage your data if you have a small group of people who want to add data, but you want control over that data in the sheet. Give them the ability to comment on your data.

Beginner

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.

Beginner

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

How To Improve: 1,000 Business ideas: Business Idea Generator

Revolutionize Your Business Ideas with This Simple Template - Get Inspired in Minutes!

Advanced

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.

Most Popular Intermediate

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.

Intermediate

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.

Beginner

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.

Beginner

Roast: Sales Tax Calculator

I would not think that I would enjoy sales tax calculators, no one enjoys sales tax calculators, but when it's in a Google sheet, it's really exciting.

Intermediate

Consider Labels as Opposed to Headers

A quick video to share with you this theory. Consider repositioning your headers as labels in a dashboard.

Count Domains In a List of Emails - Part 1

I'm gonna talk about how to take a list of emails and figure out which domains count the domains. Few reasons we might do this is maybe we have a newsletter like I do, and we wanna find out which companies it's of like a business newsletter which companies subscribe to us more than others.

Intermediate

Roast: Hotel PPC Channel Cost Calculator

I have no idea what to do as a user, so let's make it better.

Intermediate

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.

Beginner

Add Team Members to the Quick CRM

We have a question from Rupesh about the quick CRM. He wants to add some team members.

Intermediate

How To Filter Dates (They Are Numbers Too!)

Dates are numbers so you can filter them with greater than and less than.

Beginner

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.

Beginner

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)