Google Sheets Tutorials · Better Sheets

Build a Startup Pitch Generator in 20 minutes

Build a fully functioning AI powered startup pitch generator in 20 minutes. I saw a tweet listing startup accelerators and thought it would be cool to build a tool that edits my own startup idea into a personalized pitch to each startup accelerator fund. Get it for your google drive down below
https://docs.google.com/spreadsheets/d/1KevSvdwpONP89eBOe-8fDfp2fGlBafE7BAtI5wgGe2U

Get the AI script here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.

Beginner

What Sucks About Selling Spreadsheets And How to Solve These Problems

I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.

Advanced

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet into a cell.

CONCAT() HYPERLINK()

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

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.

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

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.

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.

Beginner

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.

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

How to Create a CRM in google sheets w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

Create a Podcast Advertising Calculator

Build from scratch a calculator to figure out podcast advertising rates.

Google Sheet Basics - The Absolute Basics

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

Beginner

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.

Beginner

Ken Asks: Can We Add Star Ratings?

One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.

Beginner

AVERAGE() SWITCH() VLOOKUP()

Aesthetics Teaser: How To Use Alternating Colors

How to use alternating colors in your spreadsheets.

Beginner

RANK()

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Build a list of domains you can buy right now. Easily check if the domain you want is still available.

TAGS

FORMULAS

TOPICS

109 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Build a Startup Pitch Generator in 20 minutes

Go to Specific Cell When Spreadsheet is Opened

What Sucks About Selling Spreadsheets And How to Solve These Problems

Creating a Custom URL Link for Your Spreadsheet

Create an Email Campaign Stats Calculator

Roast: Mortgage Calculator for Google Sheets

Create a Sheet of Sheets for Project Management and/or Data Management

Intro Video - Make Better Sheets

How to Refer to Other Cells - A1 and R1C1 Explained

Let's Make a Bookmarklet!

Create an Auto-Update Sales Chart: Trailing 12 Months

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

How to Create a CRM in google sheets w/ Dashboard

Create a Podcast Advertising Calculator

Google Sheet Basics - The Absolute Basics

Create Square Cells for Dashboards or Beautiful Information

Ken Asks: Can We Add Star Ratings?

Aesthetics Teaser: How To Use Alternating Colors

Creating A Dark Mode Theme | Announcing Dark Habits

Find Hundreds of Available Domains From Keywords with Concat and Array Formula