Google Sheets Tutorials · Better Sheets

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!

Beginner

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

COLUMN() IF() INDEX() MID() TEXT()

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.

Beginner

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0

Beginner

CONCATENATE() VLOOKUP()

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

Beginner

FILTER() IMAGE() INDEX() MATCH()

How do I Insert Emojis into Google Sheets?

Using Control+Command+Space in inserting emojis into Google Sheets.

Beginner

Create a Headline Generator

Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.

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

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit of Apps Script.

Intermediate

IF() ISBLANK()

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?

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.

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Without using 3rd party tools here is the javascript, html and the sheet you will need. and step by step instructions on how to use it.

Advanced

Better Google Ad Writing Tool Sheet Makeover

Got an amazing tool from Inside Google Ads course by Jyll. She shares this tool, and I went for 30 minutes reviewing it, improving it, and redesigning it. Hope members can learn from this video. Jyll graciously allows me to share this sheet with members only!

CONCATENATE() IF() ISBLANK() LEN()

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!

How To Add Columns in Google Sheets

Do you know all the ways to add columns to your Google Sheets?

Beginner

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.

Create a 2x2 Priority Matrix

Boost Your Productivity with a Priority Matrix: Learn How to Prioritize Your Tasks and Achieve More! Join us in this different kind of video and discover the best tips and tools to create a two by two grid that helps you determine what's important and urgent. Perfect for daily planners, long-term projects, decision-making, gift-picking, and more! Don't miss out on this collaborative and time-saving approach!

Great use case for the formula combination of JOIN/FILTER.

FILTER() JOIN()

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a row of data based on a single criteria in a column. Great for sales teams and maintaining a CRM.

Create a Guess The Number Game | Challenge!

Use random number generators to make a number guessing game.

Intermediate

RAND() ROUND()

Displaying items 81-100 of 299 in total

TAGS

FORMULAS

TOPICS

299 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Google Sheet Basics - The Absolute Basics

Wordle in a Google Sheet | Work in Progress

Redirect a Domain to a Google Sheet

Most Common Errors and How To Handle Them in Google Sheets

Add Pics to Marketplace in a Google Sheet

How do I Insert Emojis into Google Sheets?

Create a Headline Generator

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

Twitter App Clone in a Google Sheet

Create a Timer with Apps Script

Naughty or Nice? - Google Sheets' New Dropdown Chips

Announcing Button Styles | A Free Google Sheet Add-On

Embed a Number in a Website from a Google Sheet

Better Google Ad Writing Tool Sheet Makeover

Quickstart Tutorial OpenAI API in Google Sheets

How To Add Columns in Google Sheets

Intro Video - Make Better Sheets

Create a 2x2 Priority Matrix

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

Create a Guess The Number Game | Challenge!