Better Sheets

Login

Get Instant Access

630Google 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!

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey

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.

Choose Your Anonymous Avatar

Now you can choose your avatar here on Better Sheets. Enjoy choosing between every available animal from Alligator to Wombat. You can choose Nyancat or Kraken too!

How to Add YouTube Thumbnails

Add the image of a youtube thumbnail with only a YouTube url into your Google Sheets. Great use case for Substitute() or Split() functions. Nice way to add a little visual flair to your sheets.

FIND() SUBSTITUTE() IFERROR() SPLIT() INDEX()

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().

FLATTEN() FILTER() SUM() UNIQUE() SORT()

Building a Year Progress Clone

Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.

SPARKLINE() TODAY() NOW() EOMONTH() SWITCH() +3 more

Create Instant QR Codes

Learn how to use a free Google API to create QR codes in sheet to any URL. And we'll learn how to make them magically appear as you enter domains.

ARRAYFORMULA() IF() ISBLANK() IMAGE()

Your First Formula

Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.

TRANSPOSE() CONCATENATE()

Automatically Delete All Sheets If Not Listed Name

A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!

Sheet Review of 50 ChatGPT Prompts

Tips to help improve the look, feel, branding of Better Sheets Member’s Free Lead Magnet. A free Google Sheet of ChatGPT Templates that just gets better by the end of the video.

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.

INDEX() IF() ROW() COLUMN() INDIRECT()

BetterSheets.co Tour for Lifetime Members

Find out all that Better Sheets has to offer you. Learn where to learn. Find out the features available to lifetime members at BetterSheets.co

Concat Because Concatenate is too hard to Remember!

One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!

CONCAT() CONCATENATE() JOIN()

Magical Numbering

Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)

COUNTA() SEQUENCE()

Seek Errors When Coding Apps Script

It's healthy programming. I'll show you some common errors you will encounter when you first start programming in Apps Script

Sheet Styles A Free Google Sheet Add-on by Better Sheets

Install Sheet Styles now: https://sheet-styles.bettersheets.co/

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.

TRANSPOSE() FILTER() JOIN() IFNA()

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

Learn how to think like a programmer and develop a coding mindset with these expert tips from a seasoned Google Sheets programmer. Don't fall for the common, ineffective advice, and instead follow this practical advice, including learning the process, figuring out how to search, and avoiding memorization. With these habits, you'll be on the path to successful coding.

It's hard to code. It's even harder to learn to code. This is my thought process to help you become resilient enough to learn, and continue to learn to code.

This Seems Like Automation

4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

IF() FLATTEN() TRANSPOSE() UNIQUE() IFERROR() +1 more

Displaying items 341-360 of 630 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons