Google Sheets Tutorials · Better Sheets

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.

Member Asks: How do I calculate from a set of Form entries?

Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.

ARRAYFORMULA()

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.

Beginner

CONCATENATE() COUNTA() IF() MATCH() ROW() +1 more

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.

Beginner

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.

COUNTA() COUNTIF() FILTER() IFERROR() MATCH() +1 more

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.

SPARKLINE()

Create a Self-Adding Dropdown Menu

Make a dropdown menu inside Google Sheets you can add to anything and it makes it available in the dropdown.

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.

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

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.

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

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.

Advanced

CONCATENATE() ROUNDDOWN() UPPER()

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.

Intermediate

ARRAYFORMULA() COUNTIF() LOWER() SORT() SPLIT() +1 more

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +3 more

Create a Summary Tab with Min and Max

Free tutorial for finding Minimum and Maximum data points.

Intermediate

INDEX() MAX() MIN()

Create Navigation Like A Book or Presentation

A pretty cool script I came up with to click and set active the next tab. No matter how many tabs/sheets you have. Makes a book-like page turning action. At the end of the video I say you have to wait, but now you can get the sheet and the script only. Spreadsheet Alchemy is still a work in progress.

Advanced

ChatGPT Clone in Google Sheets Part 1

In this tutorial, learn how to create a ChatGPT-like interface using Google Sheets and Apps Script. Record your questions and get answers from OpenAI's GPT-3 API. Follow this step-by-step guide to build your own interactive GPT-3 interface.

Style a sheet like ChatGPT. Use the correct colors and interface design.
Add new rows to record the questions/prompts.
Add rows for the responses, and answers we get from OpenAI API.

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

Displaying items 41-60 of 307 in total

TAGS

FORMULAS

TOPICS

307 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Roast: Mortgage Calculator for Google Sheets

Member Asks: How do I calculate from a set of Form entries?

How to Find Duplicates and create a Duplicate Detector

Create an Auto-Update Sales Chart: Trailing 12 Months

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Manage Your Wedding Guest List in Google Sheets

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Create a Self-Adding Dropdown Menu

Create Drop Shadows! This makes your dashboards pretty.

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

Make Unsplash in Google Sheets - Part 2

Make Your Lists Spicy Hot in Google Sheets

Create an Email Campaign Stats Calculator

Count How Many Subscribers In a Company by BetterSheets.co

Deep Inside Dark Habits Google Script

Create a Summary Tab with Min and Max

More LinkInBio Templates for Google Sheets | SheetInBio

Create Navigation Like A Book or Presentation

ChatGPT Clone in Google Sheets Part 1

ChatGPT Clone in Google Sheets Part 2