TRY ME!
→ Random Tutorial

336 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!

Highlight Row as You Move Your Cell Selection

Highlight Row as You Move Your Cell Selection

Checking data? This script changes bg color of entire row as you move your cell selection.
Conditional Formatting Beginner
How to Use Sheets For Network Building

How to Use Sheets For Network Building

Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.
Beginner
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
Conditional Formatting Intermediate
Add Cool Responsive Graphs to Your Stock Tracking Sheets

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!
GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()
Sheet Improvement: Better Business Idea Selection Framework

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.
ARRAYFORMULA() IFERROR()
How To Color Cell Blocks So Others Enter Data Easily

How To Color Cell Blocks So Others Enter Data Easily

Use neon blue to show where someone needs to enter data.
Beginner
Transform Information Into an Info Product

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
How to Refer to Other Cells - A1 and R1C1 Explained

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.
Beginner
Let's Make a Bookmarklet!

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.
Most Popular Advanced
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

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
IMPORTRANGE()
Basics - 4 Ways to Change Column Width

Basics - 4 Ways to Change Column Width

you might actually find something new and interesting about it. We're just changing the column width.
Beginner
Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Revolutionary Method to Manage Your Video Stories! Learn how to delete old videos in just 24 hours. Keep your content fresh and engaging. Click here for the ultimate guide. 
Advanced
CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more
New Syntax for WhatChanged Formula in Google Script

New Syntax for WhatChanged Formula in Google Script

revisiting the "what changed" custom function I built in a past video. Showing you more apps script
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()
Sheet Stories / Video Notes + ADDED: Email Notifications

Sheet Stories / Video Notes + ADDED: Email Notifications

Unlock the Power of Email Notifications! 📧 Dive into our latest video tutorial, where we show you step-by-step how to add email notifications to your Google Sheets. Stay ahead of the game, get instant updates, and keep your workflow seamless! Check it out now! 
Advanced
CONCATENATE() IF() INDEX()
2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

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

Write an apps script to delete lines easily.
Advanced
How to Name Sheet Tabs

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 Hide Data

2 Ways to Hide Data

Hide data with these simple tricks. Just using the IF() formula.
Intermediate
IF()
Equal, Equal, Not Equal, Not Equal - How to Tell if Two Cells are the Same or Not The Same

Equal, Equal, Not Equal, Not Equal - How to Tell if Two Cells are the Same or Not The Same

Discover 4 easy ways to check if 2 cells in Excel are equal or not! Whether it's numbers, text, or dates, get the answer in seconds with simple tricks. Learn now in this video. 
EQ() NE()
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!

Displaying items 201-220 of 336 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