79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

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

Aesthetics & Design

39 Tutorials

4 hours and 43 minutes

Every house is a home, if you decorate it. Every home still needs to be livable, functional, useful. These videos not only make your sheets look good, they also help your sheets function. Meaning you won’t be looking around for hidden columns, you won’t have to tell people twice where to put the damn data. 

39Tutorials

You can easily add your own links and improve your bio for free.

2

A calendar template designed like early Craigslist. A brutalism minimalist style calendar.

3

AtomicSheets.com for 10 Free Elements Members get it free at: https://bettersheets.co/products

4

Find out what fonts to use to make your headers better.
Common mistake is highlighting the header of a table in a bold color.

6

A new free Google Sheets Add-On to make drop shadow buttons inside your sheets. Free for everyone. Announced to members first.
There are surprisingly few times you want to have blank cells, or even create blank cells. In this video I'll show you the good reasons you want blank cells.
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
Turning an infographic into a useful Copy Writing cheat sheet

10

Quick intro to a better experience of using Google Sheets

11

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.
I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.

13

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.
We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.

15

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution

16

Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.
From scratch we're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Every word can be capitalized with this formula.

20

Create little graphs with SPARKLINE() super easy!
We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.
Create an epic organization sheet of all your spreadsheets.
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.

26

Create a PDF from your Google Sheet.
We're actually gonna go build the dashboard today.
Track your goals with a thermometer.
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!)

31

Use neon blue to show where someone needs to enter data.

32

Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.
An optical illusion in Google Sheets and how to fix it.
to make better Dashboards consider merging cells.

35

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.
Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.

37

Go inside this apps script and sheet. See how it's designed and created.