79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

Better Sheets
Create Free accountMember Login

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

Upgrade
AppSumo badge

Fab Sheets

40 Tutorials

3 hours and 56 minutes

This is all about designing better within sheets. where info goes, how it is displayed, fonts, colors, borders, etc.

40Tutorials

FREE

Better Than Happy | Redesign of The Feelings Wheel
Turning an infographic into a useful Copy Writing cheat sheet
Beginner

1

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

FREE

Learn to Love Your Sheets
Quick intro to a better experience of using Google Sheets
Beginner

3

FREE

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.

4

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

FREE

Introducing: Brutal Calendar
A calendar template designed like early Craigslist. A brutalism minimalist style calendar.
Beginner

6

Add a Checkbox to Turn on Dark Mode
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.

FREE

Merge Cells for Dashboards
to make better Dashboards consider merging cells.
Beginner

9

Dark Mode / Better Font Color

FREE

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/

11

Magical Things You Can do with Checkboxes - Google Sheets
Beginner
Export Your Beautiful Sheets to PDF
Create a PDF from your Google Sheet.
Consider Labels as Opposed to Headers

FREE

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!)
Most PopularBeginner

15

FREE

Coloring Cell Blocks for Others to Enter Data
Use neon blue to show where someone needs to enter data.
Beginner

16

FREE

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.

17

FREE

Great Sheets! Community Information Board by Seedtable.com

18

Roast: Hotel PPC Channel Cost Calculator
Intermediate
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
Basic Keyboard Shortcuts To Speed Up Your Productivity
Beginner

FREE

Basics - 5 Ways to Change Row Height
Beginner

23

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?
Yes, using conditional formatting we can do this.
Beginner
How to Refer to Other Cells - A1 and R1C1 Explained
Get down to basics of spreadsheets.
Beginner

FREE

Change the Default Font
Set a different default font for each sheet you open.
Beginner

26

Biggest Flaw In Dashboards with Dark Colors
An optical illusion in Google Sheets and how to fix it.

FREE

Basics - 4 Ways to Change Column Width
you might actually find something new and interesting about it. We're just changing the column width.
Beginner

28

FREE

Basics - Structure of a Sheet: Index() Row() and Column()
Let's figure out how a sheet is structured.
Beginner

29

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
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.
Beginner

FREE

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

31

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

FREE

Google Sheet Basics - The Absolute Basics
Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!
Beginner

33

FREE

Secure Your Sheets by BetterSheets.co
tactics on how to keep your sheets secure.
Beginner

34

How To Create An AutoFill in Google Sheets
Autofill inside of google sheets is possible with Dropdowns.
Beginner
Build a Thermometer for Savings Goals
Track your goals with a thermometer.
Intermediate

FREE

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

37

Restrict Access to a Cell if Another Cell is Blank
Having trouble with ppl filling in cells before other cells?
Data validationBeginner

FREE

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

39

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