Sheet Theory

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.

Tutorials

Pros and Cons of Sheet Protection and Collaboration

Learn how to protect your Google Sheets while still collaborating effect...

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

Advanced

Hide Gridlines for Better Communication

Without gridlines our sheets become a lot easier to communicate exactly ...

Beginner

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including...

FILTER Can Save You From Task Overload

If you have a list of tasks and statuses, the FILTER formula will help k...

FILTER()

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step thro...

Beginner

Can a Google Sheet have DRM?

Are you wondering if you can sell a google sheet and only allow buyers t...

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

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

Beginner

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

Learn how YNAB started as a spreadsheet. Get this and 15 more business s...

Maximize Spreadsheet Sales to Startups

A Review of Gary's AARRR Tracker and Landing Page Strategies that you ca...

Intermediate

Tracker Tactics

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

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, ...

Beginner

How to Redirect Domains to Google Sheets and Google Docs

Learn how to use URL forwarding to Redirect Domains to Google Sheets and...

Intermediate

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to ...

Intermediate

INDEX() MATCH()

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

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder th...

JOIN() SUBSTITUTE()

How Starter Story Designs Data

Learn how Starter Story, and Pat Walls, created a report that is well de...

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?

A video I did summarizing the 3 things you can do to help people who sha...

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

Better Numbers and Bullet Points in Your Spreadsheets

Improve Google Sheets Readability Improve the readability of your spread...

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

Intermediate

IF() ISBLANK() ROUND()

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks th...

Advanced Intermediate Beginner

Organize Anything! - Build a Kanban Board / Trello Board

Organize leads, life tasks, chores, assignments, anything into a kanban ...

Advanced

COUNTA() FILTER() TRANSPOSE() UNIQUE()

10 Google Sheets I Wish Someone Would Make

if you're looking for ideas on what sheets to make I think this video is...

Advanced

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use...

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

How to Make Better Lead Magnets

Learn how to make better lead magnets from Google Sheet checklists. Grea...

Beginner

HYPERLINK() IF()

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() COUNTA() IF() LEN() RANDBETWEEN()

A Few New Spreadsheet Business Ideas

Learn how to import DropCatch data with 100,000 domains into a Google Sh...

Intermediate

ARRAYFORMULA() FILTER() FIND() IF() IFERROR() +1 more

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.

Beginner

COUNTA() GOOGLETRANSLATE() INDEX() RANDBETWEEN() VLOOKUP()

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

Beginner

CONCATENATE() VLOOKUP()

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a ...

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

Dashboard Principles - Design a Better Dashboard Part 1

One of the best examples of a dashboard I got from a great talk on just ...

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Beginner

FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% com...

Beginner

FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users wi...

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

Intermediate

My Favorite Fonts

Learn the best fonts to use in Google Sheets.

Beginner

Tutorials

Pros and Cons of Sheet Protection and Collaboration

14 Sheet Ideas You Can Sell

What Sucks About Selling Spreadsheets And How to Solve These Problems

Hide Gridlines for Better Communication

Google Sheets Interface Changes

FILTER Can Save You From Task Overload

Ali Abdaal's Google Sheet | Year at a Glance

Can a Google Sheet have DRM?

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

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

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

Maximize Spreadsheet Sales to Startups

Tracker Tactics

The First Thing I Do When Starting a Google Sheet

How to Redirect Domains to Google Sheets and Google Docs

David Asks: About Primary Keys

More LinkInBio Templates for Google Sheets | SheetInBio

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

Build a Better ChatGPT Prompt Builder

How Starter Story Designs Data

Turn Bland Sheets Into Glam Sheets!

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

Can I get alerted when a tab name is changed?

Better Numbers and Bullet Points in Your Spreadsheets

How to Turn a Simple List into an Epic Lead Magnet

Google Sheets Easter Eggs Beyond PRIDE

Organize Anything! - Build a Kanban Board / Trello Board

10 Google Sheets I Wish Someone Would Make

Data Validation with Formulas

How to Make Better Lead Magnets

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

A Few New Spreadsheet Business Ideas

Study Better With Google Sheets

Most Common Errors and How To Handle Them in Google Sheets

10 Things I Hate About Your Spreadsheets

Consider Labels as Opposed to Headers

Dashboard Principles - Design a Better Dashboard Part 1

Allow Multiple Selections is in Google Sheets Yay!

Announcing Sell Daily and How I Built Sell Daily

How to Name Sheet Tabs

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

Transform Information Into an Info Product

My Favorite Fonts