Latest

Hold a Giveaway Raffle in a Google Sheet

It’s the holiday Christmas season and I just thought it would be really cool to create a giveaway in a Google Sheet. Now, however you determine to get names or usernames may be Twitter handles into a Google sheet. That's up to you. You can use a Google form.

Atomic Sheets

What if it only took you two clicks to make your Sheets better? Would you do it? This is exactly what you get out of Atomic Sheets: Add elements to your sheet with just two clicks.

Create a Many to Many Database inside Google Sheets

In this tutorial, I’ll show you how to create a many to many database inside Google Sheets. If you ever ran into the problem of wanting to put multiple categories into just one cell, you’ll want to keep reading below because that’s exactly what I’ll teach

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

The point of Better Sheets is to make your life in Google Sheets better. Quite specifically, you should enjoy your time in Google Sheets. You should feel confident. You should feel like you have a control over Google Sheets and that you don't get lost inside of Google Sheets. I

Brutal Calendar Craigslist Edition 2023

I designed a calendar that looks like early Craigslist. I'm calling it "Brutal Calendar, Craigslist Edition 2023." The video version of this tutorial was first released for Better Sheets members. You can watch that here. Members can access, copy, and preview this sheet for free. Why did I make this

How to Make a Small Fortune With Google Sheets | Create a Headline Generator in a Google Sheet

We're going to create a headline generator. We love Google Sheets here. If you love Google Sheets as well, you might want to consider becoming a member of Better Sheets.

150 VCs Actively Investing by Lemon.io

Sheet was provided for free on Twitter by Lemon.io and here I converted it to look and feel like Lemon.io's awesome design on their website. Turning a Google sheet to dark mode is always fun.

Getting Started Coding in Apps Script

What you need to know to access Apps Script inside Google Sheets. Code in Google Scripts. Automate business processes and more.

What's Inside Better Sheets?

Learning Google Sheets can be daunting! There's a lot to learn! That's why I have a lot of tutorials, templates and tools. There's more to Google Sheets than just Tips and Tricks.

Facebook Ads Mockup Generator

I do everything in Google Sheets, even a mock-up Facebook ads. I made this Facebook ad mock-up generator, and I wanted to share it with you. I think that if you're a beginner, this is going to be really cool. If you're intermediate, maybe you didn't know a little bit

Are you an A1 or B2 Kind of Sheet Guy?

When it comes to sheets you're either on Team A1 or Team B2, right? Meet Hugo Hamel. He uses Google Sheets every day. He sells a template for keeping track of finances. That's income and expenses. That's easy to manage even if you're not an accountant or a bookkeeper.

The Best Google Sheet Tutorial for Beginners on the IF() Formula

The IF() formula is one of the popular formulas in Google Sheets. It’s used for comparing two values to see if basic conditions are met. If you’re just starting with Google Sheets have no idea what this formula is about or if you’ve come across IF() formula

Learn Google Sheets Apps Script

Learning Google Sheets coding and Apps Script can have several outcomes and results. Become more productive, more of an asset to your company. No matter if you work there or if you own the company.

Build a Business in Google Sheets: House Painting Tracker

House Painting Work Tracker is a Google Sheets that can help house painters keep track of their painting jobs, materials, and expenses. The business can be used by individual painters, painting companies, or contractors who want to monitor their painting work's progress and expenses.

Sheet Makeover - Google Ad Writer

Taking a google ad writing sheet and making it better.

Are Google Sheets sexy now? Dropdown Chips might do the trick!

If you don't want to type in naughty or nice to a list of names, you can use now Google Sheets new dropdown interface in order to select this. In the menu, go to “Insert.” Then click on “Dropdown.” A right sidebar will appear, where we have some options. The

How hard is it to learn Google Sheets?

It's very complicated. It's a very complex subject, Google Sheets, because it's a tool that is incredibly diverse comprehensive. It can do almost anything.

Sheet Review! Better Band Bureau Better Schedule

We are back with another installment of sheet improvement. This time it's from James from the Better Band Bureau. Love better things because this is Better Sheets. This tutorial will walk you through on how to make a schedule created with Google Sheets look better. → Watch the whole review on

Building a ChatGPT Clone in Google Sheets: A Step-by-Step Guide

TL;DR How to create a chat GPT clone in Google Sheets using OpenAI's API. The process involves styling the sheet and creating a chat interface. The video demonstrates how to use the API key, write prompts, and get responses using a variable called chat. It also shows how to

5 Advanced Formulas To Build a Simple Monthly Budget Template

Track your expenses, manage your finances, hoping to save money, plan for the future, and generally during the month you want to reduce stress. Use these advanced formulas to get more out of Google Sheets.

Five Frustrating Formulas and How to Conquer Them

Google Sheets formulas can be frustrating for a few reasons. First, you’re trying to remember what to use on the fly. Then you can't remember the name of a formula. If you do figure out the name, you can't remember the syntax. Then you don't know the proper way to write the data. FRUSTRATING!

Did Google Take A Feature Away From Users?

I think Google Sheets might have taken a feature away with dropdown menus with the new dropdown chip. It seems as though we're missing one of the key features that a lot of people used.

Manage Your Wedding Guest List with these 5 Advanced Google Sheets Formulas

When it comes to planning a wedding, one of the most important aspects is managing the guest list. Keeping track of who's been invited, who's RSVP'ed, and any special needs like dietary restrictions or allergies can be a challenge. Luckily, Google Sheets offers some powerful formulas and tools to help

Turn Your Apps Scripts into Native Formulas | Apps Script Custom Function Tutorial EASY

Today’s tutorial is going to be fun because we get to create a calculator and we're going to abstract or obfuscate it behind a Google Apps Script, which is going to be really cool. One of the concepts that I try to share with you in Better Sheets, if

Becoming a Google Sheets Pro: What You Need to Know About Google Sheet Courses

Maximize productivity with a Google Sheets course. Better Sheets offers tutorials, templates, tools, and monthly updates based on 10 years of professional experience and feedback from 5,000 students. Free resources aren't enough.

5 Books To Launch A Business

Here are 5 books that helped me launch Better Sheets. And now I'm a Google Sheet guru, selling Google Sheet Tools, Templates, and Tutorials. 📚 Launch 📚 Lost & Founder 📚 E-Myth Revisited 📚 Discipline is Destiny 📚 Competing Against Luck Watch The Video here Transcript , this is a true story. These five books have literally

Escape Spreadsheet Hell

See what Spreadsheet Hell looks like and escape it! Learn three keyboard shortcuts with this fun game I created. Escape Spreadsheet Hell… if you can! What is  “Escape Spreadsheet Hell”? “Escape Spreadsheet Hell” is a fun mini game I created. It has three levels. Three times the fun, all while

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

Write Better Tweet Hooks with Hot Hooks

Are you struggling to come up with catchy hooks for your tweets? Look no further than Hot Hooks, the tweet hook writing cookbook. In this video, I'll walk you through the process of using Hot Hooks to generate engaging hooks for your social media posts. Get Your API Key The

7 Best Beginner Tutorials Featuring the INDEX() Google Sheet Formula

Learn more about Google Sheets here You might have seen this INDEX formula everywhere. It's a great useful little formula that helps you get the particular piece of data you're looking for. I use it a lot to find the first item in a list. Pairing INDEX with MATCH is

Redesigning This Copywriting Tool | Spreadsheet Redesign

Changing the "feelings wheel" into a spreadsheet.

Easiest Mistakes to Make In Spreadsheets

The most fundamental mistake beginners make when working in spreadsheets. But once you know what this mistake is, We can recognize it and we can recognize when we're making this mistake. I'll show you some very simple changes that you can make to your spreadsheets as you're making this mistake.

Breaking Down a Billion Dollar Google Sheet

Did you know there are 1.5 billion Google Sheets users and that billionaires also use Google Sheets? There's a bunch of billionaires in this sheet. Jeff Bezos, Elon Musk, and Yuri Milner. Yuri Milner used a secret spreadsheet to make a billion dollars basically in 2011. There are billionaires

Automatic Weekly Backup of Google Sheets

This tutorial’s going to be really fun because it's a question that I've gotten asked a couple times recently. These things happen where I get a couple questions of the same, it's the same question a couple times, and then I get really excited when I get to write

Can ChatGPT Automate Spreadsheets?

We're going to see if ChatGPT can actually help us automate Google Sheets. I have used ChatGPT over the last few weeks and I actually used it to create a brand new Google sheet add-on. Go up to Extensions > Add-ons > Get add-ons: Search for Tiny Sheets. And if you ever

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

You're learning Apps Script. You're learning the code behind Google Sheets, and I wanted to give an overview and some tips, at least advice over how to think like a programmer. TL;DR • Don't memorize. Know where the information is. • Read the documentation. • Try things. Go for it. • Seek out

Automate Google Sheets without Apps Script, without Zapier

I've been doing a lot in spreadsheet automation using Apps Script. But I wanted to go back to some formulas that I think feel like magic. They make me feel like a wizard without having to code.

Google Sheets Error: Unknown Range Name and How to Fix it

A user asked me about an error, which is the "Unknown Range Name." By the time you’ve read this tutorial, you’ll know how to fix this error. What is the Unknown Range Name error? It’s an error that you get when the value that was entered does

Most Common Errors and How To Handle Them in Google Sheets

Most Common Errors and How To Handle Them in Google Sheets #N/A error #REF! error #NAME? error #DIV/0! Error #VALUE! Error #NUM! error #NULL! error

Organize Anything! - Build a Kanban Board / Trello Board

In this tutorial, we are going to organize anything. It's one of my favorite things to do, which is Kanban. “Kanban” is the Japanese word for billboard, but it's really a system that allows us to organize things. We have three things we want to organize here: * Life Things to

Every Locale Listed in Google Sheets and a Tool to Save Your Sanity

Hello, Better Sheet members and non-Better Sheet members! This tutorial is about every locale listed in Google Sheets. → Watch this tutorial on YouTube If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create

Make It Easier For Others To Use Your Google Sheets

In this tutorial, we're going to orient users better in Google Sheets. We want to help not just ourselves but also anyone who’s going to use a spreadsheet that we have created.

Ken Asks Can We Add Star Ratings in Google Sheets?

This tutorial answers the question, “How can we add star ratings?” The actual question is a little more involved he was asking one clip star ratings and unfortunately in order to do that I imagine you have to do a little bit of scripting. You can sort of do that

This Week in Better Sheets - Feb 12th, 2023

Make your sheets better 1% every day. Google Sheets can be boring. It can get complicated. But it doesn’t have to be. Here at Better Sheets, we don’t just make them better. We make them more fun, too.

Sell Daily – Unleash the power of language with this game-changing Google Sheets template

Sell Daily – 366 words that sell. Get access to absolutely unique 366 words that will help you sell. No duplicates!

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

In this tutorial, we're going talk about what you can automate in Google Sheets. Specifically, we're going to talk about triggers because there is a bit of a difference between semi-auto and automation. Semi automation Semi auto  happens a lot in Google Sheets, and actually that's my preferred way to

How to Gain Confidence in Google Sheets

You might be starting your journey in any way into spreadsheets. I wanted to share with you about more empowering ways to learn to code and to get through learning to code. I think the same could apply if you are just now getting into spreadsheets, if you have been

How can I count true and false?

In this tutorial, we’ll answer the question, “How can I count true and false or true or false?” The answer is if you have a column of true or false, you can use the =COUNTIF() formula. That's just =COUNTIF() and then you enter your range and then comma, True

Make More Money Selling Google Sheets

If you are an online business person – you have a company, a business service – and you want to increase your revenue, I would suggest selling spreadsheets. You can sell spreadsheets of your work, of the service you provide, checklists and worksheets that you already use, perhaps with your clients. In

Every Locale Listed in Google Sheets and a Tool to Save Your Sanity

Hello, Better Sheet members and non-Better Sheet members! This tutorial is about every locale listed in Google Sheets. If you live in a country that is not well represented with blog posts or someone makes a blog post about a Google Sheets issue, they create a Google Sheet formula and

100 Business Ideas Using Google Sheets and Gumroad

Get the inspiration for your next business with this Google Sheet! Download this today to access the Google Sheet that gives you different business ideas that you can actually start and sell on Gumroad. This sheet is a work in progress. I’ll keep updating this one, so stay tuned!

Upsides and Downsides of Google Sheets Conditional Formatting

Format your data based on certain conditions. Learn how to use Conditional formatting to quickly identify patterns and trends in your data. But there are downsides to Conditional formatting too.

Filter a Database in Google Sheets based on Dates, Checkboxes, and Dropdown selections!

In today’s tutorial, we’ll be answering the question from Mohamed. The question is “How do I filter a database in Google Sheets based on dates, checkboxes, and dropdown selections?”

Brutal Calendar - Craigslist Edition 2023

I designed a calendar that looks like early Craigslist. I'm calling it "Brutal Calendar, Craigslist edition 2023." The video version of this tutorial was first released for Better Sheets members. You can watch that here. Members can access, copy, and preview this sheet for free. Why did I make this

The story behind Sell Daily: How I built a Google Sheet template for powerful words

Here are 366 words to help you sell. These words can be used in tweets, emails, promotions, and even Facebook ads. Sell Daily is a list of words that jumpstarts your promotional muscles. This sheet and this set of words are meant to be used one a day.

The Best Alternative to Google Sheets is Google Sheets

If you find yourself frustrated with Google Sheets, it is likely due to a lack of knowledge and understanding of the software's features and functions.

How to Use Checkboxes for Approvals, and Change the Text from True_False to Anything

Today, we're going to take a basic function of Google Sheets, which is the checkbox, and we are going to take it to its nth degree. We are going to bastardize it. We are going to go crazy; get a little creative with checkboxes today. By the time you have

Beginners Make This Spreadsheet Mistake All The Time!

Today I'm going to explain the most fundamental mistake beginners make when working in spreadsheets. No matter what you use – Google Sheets, Microsoft Excel, Apple Numbers, or Libra Office – you might be making this mistake.

5 Magical Ways To Use the IF() Formula in Google Sheets

Today I'm sharing you five ways to use the IF function inside your Google Sheets. We're going to sprinkle a little magic on your sheets. Let's get started on what's going on first. I’ll show you each of them, all of them together, and then I'm going to break

Why I Want A One Cell Google Sheet

I’ve been using 1-cell sheets for a while now. And I use 1 column sheets too. Or 2 column sheets. So here are the reasons I use it and can imagine you can use little, tiny, small sheets too.

Google Sheets Green Color Hex Code

The Google Sheets green color is hex code: #0F9D58 Also known as Shamrock Green.  This is the same green as the green in Google's brand colors. Google's brand color Green: Pantone: PMS 7724 C Hex Color: #0F9D58 RGB: (15,157,88) CMYK: (82,0,67,11) Google Sheet's Default Background

Anything is Possible in Google Sheets, But Not Everything

It’s 2023, The new year just happened. Everyone’s excited to start a new year, a new month, and start on new year’s resolutions. I’ve seen many lists, many dreams, many goals. The problem is that there are many of them. Everyone wants to be happier, healthier,

Spreadsheets Explained! 5 Levels of Difficulty: From Basic Text Input to Google Apps Script

If you don't think spreadsheets are complicated and complex, then you might not be using them correctly. Or rather, you might not be unleashing all of the power of spreadsheets if you still think that spreadsheets are merely just cells that you put information into. You might not be using

Google Sheets Introduces New Dropdown Chips Feature in 2022

Google Sheets introduced dropdown chips, a new feature that allows users to create and customize dropdown menus in their sheets. In this article, we will explain how to use dropdown chips.

You Can Build a Business with Just a Google sheet!

I've written before, that you can launch a business with a google sheet, here and on Indiehackers.com Now I'm talking about the Pre-MVP. Before you have a business. Launch a google sheet. When you have an idea. Launch a google sheet. Some Crazy Ideas * Countdown to launch * Create a

Email Yourself a Cell from a Google Sheet, Every Day

Are you tired of checking that one Google Sheet every single day? You've got a stat you wish you had in your inbox, but it's stuck inside of a Google Sheet. Someone else puts updates into a sheet, but you have to check that sheet every day. Let's get it

How Do I Capitalize Each Word in Google Sheets?

So you want to capitalize each word in your google sheets cells. Sometimes it's called Proper or Title Case or Sentence Case. We have lots of options but only one formula does it in Google Sheets. That is PROPER(). PROPER() is useful Today, we’re going to learn about an

The Google Sheet Add-on That Can Save You From Headaches

See Google Sheets in a whole new light! The most eye-strain reducing add-on for Google Sheets, ever. Improve your productivity and increase your happiness in Google Sheets.

Extract URLs from Google Sheets

Today’s post is going to go into extracting URLs, which is a pretty interesting thing you might be frustrated doing by hand. What if you’re a VA, you have a VA, or you have other people working for you in Google Sheets? We want to get links in

5 Simple Ways to Take Your Google Sheets to the Next Level, Right Now

Admit it, your Google Sheets suck. Let's unsuck them, FAST! Today I'm going to share with you five simple ways to make your sheets better. Five things that you can fix right now to make them better. Are you ready to improve your Google Sheets and make better spreadsheets? Let’

How to Make an Interactive To Do List In Google Sheets

We’re making an interactive to-do list and we’re going to make it come alive! And it won’t even take you five minutes to learn this cool trick. Read more below and find out how it works. Interactive to do list in Google Sheets: Getting started Imagine this

How do I insert emojis into Google Sheets?

I’m going to answer the question, “How do I insert emojis into Google Sheets?” Inserting emojis into Google Sheets is common, and fun, way to make Google Sheets more personal. You can use Emojis for bullets points, or headers, or to convey direction to a Google Sheets user. By

Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users

If you know how to code, you'll learn in this step-by-step tutorial how to code in Google Sheets.

Escape Spreadsheet Hell

I made an escape game, in a Google Sheet. It teaches 3 Google Sheets keyboard shortcuts that you can use to literally escape spreadsheet hell. 1. Discover how to navigate around a spreadsheet quickly with your keyboard. 2. Discover how to reveal underlying formulas hiding within the cells. 3. Learn

Spreadsheets Explained over 5 Levels of Difficulty

Google Spreadsheets explained in five levels of difficulty. From Text and Formulas all the way to Apps Script. Watch Now: https://www.youtube.com/watch?v=UsWuxvVypZM Transcript If you don't think spreadsheets are complicated and complex, then you might not be using them correctly. Or rather you might not

Roasting Google Sheets

Just dropped a new video on YouTube.com/BetterSheets In this video I breakdown what's working and what can be improved on sheets out in the public. Watch Now Full Transcript [00:00:00] Introduction Well, good morning today is a really fun day or morning because I am roasting

Find New Additions to a Main List in Google Sheets

Watch this Google Sheets tutorial to find out how to know which new names appear on a new list, that's not on a main list. Transcript Hello, welcome to Better Sheets. The YouTube channel brought to you by BetterSheets.co, today's video is a question from a member.   Wallace asked

Build A Business: PR Agency in a Google Sheet

In this video I present two potential business models for a PR Agency. Transcript Welcome. If you've ever wanted to curate content from the web, start a business, curating that content, and then also selling that content that you're  curating, but also create a service upsell in order to continue

Absolute Basics of Google Sheets

The Beginner's guide to Google Sheets course Watch: https://youtu.be/-rsmpf1wE60 Transcript Welcome to: Absolute Basics. The beginner's course here on BetterSheets.co Thanks for watching. This is actually very basic and very. In depth on what a spreadsheet is. In other words, this is an beginner's guide to

Figure Out Frequency of Numbers

Transcript Hi, welcome to today's video. Today's video is gonna be counting numbers or counting IDs, counting text emails.  This came about in actually in a very interesting, unique way. It came through Twitter. You can go follow me on Twitter at @kamphey but here on YouTube, I wanted to

Make $3,000 a Month with Google Sheets

How to make $3,000 a month. No coding, no consulting. We're gonna make a business and we're gonna do it all in Google sheets.

Making SaaS in A Google Sheet

Build it So You Don't Have To Buy It I like making insanely useful Google sheets. My Google sheets take the place of software. Sometimes saving hundreds of dollars a year. For Example: Make a headline generator instead of buying an AI Writer. Here are a few really cool softwares

10 Ways to Promote Your Google Sheet

You've made something, in a google sheet. • a resources list • a checklist • a template • a tool • anything Now you want to promote it - market it - share it. I'm sure you've already thought through a truck load of places that your target audience already spends time at. You've exhausted

You Can Launch A Business with a Google Sheet

Google sheets are powerful for organizing and managing your business, but they can also be used to launch a business from scratch. Jack Dorsey launched a $1B global relief fund via a google sheet. You can start a business in a google sheet. Wait, but he has money... how do

Hide Gridlines

One quick way to make your sheets easier to read: Hide Gridlines Go to the View menu Click on “Gridlines” and the check will disappear. Why? Because then your readers’ eyes will only go where you want them to go. Give your sheets more whitespace, just like a website should

How to Use Alternating Colors to make a Summary Page

This tip goes over how to use Alternating Colors. Alternating Colors is a built in feature of google sheets. It’s in the menu when you pick a fill color. Use Alternating colors with your tables, and uncheck View: Gridlines. One bonus tip here, give your tables breathing room, by

Font Colors That Don't Make Your Eyes Bleed

This tip is to give your eyes a rest. If you work in sheets hours each day, the high contrast black and white grid starts to hurt.