+ 19

144Google 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

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Most Popular Intermediate

How to Make a Marketplace in a Google Sheet

Make a marketplace where sellers and buyers do not have to have edit access to a sheet.

Intermediate

Get Every Row 5 Times

Find out how to get a formula to get a row, but get it multiple times per row.

Intermediate

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Create awesome progress bars with sparkline formula. You can make progress bar colors can change based on the input.

Intermediate

Create A Video Course in a Google Sheet | LMS in a Google Sheet

Set up a list of video links, and a checklist for others to use.

Conditional Formatting Intermediate Data validation

Switch Data

We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.

Intermediate

How to Make a Quick CRM w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

Most Popular Intermediate

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.

Most Popular Intermediate

Find Keywords in Any Column. Create quick search dropdown to find keywords

Create a quick search dropdown to find keywords in any column.

Intermediate

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today!

Intermediate

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

Most Popular Intermediate

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

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

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

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

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

Find The Most Common Word(s)

Find out which words in your sheet are the most common. Highest count of each individual word.

Intermediate

Displaying items 121-140 of 144 in total