TRY ME!
→ Random Tutorial

184 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
❌
Can't Find a Video?: Members can reach out and ask me anything!

Create a Podcast Advertising Calculator

Create a Podcast Advertising Calculator

Build from scratch a calculator to figure out podcast advertising rates.
Create A Video Course in a Google Sheet | LMS in a Google Sheet

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 Data validation Intermediate
COUNTA() COUNTIF() IF() SPARKLINE()
Create an Email Campaign Stats Calculator

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
CONCATENATE() ROUNDDOWN() UPPER()
Creating A Dark Mode Theme | Announcing Dark Habits

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
ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +6 more
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

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
Create a Radio Button From Checkboxes Using Google Apps Script

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.
Data validation Advanced
IFS() NOT() OR()
Create a Summary Tab with Min and Max

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.
Intermediate
INDEX() MAX() MIN()
How To Create An AutoFill in Google Sheets

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.
Beginner
INDEX() MATCH() VLOOKUP()
Create a Public Sheet and Private Sheet: Using ImportRange()

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

Stick around after the 1st portion of the video for bonus content.
Intermediate
FILTER() IMPORTRANGE()
Create a PR Agency From Scratch

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script
Intermediate
ARRAYFORMULA() FILTER() JOIN() SPLIT()
Escape Spreadsheet Hell A Mini Game

Escape Spreadsheet Hell A Mini Game

Beginner
Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
 Spreadsheet Automation 101: Variables

Spreadsheet Automation 101: Variables

Dive deeper into the world of variables. Learn what variables do. Learn how to assign information to variables.
Spreadsheet Automation 101: Dot Notation

Spreadsheet Automation 101: Dot Notation

Learn how Dot Notation allows you to go deeper into the functions.
Spreadsheet Automation 101: Parentheses

Spreadsheet Automation 101: Parentheses

We’ll tackle the importance of parenthesis, as well as when we should not use them. Learn how to make a functional function with parentheses. I’ll also teach you how to fix an error you might get with using parentheses.
Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp

Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp

Learn to write codes in Apps Script. Understand what SpreadsheetApp is used for. Get to know getActiveSpreadsheet and use it correctly.
Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax

Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax

Make A1 not so limited. Learn more about A1 Notation and how it can be changed to row, column. Do more with A1 Notation.
Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()

Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()

Learn the difference between getActiveSpreadsheet() and get ActiveSheet(). Don’t get confused. Learn more with this lesson.
Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Get Values is done in the Apps Script. In this lesson, you’ll learn what changing .getValue() to .getValues() do. You’ll also learn about Logger and For Loop, which I mention here briefly.
Spreadsheet Automation 101 Lesson 2: For Loop

Spreadsheet Automation 101 Lesson 2: For Loop

Learn about the syntax of the For Loop. Find out how to do fantastic automations.

Displaying items 41-60 of 184 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons