Better Sheets

Explore ↓

Free ↓

Login
Get Instant Access

Topics → Sheet Theory

Includes

43 Tutorials

Free for Members

Improve your spreadsheet mindset. Think about sheets differently. I share more perspectives of how sheets can be used.  See sheets that are internal tools for yourself or sheets that you can sell, or even sheets you can give away as a lead magnet. These are great videos to watch if you're looking for inspiration or just want to sit back relax and get your mind reset.

43Tutorials

▶

Pros and Cons of Sheet Protection and Collaboration

Learn how to protect your Google Sheets while still collaborating effectively! Discover the three levels of protection and editability, as well as how to set permissions for specific ranges and cells. With Google Sheets, you can have the best of both worlds: a protected and collaborative sheet.
Data validation
▶

14 Sheet Ideas You Can Sell

Strategic ideas, examples of sheets you can sell or create as lead magnets
▶

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
▶

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.
Beginner
▶

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.
▶

FILTER Can Save You From Task Overload

If you have a list of tasks and statuses, the FILTER formula will help keep you from the brink of Overload by allowing you see each status in a different tab.

Great if you're assigning work to VAs or you just became overloaded with tasks in your own task management system.

A great alternative to Conditional Formatting as well.

And a sneaky new little Apps Script that saves the day.
FILTER()
▶

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step through making it better, with better fonts, and colors. As well as making it more branded to share Ali's brand message better as the sheet gets copied and used, and shared. Great tutorial for those wondering how to brand your own sheets. Make your own lead magnets, and share your brand's message via Google Sheets.
Beginner
▶

Can a Google Sheet have DRM?

Are you wondering if you can sell a google sheet and only allow buyers to use the sheet, and not share it? I answer that sort of question, with more questions! 
Advanced
▶

What is an add on? What problems can it solve?

Discover what an Add-on is, what it could possibly do and what kind of problems an add-on can solve. There are much more in depth idea driven videos later in the course. For those who might want to know exactly what an add-on is, this video help you out!
▶

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
▶

YNAB Origin Story From Expense Recorder to $10M a Year Revenue

▶

Maximize Spreadsheet Sales to Startups

A Review of Gary's AARRR Tracker and Landing Page Strategies that you can employ if you're selling templates, spreadsheets, and google sheets to Startups.

Explore how to enhance a spreadsheet landing page's appeal and effectiveness. Discover innovative strategies for crafting compelling landing pages, learn the art of selling solutions (not just spreadsheets), and get tips on leveraging Google Sheets to create digital products that truly resonate with your audience. 

Whether you're a seasoned spreadsheet seller or just starting out, this video is packed with actionable advice to elevate your sales game. Tune in and transform your spreadsheet into a sellable sensation.

3 Key Takeaways
  • Market spreadsheets as problem-solving solutions, not just as templates or tools.
  • Design landing pages that tell a compelling story and focus on the benefits and solutions offered by the spreadsheet.
  • Utilize Google Sheets' advanced features and automations to enhance functionality and add value to your spreadsheet product.

If you want to automate your spreadsheets more, take the course: Spreadsheet Automation 101.
Intermediate
▶

Tracker Tactics

Tactics to build different kinds of trackers you can sell as digital products.
▶

The First Thing I Do When Starting a Google Sheet

Beginner
▶

How to Redirect Domains to Google Sheets and Google Docs

Learn how to use URL forwarding to Redirect Domains to Google Sheets and Google Docs. Also included is a new feature I like to in Google which is Publish To the Web. In a previous video about this topic I might not have mentioned that.
Intermediate
▶

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Intermediate
INDEX() MATCH()
▶

More LinkInBio Templates for Google Sheets | SheetInBio

You can easily add your own links and improve your bio for free.
Beginner
▶

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.
▶

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.
SUBSTITUTE() JOIN()
▶

How Starter Story Designs Data

Beginner
▶

Turn Bland Sheets Into Glam Sheets!

A few tips to make your Google Sheets look better.
Beginner
▶

How do I prevent people from sharing my spreadsheets by making a copy?

Beginner
▶

Can I get alerted when a tab name is changed?

Find out in this quick experiment if a tab name can be alerted to the owner of the spreadsheet. Great for owners and operators who want to know if someone is changing the sheet.
▶

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
▶

How to Turn a Simple List into an Epic Lead Magnet

I got this lead magnet via twitter. It's simply a list of faceless youtube channel from a Faceless Youtube Academy. But I think it could have been a lot better. Let's explore ways to make this particular lead magnet into an Epic one.
Intermediate
IF() ISBLANK() ROUND()
▶

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"
Advanced Beginner Intermediate
▶

Organize Anything! - Build a Kanban Board / Trello Board

Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
Advanced
UNIQUE() COUNTA() FILTER() TRANSPOSE()
▶

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is going to be super, super helpful to you because I'm going to explain not just the sheet I want and what it does, but over the course of all of these, I think you'll get a sense of some really interesting ideas on how to make sheets that sell.
Advanced
▶

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.
Intermediate
ISBLANK() ISFORMULA() ISTEXT() ISURL() IF()
▶

How to Make Better Lead Magnets

Learn how to make better lead magnets from Google Sheet checklists. Great for marketers and solo operators trying to get more leads, more customers, more clients.
Beginner
IF() HYPERLINK()
▶

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Created a daily email with a motivational quote in the subject.
Intermediate
ARRAYFORMULA() RANDBETWEEN() LEN() IF() COUNTA()
▶

A Few New Spreadsheet Business Ideas

Learn how to import DropCatch data with 100,000 domains into a Google Sheet. Find out how to get a filtered list of domains with sheet in them. And how to generate ideas of what to build based on these found domains.

Leveraging Expired Domain Names for Google Sheets Business: The speaker discusses using expired domain names to create and sell Google Sheets templates or tools. He demonstrates how to find domain names related to 'sheets' and suggests creative business ideas around them.

Importing and Analyzing Data in Google Sheets: The process of importing CSV data into Google Sheets and manipulating it to find specific information (like domains containing the word 'sheet') is showcased. This highlights the versatility of Google Sheets in handling and analyzing data.

Idea Generation and Business Opportunities in Google Sheets: The speaker, Andrew Kamphey, provides several examples of how to generate business ideas using Google Sheets. He suggests various niches like WordPress-related spreadsheets, balance sheets for accountants, and even educational tools like math workbooks, demonstrating the wide range of potential applications for Google Sheets in various domains.
Intermediate
FILTER() ARRAYFORMULA() LOWER() IF() IFERROR() +1 more
▶

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.
Beginner
VLOOKUP() GOOGLETRANSLATE() INDEX() RANDBETWEEN() COUNTA()
▶

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0
Beginner
VLOOKUP() CONCATENATE()
▶

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets
  1. Squeezed Rows
  2. Garbage Data
  3. Looks The Same
  4. Crazy Column Width
  5. Where’s Waldo 
  6. Of Results
  7. Too Many Clicks
  8. Instructions Unclear
  9. Eye Strain and Headaches
  10. Lazy Conditional Formatting
  11. Too Many Cells
Conditional Formatting Data validation Beginner
IF() ISBLANK() ISEMAIL() ISURL()
▶

Consider Labels as Opposed to Headers

A quick video to share with you this theory. Consider repositioning your headers as labels in a dashboard.
▶

Dashboard Principles - Design a Better Dashboard Part 1

One of the best examples of a dashboard I got from a great talk on just totally like SASS dashboards, and they talked about the speedometer and why the speedometer is such a great dashboard is that it is it encapsulates all of the principles of what goes into a great dashboard.
▶

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!
Beginner
IFNA() SPLIT() JOIN() TRANSPOSE() FILTER() +1 more
▶

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Beginner
ROUND() HYPERLINK() IF() MATCH() INDEX() +3 more
▶

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
Beginner
▶

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.
Beginner
COLUMN() INDEX() ROW()
▶

Transform Information Into an Info Product

Transform your information into a money-making machine! Learn how to turn your data into an info product using Google Sheets. Easy steps to follow. Boost your business now! We are selling a Google sheet here. We're selling information, we're selling curation, we're selling the time and the effort and the energy and the focus around, uh, this kind of information that of course information is free online. But we'll make it better.
Intermediate
▶

My Favorite Fonts

Learn the best fonts to use in Google Sheets.
Beginner

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