TRY ME!
→ Random Tutorial

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

One Weird Google Sheet Formula for Bulk Publishing With AI

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!
Intermediate
IF() ISBLANK() SUBSTITUTE()
Project Based Task Management

Project Based Task Management

Create a better checklist for project based task management.
Conditional Formatting Beginner
COUNTA() COUNTIF() IF()
Big Year - a Whole Year in One Google Sheets Tab

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad.

Get perspective on your 2024 plan with this full year calendar template in Google Sheets.

All-Year-in-One Overview

Imagine having the entire year's schedule on one single page. BIG YEAR offers a comprehensive 12-month display, providing an at-a-glance view of your whole year. This holistic perspective makes it easier to plan long-term projects, vacations, and personal milestones, ensuring you never miss out on life's big events.

More info on the Gumroad page
 How to Count Numbers in a Row

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.
Beginner
AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Beginner
CONCATENATE() JOIN()
OpenAI API Prompt with Array of Cells

OpenAI API Prompt with Array of Cells

Create a prompt to OpenAI with an array of cells
Intermediate
CONCATENATE()
Move Blank Rows

Move Blank Rows

Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here
Intermediate
Automate Move Blank Rows

Automate Move Blank Rows

Intermediate
Count Merged Rows

Count Merged Rows

Count the number of cells or rows in a merged cell. This is a quick little code you can add to your sheets with the onOpen code.
Intermediate
One Million Checkboxes

One Million Checkboxes

Check out this fun onEdit() counting you can do with checkboxes in a fun sheet with 1 Million Checkboxes.
Anyone can log into google sheets and go here: https://bettersheets.co/checkboxes
Beginner
How to Insert Multiple Rows in Google Sheets (Easy to Hard)

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automatically. 
Advanced Intermediate Beginner
Reformat Pasted Cells Automatically

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.
Intermediate
Go to Specific Cell When Spreadsheet is Opened

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.
Beginner
Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
How to Format Timestamp to Day and Month

How to Format Timestamp to Day and Month

How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
Combine Filters in One Column

Combine Filters in One Column

Using the ampersand and ARRAYFORMULA to combine two filters into a single column.
Beginner
ARRAYFORMULA() FILTER()
Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula. 
Intermediate
COUNTA() COUNTUNIQUEIFS() FILTER() TEXT() UNIQUE()
Make AI-generated Poems Based on Name

Make AI-generated Poems Based on Name

Intermediate
How To Change Date Format Automatically

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.
Advanced

Displaying items 41-60 of 112 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