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.
43 Tutorials
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.
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.
Hide Gridlines for Better Communication
Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.
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.
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.
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!
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.
YNAB Origin Story From Expense Recorder to $10M a Year Revenue
Learn how YNAB started as a spreadsheet.
Get this and 15 more business stories at BetterSheets.co/started
Get this and 15 more business stories at BetterSheets.co/started
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
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.
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
Are you tired of the default look of your Google Sheets? In this video, I'll show you the ultimate way to revitalize your workspace and enhance your productivity. By changing the background and text color in Google Sheets, you can create a more personalized and visually appealing environment that suits your preferences. Join me as I guide you through the simple steps to achieve a vibrant and eye-friendly spreadsheet experience.
Get Sheet Styles here: https://sheet-styles.bettersheets.co/
Get Sheet Styles here: https://sheet-styles.bettersheets.co/
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.
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.
INDEX()
MATCH()
More LinkInBio Templates for Google Sheets | SheetInBio
You can easily add your own links and improve your bio for free.
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.
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
Learn how Starter Story, and Pat Walls, created a report that is well designed and packed with information.
Get the report at starterstory.com/solopreneur
Get the report at starterstory.com/solopreneur
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 share your sheet, not do it, or at least get some value from it.
More info on the course: sellingspreadsheets.com
→ Get OnlySheets
More info on the course: sellingspreadsheets.com
→ Get OnlySheets
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:
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
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.
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"
Organize Anything! - Build a Kanban Board / Trello Board
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
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.
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.
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.
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.
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.
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.
FILTER()
ARRAYFORMULA()
LOWER()
IF()
IFERROR()
+1 more
Study Better With Google Sheets
Made Ali Abdaal's study google sheet better.
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
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
The 10 Things I Hate about your Sheets
- Squeezed Rows
- Garbage Data
- Looks The Same
- Crazy Column Width
- Where’s Waldo
- Of Results
- Too Many Clicks
- Instructions Unclear
- Eye Strain and Headaches
- Lazy Conditional Formatting
- Too Many Cells
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!
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.
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.
Basics - Structure of a Sheet: Index() Row() and Column()
Let's figure out how a sheet is structured.
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.