Google Sheets Tutorials · Better Sheets

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Learn about the strategy and concept of the SpreadsheetApp. Understand rows, columns, and cells better.

Combine Sheets Into One Sheet As It Happens

Jodi asked: ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place.

I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet. I just want it to come in one row after the next as it happens.

Other Videos Mentioned in this video:
https://bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formula
https://bettersheets.co/tutorials/spreadsheet-automation-101-lesson-2-onedit-trigger

Spreadsheet Automation 101: https://bettersheets.co/courses/spreadsheet-automation-101

Intermediate

IMPORTRANGE() SORT()

Turn Bland Sheets Into Glam Sheets!

A few tips to make your Google Sheets look better.

Beginner

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get this free review of your Google Sheets in 2024.
https://bettersheets.co/sheetswrapped

Beginner

DATEDIF() TODAY() YEAR()

Create Navigation Buttons in Sheets to Other Sheets

Add a button to go to another sheet inside your sheet.

Intermediate

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

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

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is going to be super, super helpful to you because I'm going to explain not just the sheet I want and what it does, but over the course of all of these, I think you'll get a sense of some really interesting ideas on how to make sheets that sell.

Advanced

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.

Beginner

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Create a photo search site inside with Google Sheets. Using this template you can empower users to: Enter a search term and get an image without leaving the sheet! And learn how to monetize this Google Sheet.

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

ow do I show the date and time for the last time something was changed in a sheet? So what's interesting is that this This shows you Google Sheets shows an version history up here and shows you the last edit, but sometimes we want to have that data available to us inside of the sheet.

NOW()

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Turning a drab sheet into a fab sheet. Transform your job search with this amazing job application tracker template! Get it now from the Land of Random newsletter and streamline your job hunt.

Roasting Google Sheets Intro

Reviewing sheets. We're going to get through this whole coffee and we're going to get through a bunch of Google sheets.

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.

Data validation Beginner

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.

Troubleshooting Bitly in a Google Sheet Script

Exclusive video only for Better Sheets members. This is, uh, troubleshooting your click tracking web app or slash sheet.

Advanced

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.

Intermediate

AND() IF() IFS() ISBLANK() OR() +1 more

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()

Displaying items 41-60 of 358 in total

TAGS

FORMULAS

TOPICS

358 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Combine Sheets Into One Sheet As It Happens

Turn Bland Sheets Into Glam Sheets!

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Create Navigation Buttons in Sheets to Other Sheets

Intro Video - Make Better Sheets

How to Make Hangman Game In Google Sheets

Ali Abdaal's Google Sheet | Year at a Glance

10 Google Sheets I Wish Someone Would Make

How To Export Your Beautiful Sheets to PDF

Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Roasting Google Sheets Intro

Magical Things You Can do with Checkboxes in Google Sheets

Make Unsplash in Google Sheets - Part 2

Troubleshooting Bitly in a Google Sheet Script

5 Ways to use IF() Formula to Create Magic in Your Sheets

Learn to Code in Google Sheets, For Programmers