Tools, Templates, & Tutorials

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

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit of Apps Script.

Intermediate

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

Intermediate

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically

Intermediate

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.

Intermediate

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Created a daily email with a motivational quote in the subject.

Intermediate

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.

Intermediate

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.

Intermediate

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.

Intermediate

5 Ways to Generate Random Numbers

generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.

Intermediate

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script

Intermediate

Build a Thermometer for Savings Goals

Track your goals with a thermometer.

Intermediate

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

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

2 Ways to Hide Data

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

Intermediate

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.

Intermediate

How To Sort A Filter

This will allows you to analyze and organize your data.

Intermediate Data validation

Ben Asks: How Do I Add 1 Month?

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