Google Sheets Tutorials · Better Sheets

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

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

Better Numbers and Bullet Points in Your Spreadsheets

Improve Google Sheets Readability
Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets.

Create Visually Appealing Sheets
Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.

Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting.

The Benefits of Using Bullet Points and Numbering in Spreadsheets
Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features:

Bullet points and numbering help to organize information in a logical and easy-to-follow way
They make it easier to scan and find important information quickly
They can help to emphasize key points and make them stand out from the rest of the data
They make your spreadsheet look more visually appealing and professional

Beginner

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

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

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.

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 To Add Columns in Google Sheets

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

Beginner

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script

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

Add a Word Count to Google Sheets

Count your words inside a sheet. Great for ad writing, novel writing, or if you need to meet minimums.

COUNTA() IF() ISBLANK() SPLIT()

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.

Beginner

CONCAT() ROW()

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

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.

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.

MAKE Your Google Sheets Add-on DISCOVERABLE

In this section of our Add-on course we'll get out of sheets for a bit and create marketing materials. I'll show you the templates I use to make websites very quickly. hint: It's CARRD!
I'll also show you how quickly I make the banner and logo. You might be as quick if you have your own company logo or you already have something made.

MAKE Your Google Sheets Add-on MARKETABLE

In this section we'll put our marketing materials to the test. We'll go through the ENTIRE process of asking for approval, getting rejected, and overcoming rejection to ultimately publish our Google Sheets Add-on to the world!

Check Your Google Sheets Add On Works

In this lesson we'll check if the add-on actually works and record a client ID video. A weird little thing that I've now done a few times so can hopefully show you how to easily do it without getting frustrated.

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.

Intermediate

Roast: Mortgage Calculator for Google Sheets

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

Displaying items 1-20 of 335 in total

TAGS

FORMULAS

TOPICS

335 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

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

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

Better Numbers and Bullet Points in Your Spreadsheets

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

Announcing Button Styles | A Free Google Sheet Add-On

Add Pics to Marketplace in a Google Sheet

How To Add Columns in Google Sheets

Add Tasks to Google Tasks From Google Sheets

Convert Your Bullet Journal To Google Sheets

Add a Word Count to Google Sheets

Make Your Lists Spicy Hot in Google Sheets

Add Title Case to Google Sheets

Introduction to Google Sheets™ Add-on Course

MAKE Your Google Sheets Add-on WORK

MAKE Your Google Sheets Add-on USABLE

MAKE Your Google Sheets Add-on DISCOVERABLE

MAKE Your Google Sheets Add-on MARKETABLE

Check Your Google Sheets Add On Works

Create an Internal Google Sheets Add-on

Roast: Mortgage Calculator for Google Sheets