Great Sheets

Get inspiration from reviewing and breaking down great sheets found in the wild.

Great Google Sheets. Get inspiration from reviewing and breaking down great sheets found in the wild. These are sheets that have great design, great usability. In these videos I break them down and reveal their secrets. Learn how to make great sheets yourself.

What Makes a Great Google Sheet?

Before we dive into specific examples of great Google Sheets, let's find out what makes a spreadsheet great. A great Google Sheet should have the following characteristics:

Clean and Clear Design: A great Google Sheet should have a clean, easy-to-read design that highlights the most important information. Allows the user to find what they are looking for, or accomplish the task they came to the sheet to do.
Well Branded Design: A great design doesn't mean just adding ornamentation for the sake of it. It means that someone who uses your sheet knows it is an extension of your business, or community. They can tell you made it, it's for them, it's where they should be. A well branded designed sheet will make the spreadsheet experience seamless from your users other experiences with you.
Usability: A great Google Sheet should be easy to use and navigate. Users should be able to find the information they need quickly and easily. Navigation in complex sheets can be, well, complex. Make sure to think about what your user wants to do next, and where, and get them there.
Customization and Personalization: A great Google Sheet should be customizable to meet the specific needs of the user. In fact a personalized experience is important too. But this also can be related to communities. Does your user know this spreadsheet space is for them? If they can't tell, then you have some work to do. Not just that it's custom to a user, but that it's personalized and brings them joy!
Automation: A great Google Sheet should automate repetitive tasks to save time and increase efficiency. But not just timed and event based automations like triggers. There are simple faux-mations that you can create with Google Sheets Formulas. Formulas like IF() and ISBLANK() can be combined in wonderful ways. These are formulas that create experiences that seem like automation.

Google Sheet Formula Frustrations Solved

Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level.

From ABS() to YIELD(), Better Sheets has it all.

Better Sheets has got every crucial formula essential to enhance your Google Sheets skill

8Tutorials

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.

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.

This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..

Conditional Formatting Advanced

Life to Date

This is a review and improvement of Emmett Shear's Life to Date Sheet. Originally he tweeted about it and shared a sheet. I thought I could make it a bit better looking.

Visicalc 2023 Technical Walkthrough

welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.

Advanced

Great Sheets! Community Information Board by Seedtable.com

Incredible design and inspiration for us in our sheets.

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

Beginner

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.

Beginner

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

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

Data validation Conditional Formatting Beginner