+ 20

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

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

Figure Out Frequency

Fid out how to get the frequency of ProductIds, or Names, or Emails. or how many times they appear in a sheet/column/row.

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.

Advanced

Build a Thermometer for Savings Goals

Track your goals with a thermometer.

Intermediate

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?

Data validation Beginner

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.

Intermediate

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.

Intermediate

Countdown Blank Row

Great for counting writing sessions, or tweets you're writing.

Beginner

Create a Public Sheet and Private Sheet: Using ImportRange()

Stick around after the 1st portion of the video for bonus content.

Intermediate

Quadrant to List and List to Quadrant

We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.

Intermediate

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor.

Beginner

Get Twitter Handles Easily by changing URLS to @

Change Urls to @ using Substitute()

Beginner

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends!

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.

Beginner

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.

Data validation Beginner

2 Ways to Hide Data

Hide data with these simple tricks. Just using the IF() formula.

Intermediate

How to Record Macros

Record a macro, to Insert a column every day.

Advanced

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.

Beginner

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

Write an apps script to delete lines easily.