Google Sheets Tutorials · Better Sheets

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

COUNTIF() IF()

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

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.

Advanced

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

VLOOKUP()

Better Header Fonts - Best Fonts To Use In Google Sheets

Find out what fonts to use to make your headers better.

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.

Advanced

IF() IMPORTRANGE()

How to Write a Function - Learn to Code in Google Sheets Part 2

Continuing to show you how to write a function in Apps Script.

Beginner

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script

Advanced

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks to do.

ChatGPT Clone in Google Sheets Part 2

We fix the problem of OpenAI's API not remembering our last questions. And we label the text as Human and AI. I also add an archive Chat and new Chat function to create a new chat fresh.

Advanced

Upgrade Google Sheets OpenAI Prompt to GPT 4

Upgrade to OpenAI's GPT 4 in your Google Sheets. And use GPT-3.5: Turbo for Powerful AI Prompt Calls!

Learn how the new model enhances chat capabilities, including distinct messages and system prompts. Boost your productivity by integrating AI into your Google Sheets.

Advanced

LEN()

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How!

Advanced

Why Different Cell References in AI Integration in Sheets?

Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.

In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.

This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.

Advanced

Create a Course Outline in Google Sheets

Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation.

Beginner

CONCAT() CONCATENATE() COUNTA() COUNTIF() IF() +4 more

Two Things to Know When Starting to Learn Google Sheets

Two things I would teach every beginner to immediately improve your skillset in Google Sheets:
1. How to Combine Formulas
2. How to Copy/Paste Apps Script Code to Your Sheet
Learn these two things in this quick video going over why I think these are important. And how unintuitive they are to beginners!

→ Learn more about Formula Combinations
→ Learn more Apps Script in Spreadsheet Automation 101

Beginner

IF() ISBLANK()

Introduction to Google Sheets™ Add-on Course

In this course we'll go step by excruciating step how to take a simple apps script from a bound script to your spreadsheet and turn it into a published Google Sheets add-on available to the public on the Google Workspace Marketplace.

MAKE Your Google Sheets Add-on WORK

In this section of the Add-on course we'll be making the apps script work as an Add-on.

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.

MAKE Your Google Sheets Add-on USABLE

In this section we're going to turn our apps script into an add-on. complete with add-on menu. (Yes it's different than a custom menu, slightly).

The things I go over in this section took a lot of trial and error. The first time I created a Google Sheets Add-on I was flabbergasted that it just didn't work like a Google Sheets Add-on. Until I did all the things I go over in this section.

Displaying items 81-100 of 333 in total

TAGS

FORMULAS

TOPICS

333 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

LinkTree in a Google Sheet

More LinkInBio Templates for Google Sheets | SheetInBio

Convert Your Bullet Journal To Google Sheets

Better Header Fonts - Best Fonts To Use In Google Sheets

Password Protecting Data In a Google Sheet Part 2 The Basics

How to Write a Function - Learn to Code in Google Sheets Part 2

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Hold a Giveaway Raffle in a Google Sheet

ChatGPT Clone in Google Sheets Part 2

Upgrade Google Sheets OpenAI Prompt to GPT 4

Add Title Case to Google Sheets

Why Different Cell References in AI Integration in Sheets?

Create a Course Outline in Google Sheets

Two Things to Know When Starting to Learn Google Sheets

Introduction to Google Sheets™ Add-on Course

MAKE Your Google Sheets Add-on WORK

Write Apps Script to Create a New Google Sheets Formula

MAKE Your Google Sheets Add-on USABLE