81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Sheet Theory

22 Tutorials

2 hours and 40 minutes

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.

22Tutorials

Strategic ideas, examples of sheets you can sell or create as lead magnets
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.
Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.

3

Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.
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.
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.
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.
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.
You can easily add your own links and improve your bio for free.

9

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.
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
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
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.
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.
Created a daily email with a motivational quote in the subject.
Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0
A quick video to share with you this theory. Consider repositioning your headers as labels in a dashboard.
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.
Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
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.
Learn the best fonts to use in Google Sheets.