TRY ME!
→ Random Tutorial

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

Naughty or Nice? - Google Sheets' New Dropdown Chips

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?
How to Iterate Counting Blank Cells in Google Sheets

How to Iterate Counting Blank Cells in Google Sheets

Count different types of blank cells. Cells with nothing in them.
Intermediate
ARRAYFORMULA() IF() ISBLANK() MAX()
Learn to Code in Google Sheets, For Programmers

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
IMAGE()
Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends! 

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.
Beginner
COUNTA() INDEX() RAND() ROUND()
Email Yourself a Cell from a Google Sheet, Every Day

Email Yourself a Cell from a Google Sheet, Every Day

Learn how to email yourself a cell from a Google sheet every day in just a few simple steps! This powerful technique will change the way you manage your data. Follow along and get ready to be amazed! 

Learn to automate an email, with data, from a sheet.
Beginner
Two Things to Know When Starting to Learn Google Sheets

Two Things to Know When Starting to Learn Google Sheets

Beginner
IF() ISBLANK()
Write Apps Script to Create a New Google Sheets Formula

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.
 How to Replace Text with a Blank Cell in Google Sheets

How to Replace Text with a Blank Cell in Google Sheets

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.
Beginner
The First Thing I Do When Starting a Google Sheet

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, I'll show you the ultimate way to revitalize your workspace and enhance your productivity. By changing the background and text color in Google Sheets, you can create a more personalized and visually appealing environment that suits your preferences. Join me as I guide you through the simple steps to achieve a vibrant and eye-friendly spreadsheet experience.

Get Sheet Styles here: https://sheet-styles.bettersheets.co/
Beginner
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()
Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.
Beginner
3 Ways to Count in Google Sheets

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE
Beginner
COUNTA() COUNTIF()
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.
Beginner
Google Sheet Basics - The Absolute Basics

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Beginner
Announcing Button Styles | A Free Google Sheet Add-On

Announcing Button Styles | A Free Google Sheet Add-On

A new free Google Sheets Add-On to make drop shadow buttons inside your sheets. Free for everyone. Announced to members first.
Quickstart Tutorial OpenAI API in Google Sheets

Quickstart Tutorial OpenAI API in Google Sheets

Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick start tutorial I show you how to take OpenAI's curl commands and change them into Apps Script to use GPT-3 inside of sheets. We write a tweet, we ask questions. And now you can use this power for greater good!
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.
CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.
Advanced
HYPERLINK()
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
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()

Displaying items 1-20 of 345 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