Courses → Fab Sheets

Includes

43 Tutorials

Don't stand for ugly spreadsheets. Fab sheets shows you how to design better within sheets. where info goes, how it is displayed, fonts, colors, borders, etc. 

43 Tutorials

Better Than Happy | Redesign of The Feelings Wheel

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet
Best Header Font Ever

Best Header Font Ever

Learn about "Oswald" the best font for headers. You might fall in love with this font as much as I've fallen in love with Karla (the font). It helps your headers stand out without having to do much coloring or more. A little change to your header font and your sheets will look better.
Learn to Love Your Sheets

Learn to Love Your Sheets

Quick intro to a better experience of using Google Sheets
ARRAYFORMULA() IMPORTRANGE()
How Starter Story Designs Data

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
Sheet Review! 150 Active VCs by LemonIO

Sheet Review! 150 Active VCs by LemonIO

This lead magnet by the folks at Lemon.io is incredibly useful. 150 active VCs. I checked out their page and was like WHOA, what a site! In this video I turned their google sheet into an extension of their branding.
Anika Asks: How To Set Text Overflow All The Time

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.
Introducing: Brutal Calendar

Introducing: Brutal Calendar

A calendar template designed like early Craigslist. A brutalism minimalist style calendar.
Add a Checkbox to Turn on Dark Mode

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting
Create Drop Shadows! This makes your dashboards pretty.

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.
10 Things I Hate About Your Spreadsheets

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
IF() ISBLANK() ISEMAIL() ISURL()
Merge Cells for Dashboards

Merge Cells for Dashboards

to make better Dashboards consider merging cells.
Dark Mode / Better Font Color

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, doesn't mean we can't make it ourselves. Create dark mode in one click. You'll learn to make a dark mode toggle.
Better Font Colors

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/
Magical Things You Can do with Checkboxes in Google Sheets

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.
How To Export Your Beautiful Sheets to PDF

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.
Consider Labels as Opposed to Headers

Consider Labels as Opposed to Headers

A quick video to share with you this theory. Consider repositioning your headers as labels in a dashboard.
Add Icons To Your Sheets With a Domain Name

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)
IMAGE()
How To Color Cell Blocks So Others Enter Data Easily

How To Color Cell Blocks So Others Enter Data Easily

Use neon blue to show where someone needs to enter data.
Great Sheets! Corona Hiring Sheet

Great Sheets! Corona Hiring Sheet

Reviewing a Corona hiring sheet. A great example of using Google Sheets. I have high praise for the design and the use of forms for data validation. The sheet makes great use of white space, circular image, and icons instead of text. While I suggest other ways to monetize the job board, I acknowledge the creator's decision to avoid exploiting the situation.
Great Sheets! Community Information Board by Seedtable.com

Great Sheets! Community Information Board by Seedtable.com

Incredible design and inspiration for us in our sheets.
Roast: Hotel PPC Channel Cost Calculator

Roast: Hotel PPC Channel Cost Calculator

I have no idea what to do as a user, so let's make it better.
Better Header Fonts - Best Fonts To Use In Google Sheets

Better Header Fonts - Best Fonts To Use In Google Sheets

Find out what fonts to use to make your headers better.
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
Basic Keyboard Shortcuts To Speed Up Your Productivity

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.
Basics - 5 Ways to Change Row Height

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.
How to Refer to Other Cells - A1 and R1C1 Explained

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.
Change the Default Font

Change the Default Font

Set a different default font for each sheet you open.
Biggest Flaw In Dashboards with Dark Colors

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.
Basics - 4 Ways to Change Column Width

Basics - 4 Ways to Change Column Width

you might actually find something new and interesting about it. We're just changing the column width.
Basics - Structure of a Sheet: Index() Row() and Column()

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

Let's figure out how a sheet is structured.
COLUMN() INDEX() ROW()
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.
Use Cmd + Y To Do It Again, and Again, and Again

Use Cmd + Y To Do It Again, and Again, and Again

Very quick interesting little keyboard shortcut where you might not even know it exists. Repeat what you're doing, over and over again.
Create an Auto-Update Sales Chart: Trailing 12 Months

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.
SUM() IF() ISBLANK() INDEX() COUNTA()
Google Sheet Basics - The Absolute Basics

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Secure Your Sheets by BetterSheets.co

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.
MATCH() FILTER() MIN() INDEX() ARRAYFORMULA()
How To Create An AutoFill in Google Sheets

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.
INDEX() MATCH() VLOOKUP()
Build a Thermometer for Savings Goals

Build a Thermometer for Savings Goals

Track your goals with a thermometer.
REPT() TRANSPOSE() ROUND() SPLIT() IF() +1 more
Make Your Lists Spicy Hot in Google Sheets

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
CONCAT() ROW()
Restrict Access to a Cell if Another Cell is Blank

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?
NOT() ISBLANK()
How to Use Smarket

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold and then unlist those items to be sold. It uses two different forms for the listing and the unlisting. The key connection is that you use a unique number, or a unique text when entering the item to be sold. Then use that item to delist it once it's been sold. Also you can wait 7 days, and the item will be unlisted.
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today! 
IMPORTRANGE()
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Turning a drab sheet into a fab sheet. Transform your job search with this amazing job application tracker template! Get it now from the Land of Random newsletter and streamline your job hunt.