TRY ME!
→ Random Tutorial

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

Turn Titles Into Lower Case Hyphened Slugs

Turn Titles Into Lower Case Hyphened Slugs

Create a slug maker inside your sheet. We'll take any title with any case, even if it's wrong. Our sheet template will lower case the whole line, and replace any spaces with hyphens. This way we can enter any kind of title we want and get a hyperlink slug out for use in blogs or cataloging.
Beginner
ARRAYFORMULA() LOWER()
FILTER Can Save You From Task Overload

FILTER Can Save You From Task Overload

If you have a list of tasks and statuses, the FILTER formula will help keep you from the brink of Overload by allowing you see each status in a different tab.

Great if you're assigning work to VAs or you just became overloaded with tasks in your own task management system.

A great alternative to Conditional Formatting as well.

And a sneaky new little Apps Script that saves the day.
FILTER()
Memento Mori | The Death Dashboard

Memento Mori | The Death Dashboard

In this tutorial I go from raw data to a full formed dashboard. In this particular case we're looking at the number of weeks someone might have left to live. A bit of stoic motivation, part baroque style. You'll see how I look for inspiration in the Memento Mori medallion and also in images representative of  "Memento Mori" then I use those colors in the images to make this dashboard.  

In addition to that we build an hour glass for the number of weeks we've lived and have left to live. This Hourglass of Life might be something you can incorporate into other kinds of dashboards. Don't be afraid to build visual representations of your data to easily see what's going on.
REPT()
Pros and Cons of Sheet Protection and Collaboration

Pros and Cons of Sheet Protection and Collaboration

Learn how to protect your Google Sheets while still collaborating effectively! Discover the three levels of protection and editability, as well as how to set permissions for specific ranges and cells. With Google Sheets, you can have the best of both worlds: a protected and collaborative sheet.
Data validation
Ali Abdaal's Google Sheet | Year at a Glance

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step through making it better, with better fonts, and colors. As well as making it more branded to share Ali's brand message better as the sheet gets copied and used, and shared. Great tutorial for those wondering how to brand your own sheets. Make your own lead magnets, and share your brand's message via Google Sheets.
Beginner
SOLUTIONS! Solve The Errors, Learn For Loop

SOLUTIONS! Solve The Errors, Learn For Loop

SPOILER ALERT! In this video are the full solutions to the For Loop problems you can solve. If you haven't tried yet, copy the sheet and make an attempt to debug all 9 For Loops.
Advanced Intermediate
Solve The Errors, Learn For Loop

Solve The Errors, Learn For Loop

Learn how to debug a For Loop. These are common errors that happen when coding in Apps Script, specifically around the For Loop. This is Part 1 and 2. Get the goal of capture the flag exercise and I give you hints to each one.
Advanced Intermediate
Calculate ROAS in Google Sheets

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.
Intermediate
CONCATENATE() ROUND()
Data Validation with Formulas

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.
Intermediate
IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()
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
Google Sheets Interface Changes

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.
Visicalc 2023 Technical Walkthrough

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.
Advanced
That Viral Growing Plant Progress Chart

That Viral Growing Plant Progress Chart

Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.
Data validation Beginner
COUNTIF() IMAGE() SWITCH()
How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
Beginner
AND() IF() OR()
How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
Beginner
How To Add Columns in Google Sheets

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?
Beginner
Frustrated With Sheets New Dropdown Pills?

Frustrated With Sheets New Dropdown Pills?

3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.
Intermediate
Show Sheet Tabs Based on Edit

Show Sheet Tabs Based on Edit

Show a sheet or tab based on a code being entered in one sheet.
Intermediate
Visicalc 2023 Design Walkthrough

Visicalc 2023 Design Walkthrough

Design walkthrough of VisiCalc 2023. Watch this if you'd like to see the choices made for this template and "product". I chose specific fonts and colors based on the original VisiCalc.
Intermediate
Visicalc 2023 Quick Walkthrough

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk through the features here. And get yourself a copy of the sheet below.
Beginner
SUM()

Displaying items 301-320 of 635 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

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons